无法显示相同id的所有行-PHP


Cannot display all rows of same id - PHP

H,以前我在分页方面把脚本搞得一团糟。然后我的整个剧本都疯了。现在,我删除了所有与分页相关的脚本,突然之间,我无法显示相同id的所有行。例如。对于id 99,我在sql中有9行相同的id。但它只显示5行。请帮忙谢谢。

  $query="SELECT ua.* FROM useradvert ua INNER JOIN users u ON  ua.id =u.id
     WHERE ua.id='".$id."'";

$stmt = $conn->prepare($query); 
$stmt->execute();
$res2 = $stmt->get_result(); 
$row2 = $res2->fetch_array();

$_SESSION['name2'] = $row2['name2'];
$_SESSION['color2'] = $row2['color2'];
$_SESSION['hobby2'] = $row2['hobby2'];
$_SESSION['radiobtn'] = $row2['radiobtn'];
$_SESSION['kupon'] = $row2['kupon'];
$_SESSION['image'] = $row2['image'];
$_SESSION['image2'] = $row2['image2'];

在下面继续。。在同一页

while ($row2 = $res2->fetch_array(MYSQLI_ASSOC)){
echo "<li>".$_SESSION['name2'] = $row2['name2']."</li>";
    echo "<li>".$_SESSION['color2'] = $row2['color2']."</li>";
    echo "<li>".$_SESSION['hobby2'] = $row2['hobby2']."</li>";
    echo "<li>".$_SESSION['radiobtn'] = $row2['radiobtn']."</li>";
    echo "<li>".$_SESSION['kupon'] = $row2['kupon']."</li>";
    echo  "<li>".$_SESSION['image'] = $row2['image']."</li>";
    echo "<li>".$_SESSION['image2'] = $row2['image2']."</li>";}

您应该删除此代码,以便使用fetch_array()函数正确循环:

$row2 = $res2->fetch_array(); 
$_SESSION['name2'] = $row2['name2']; 
$_SESSION['color2'] = $row2['color2']; 
$_SESSION['hobby2'] = $row2['hobby2'];
$_SESSION['radiobtn'] = $row2['radiobtn']; 
$_SESSION['kupon'] = $row2['kupon']; 
$_SESSION['image'] = $row2['image']; 
$_SESSION['image2'] = $row2['image2'];

看起来您的sql查询可能导致了问题,请尝试删除双引号

$query="SELECT ua.*FROM useradvert ua INNER JOIN users u ON ua.id=u.id在哪里ua.id='".$id"'";

$query="SELECT ua.*FROM useradvert ua INNER JOIN users u ON ua.id=u.id哪里ua.id='.$id'";