由于“原始数据”,PHP 脚本无法正常工作


PHP script is not working because of "raw data"

我有以下php代码:

<?php
include "../config.php"; //includes the connection data
$query="SELECT userinvites.user_id, COUNT( * ) AS user_count, users.fname, users.lname,        users.image
FROM userinvites
INNER JOIN users ON userinvites.user_id = users.user_id
GROUP BY user_id
ORDER BY COUNT( * ) DESC 
LIMIT 0 , 10"; //basic query that gets the data for leaderboard 
$result = mysql_query($query) or die(mysql_error());
echo '<table width="285" border="0" cellpadding="0" cellspacing="0">' ;
while($row = mysql_fetch_array($result)){
    //echo "-". $row['image']. " - ". $row['fname']. " - ". $row['lname']. " - ".      $row['user_count'];
    //echo "<br />";
    echo '<tr>';
    echo "<td height='40'> ". $row['image'].  "</td>";
    echo "<td>". $row['fname']. " ". $row['lname']. "</td>";
    echo "<td>" . $row['user_count']. "</td>";
    echo "</tr>";
}
echo '</table>';
?>

当我将此代码单独放在.php页面中时,它工作正常。 当我尝试在其他.php页面中导入此脚本时,我收到一条消息,指出 sth 的数据压缩有问题。对正在发生的事情有什么想法吗?

好吧,如果是原始图像数据,那么这应该适用于while循环(image/gif更改为适当的类型):

while($row = mysql_fetch_array($result)){
  echo '<tr>'
    .'<td height="40">'
      .'<img src="data:image/gif;base64,' . base64_encode($row['image']) . '">'
    .'</td>'
    .'<td>' . htmlspecialchars($row['fname'] . ' ' . $row['lname']) . '</td>'
    .'<td>' . htmlspecialchars($row['user_count']) . '</td>'
    .'</tr>';
}