PHP - SQL query only shows last result

Question

This only returns the last one of my rows:

<?php
				function all_infos_query() {
					global $connection;
					
					$query  = "SELECT * ";
					$query .= "FROM pages ";
					$query .= "JOIN subjects ";
					$query .= "ON pages.subject_id=subjects.id";
					$infos_set = mysqli_query($connection, $query);
					confirm_query($infos_set);
					return $infos_set;
				}
			
				
				function infos_content() {
					$infos_set = all_infos_query();		
					
					while($info = mysqli_fetch_assoc($infos_set)) {
						$output = htmlentities($info["content"]);
						$output .= " <br><br>";
					}
					mysqli_free_result($infos_set);
					return $output;
					
				}
			?>
            
            <?php echo infos_content() ?>

If I echo it like this it works (returns all rows):

<?php 
$result = all_infos_query();

if($result === FALSE) { 
	echo "query failed: " . mysqli_error($connection);
}
else {
	while($row = mysqli_fetch_array($result)) {
		echo htmlentities($row['content']);
		echo "<br><br>";
	}
}
?>

What do I have to change in the function infos_content() to also get all the rows? Thanks a lot!

Duane Lortie · Accepted Answer · 2016-10-12 16:58:42Z

2

This is because you redefine $ouput for every result

while($info = mysqli_fetch_assoc($infos_set)) {
                    $output = htmlentities($info["content"]); 
                    $output .= " <br><br>";

Instead, create $ouput outside the loop and append to it..

 $output ='';
while($info = mysqli_fetch_assoc($infos_set)) {
                    $output .= htmlentities($info["content"]); 
                    $output .= " <br><br>";

answered Oct 12, 2016 at 16:58

Duane Lortie

1,2601 gold badge12 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP - SQL query only shows last result

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related