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'";