loop within loop in PHP MySQL

Solution:

use this query

$result = mysqli_query($conn,"SELECT  blog_posts.* , upload_data.FILE_NAME from blog_posts,upload_data WHERE blog_posts.postID=upload_data.postID");
Copy code

and then print your results with print_r() function and check its get results or not.

Solution:

SELECT blog_posts.*, group_concat(upload_data.FILE_NAME) FROM `blog_posts` 
LEFT JOIN upload_data on blog_posts.postID = upload_data.postID 
GROUP BY blog_posts.postID
Copy code

Try like this you will get number of post rows and filename concadinated with commas if you have images. then Apply logic to display results. Any help you need. Don't hesitate to ask me.

Solution:

hope this work;

$post_id = 1337;
$conn = new PDO(......); //get connection
$conn->query('SET group_concat_max_len = 4096;');
$query = "SELECT bp.* , 
      (SELECT GROUP_CONCAT(ud.FILE_NAME SEPARATOR ',')  
       from upload_data ud where ud.postID=bp.postID) as files
     FROM blog_posts bp 
     WHERE bp.postID=:post_id ;";
$result = $conn->prepare($query);
$result->bindParam(":post_id", $post_id);
$result->execute();

//don't really need while for one row but oh well
while($row = $result->fetch()){

  $files=$row['files'];
  $files = empty($files) ? [] : explode(',', $files);
  ?>

  <div data-height="382">
      <ul>
      <?php foreach ($files as $file){?>
        <li data-transition="3dcurtain-vertical" data-slotamount="12">
          <img data-retina src="articles/user_data/<?php echo( htmlspecialchars( $file ) ); ?>">
        </li> 
      <?php } ?>
      </ul>
  </div>
  <div >
    Title : <a href="#" ><?php echo( htmlspecialchars( $row['postTitle'] ) ); ?></a>, <a href="#" ><?php echo( htmlspecialchars( $row['postCat'] ) ); ?></a>
    <span ></span>
    Tag : <a href="#" >Nllam</a>
    <span ></span>
    <a href="#" ><i ></i>12 Comments</a>
  </div>
<?php } ?>
Copy code