如果数据库没有记录，则显示回显 - If Database has no record, Display echo?

If Database has no record, Display echo?

本文关键字：显示记录数据库如果 | 更新日期: 2023-09-27

所以我做了一个Profile类型的东西，带有状态更新。然而，当数据库中没有状态时，它会显示为空白。当然，我正在尝试让它变成这样，如果数据库是empty，那么echo "You have no Feed"。这是我的代码：

<?php 
$status = mysql_query("SELECT * FROM status WHERE user='$username' ORDER BY date DESC");
while($row = mysql_fetch_array($status))
if($row['user'] == '') { echo "You have no Feed"; } else {
{
echo "<table width='520'>";
echo  "<tr>";
echo    "<td width='53' height='57'  valign='top' rowspan='3'><img src='../includes/images/profile/$image' height='50px' width='50px' style='border: 1px solid #000'></td>";
echo    "<td width='411' valign='top'><font color='#CCCCCC'>". $row['sentby'] . "</font><br><font size='1px' color='#CCCCCC'>". $row['date'] . "</font></td>";
echo  "</tr>";
echo  "<tr>";
echo    "<td></td>";
echo  "</tr>";
echo "<tr>";
echo  "<td>";
echo "</td>";
echo "</tr>";
echo  "<tr>";
echo    "<td colspan='2' valign='top'><font color='#CCCCCC'>". $row['status'] . "</font></td>";
echo   "</tr>";
echo "</table>";
echo "</p>"; 
}
}
?>

我的个人资料的工作方式是，每个人都有自己的个人资料，如果你转到某人的个人资料并在他们的"墙上"发表评论，当然，它只会停留在他们的墙上。我的数据库创建为'id' 'status' 'user' 'sentby' 'user' (being the username of who's wall it was posted on)和'sentby' (to display who sent it)

因此，基本上，如果找不到用户名，我将需要'user'列进行匹配，如果没有找到用户名，则返回消息。

mysql_num_rows函数将返回查询获取的行数。这应该行得通。

     $status = mysql_query("SELECT * FROM status WHERE user='$username' ORDER BY date DESC");

   if(mysql_num_rows($status) > 0){
        while($row = mysql_fetch_array($status))
        echo "<table width='520'>";
        echo  "<tr>";
        echo    "<td width='53' height='57'  valign='top' rowspan='3'><img src='../includes/images/profile/$image' height='50px' width='50px' style='border: 1px solid #000'></td>";
        echo    "<td width='411' valign='top'><font color='#CCCCCC'>". $row['sentby'] . "</font><br><font size='1px' color='#CCCCCC'>". $row['date'] . "</font></td>";
        echo  "</tr>";
        echo  "<tr>";
        echo    "<td></td>";
        echo  "</tr>";
        echo "<tr>";
        echo  "<td>";
        echo "</td>";
        echo "</tr>";
        echo  "<tr>";
        echo    "<td colspan='2' valign='top'><font color='#CCCCCC'>". $row['status'] . "</font></td>";
        echo   "</tr>";
        echo "</table>";
        echo "</p>"; 
        }
        } else {
        echo "<p>This user has not yet updated their status.</p>";
        }