且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将div中的所有相关图像和相关注释显示为单独的div并重复新条目的包装div?

更新时间:2023-11-19 15:42:04

sql =SELECT * FROM images
JOIN posts ON(images.imagesid = posts.imgs)
ORDER BY postID;


result =


conn->查询(

I want to display all the related images for a comment in a box together but display the comments in a different div Something like on the image that I have attached.

The output that I want to get
JSFiddle Example in HTML

If there is a new post then repeat the main div with PHP.

I can't figure out how should I do this. I assume that I have to break the loop somewhere.

The database structure:
posts:

| commentid |  comment  | iamgesid |
------------------------------------
|     1     |   fool    |   5557   |
|     2     |  fool2    |   5585   |
------------------------------------



multiple_image:

| id |  image  | imagesid |
---------------------------
| 1  |  name1  |    5557  |
| 2  |  name2  |    5557  |
| 3  |  name3  |    5585  |
---------------------------



The code for fetching the comment with the related images:

$sql = "SELECT * FROM images
    JOIN posts ON (images.imagesid=posts.imgs)
    ORDER BY  postID";
  $result = $conn->query($sql);
  if (!$result) {
      trigger_error('Invalid query: ' . $conn->error);
  }

  if ($result->num_rows > 0) {
    // output data of each row
    $comment = '';
    while($row = $result->fetch_assoc()) {
      if ($row['name'] == NULL) {
        $imgs= '';
      } else {
        $imgs= "<img width='' src='../images/".$row['name']."' >";
      }

  if($comment != $row['content']){
      echo $row['content'];
     $comment = $row['content'];
  }
    echo $imgs;
  } 

 }



What I have tried:

I have tried to loop div as well but it is just looped the div itself.

sql = "SELECT * FROM images JOIN posts ON (images.imagesid=posts.imgs) ORDER BY postID";


result =


conn->query(