while语句中的PHP while语句？
while语句中的PHP while语句？
提问于 2016-09-14 22:22:05
到目前为止，Dbdb2代码示例只列出了所有帖子，但只显示了一条评论？到目前为止，我的代码只显示了一个注释？
请任何人的帮助，我真的需要帮助我是一个新手在编码和尽我最大的努力。提前谢谢你
<?php
include("../db/db.php");
{
/*if(isset($_POST["TimeLine"])){*/
$queryposts = "SELECT * FROM post";
$run_query = mysqli_query($con,$queryposts);
while($row = mysqli_fetch_array($run_query)){
$post_id = $row["post_id"];
$uid = $row["user_id"];
$content = $row["content"];
$like = $row["total_like"];
$date = $row["date_created"];
$uidpic = $row["profilepic"];
$email = $row["email"];
$pImage = $row["postimage"];
$pVideo = $row["video"];
echo "<b>POST: <b/><hr />".
$content."<hr >"
;
$querycomment = "SELECT * FROM comment WHERE comment_id = $post_id";
$run_queryb = mysqli_query($con,$querycomment);
while($row = mysqli_fetch_array($run_queryb)){
$ComId = $row["comment_id"];
$Comment = $row["comment"];
$ComDate = $row["comment_date"];
$ProfilePicpost = $row["profilepic"];
echo "<b>Comment: <b/><hr />".
$Comment."<hr >"
;
}
}
}
回答 1
Stack Overflow用户
发布于 2016-09-14 22:40:48
您在内部循环中覆盖了相同的变量$row。将其名称更改为任何其他名称。
$queryposts = "SELECT * FROM post";
$run_query = mysqli_query($con,$queryposts);
while($posts = mysqli_fetch_array($run_query)){
// Your post related code
$post_id = $posts["post_id"];
$uid = $posts["user_id"];
// Use $posts instead of $row
$querycomment = "SELECT * FROM comment WHERE comment_id = $post_id";
$run_queryb = mysqli_query($con,$querycomment);
while($comments = mysqli_fetch_array($run_queryb)){
// Your comment related code
$ComId = $comments["comment_id"];
$Comment = $comments["comment"];
// Use $comments instead of $row
}
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/39492864
复制相关文章
相似问题
腾讯云开发者
