我得到了下面的 php 代碼來搜索和顯示來自 mysql 的圖像，到目前為止工作正常，我想添加一個功能來顯示默認圖像，如果搜索結果在 mysql 中沒有找到記錄（$field5name）。我嘗試在其中添加“onerror”函數但不起作用，我的代碼中缺少什么？<!DOCTYPE html><html> <body> <!-- [SEARCH FORM] --> <form method="post" action="1-form.php"> <h1>SEARCH FOR USERS</h1> <input type="text" name="search" required/> <input type="submit" value="Search"/> </form><br/><div align="left"><Font size="4"><a href="logout.php" style="margin-right:80px;">LOGOUT</a></font></div><br> <?phpif (isset($_POST['search'])) { require "2-search.php"; echo '<table border="1" cellspacing="2" cellpadding="2"> <tr> <td> <font face="Arial">ID</font> </td> <td> <font face="Arial">OTP</font> </td> <td> <font face="Arial">EMAIL</font> </td> <td> <font face="Arial">STATUS</font> </td> <td> <font face="Arial">TIMESTAMP</font> </td> </tr>'; // DISPLAY RESULTS if (count($results) > 0) { foreach ($results as $r) { $field1name = $r["id"]; $field2name = $r["otp"]; $field3name = $r["email"]; $field4name = $r["is_expired"]; // $field5name = $r["create_at"]; $field5name = $r["jpeg_info"]; echo '<tr> <td>' . $field1name . '</td> <td>' . $field2name . '</td> <td>' . $field3name . '</td> <td>' . $field4name . '</td> <td><a href = ' . $field5name . ' target = "_blank"> <img src=' . $field5name . ' height="100" width="100"> </td> //<------------------- i am stuck here </tr>'; } $result->free(); } else { echo '<FONT COLOR="RED" SIZE="5"> NO RESULTS FOUND </FONT>'; }}?> </body></html>
1 回答
弒天下
TA貢獻1818條經驗 獲得超8個贊
您需要做的就是在代碼中添加一些測試，看看相關字段是否為空。不確定對你來說什么是空的所以我假設''
if (count($results) > 0) {
foreach ($results as $r) {
$field1name = $r["id"];
$field2name = $r["otp"];
$field3name = $r["email"];
$field4name = $r["is_expired"];
// $field5name = $r["create_at"];
$field5name = $r["jpeg_info"];
if ( $field5name == '' ) {
$img = 'default.png';
} else {
$img = $field5name;
}
echo "<tr>
<td>$field1name</td>
<td>$field2name</td>
<td>$field3name</td>
<td>$field4name</td>";
<td>
<a href='$img' target='_blank'>
<img src='$img' height='100' width='100'>
</a>
</td>
</tr>";
}
}
- 1 回答
- 0 關注
- 129 瀏覽
添加回答
舉報
0/150
提交
取消