Retrieving and displaying data in Php from Mysql

Question

I want to retrieve firstName from the member table in z1760359 . When I execute the code , its only displaying the first name in the member table and the rest is not displayed

Member table in z1760359

select firstName from member

| Roberto   |
| Savannah  |
| Sai       |
| Adarsh    |
| Jane      |

$hostname='localhost';
$username='root';
$pass='';  
$db="z1760359";
$db1=mysqli_connect($hostname,$username,$pass,$db) or die('Oops something     went wrong ');
$query= "SELECT firstName from member";
$message1=mysqli_query($db1,$query);
$message2=mysqli_fetch_assoc($message1);
foreach($message2 as $r1)
  {
     echo"$r1";

     echo"<br>";
   }
?>

when we use mysqli_fetch... & looping after it, the first result can't be shown. Use myqli_fetch.. in while loop to display the records... — lakshman
– lakshman, Commented Apr 20, 2015 at 6:33

TALHA MALIK · Accepted Answer · 2015-04-20 07:07:13Z

3

The code is storing only the last row to the variable. Try with -

while($message2=mysqli_fetch_assoc($message1)) {
    echo $message2['firstName'];
    echo"<br>";
}

Use 'while' loop Instead of using foreach.

edited Apr 20, 2015 at 7:07

TALHA MALIK

133 bronze badges

answered Apr 20, 2015 at 6:29

Sougata Bose

31.8k8 gold badges52 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

Retrieving and displaying data in Php from Mysql

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