首頁猿問盡管 MySQL...

盡管 MySQL 數(shù)據(jù)庫中有數(shù)據(jù)，但圖像不顯示

PHP

繁星點點滴滴 2022-06-11 10:32:28

目前，我的項目有問題。photo before在 MySQL 數(shù)據(jù)庫中，有兩個名為photo_afterBLOB的列。base64在將圖像顯示到 PHP 頁面時，我使用它來解碼圖像。主要問題是列中是否有數(shù)據(jù)photo_before或者photo_after它仍然顯示' noimage.jpg '。我不知道為什么。下面是我的代碼：<?php$report_id = $_GET['report_id'];$sql = "SELECT * FROM report LEFT JOIN users ON report.badgeid = users.badgeid LEFT JOIN team ON team.team_id = users.team_id WHERE report_id = :report_id";$query = $conn->prepare($sql);$query->execute(array(':report_id' => $report_id));while($row = $query->fetch(PDO::FETCH_ASSOC)){ $report_id = $row["report_id"]; $report_date = $row["report_date"]; $task_name = $row["task_name"]; $photo_before = $row["photo_before"]; $photo_after = $row["photo_after"]; $ot_start = $row["ot_start"]; $ot_end = $row["ot_end"]; $time_photo_before = $row["time_photo_before"]; $time_photo_after = $row["time_photo_after"]; $report_status = $row["report_status"];}?><tr> <td rowspan = '2'>Before Task</td> <?php if(!isset($row['photo_before']) || empty($row['photo_before'])) { echo "<td colspan='3'><img src='../../images/faces/noimage.png'/></td>"; }else{ echo "<td colspan='3'><img src='data:image/jpeg;base64,".$row['photo_before']."'/></td>"; } ?></tr><tr> <td colspan='3'><?php echo "Time: " .$time_photo_before.""; ?></td></tr><tr> <td rowspan = '2'>After Task</td> <?php if(!isset($row['photo_after']) || empty($row['photo_after'])) { echo "<td colspan='3'><img src='../../images/faces/noimage.png'/></td>"; }else{ echo "<td colspan='3'><img src='data:image/jpeg;base64,".$row['photo_after']."'/></td>"; } ?></tr>

查看完整描述

2 回答

qq_笑_17

TA貢獻1818條經(jīng)驗獲得超7個贊

empty() 函數(shù)返回 true 或 false 當變量數(shù)據(jù)存在并且具有非空、非零值時，它返回 FALSE。否則返回 TRUE。添加并嘗試，希望它會工作：

if(!isset($row['photo_after']) || empty($row['photo_after'])== 'true/false')

反對回復(fù) 2022-06-11

開心每一天1111

TA貢獻1836條經(jīng)驗獲得超13個贊

似乎問題出在 Your 上if( the problem is here )，|| / 或邏輯發(fā)送真如果 0|1,1|0 和 1|1...檢查你的 php 版本，".$row['photo_before']."你的 " 使用 " 或 '，我的使用'.$row['photo_before'].'