I want to get all of my database items

Question

I've included this PHP file in my index.php, but I only get the first item from the database. How can I get all items from my database?

<?php
$sql = "SELECT name,price FROM items ORDER BY `id`";

$res = mysqli_query($conn, $sql);
$page = mysqli_fetch_assoc($res);
mysqli_close($conn);
?>

<h2><?=$page["name"]?></h2>
<?=$page["price"]?>

You are going to need to loop over the results in order to show all the results (assuming there is more resulting row than one). If you just want to see the results without marking it up with HTML, you can just do a dump of the array (`print_r`). — SunSparc, Jun 27 '16 at 18:10

Alive to die - Anant · Accepted Answer · 2016-06-27T18:25:09.347

1

As you said you want all records from the database, so you need to use while loop like below:-

<?php
   $sql = "SELECT name,price FROM items ORDER BY `id`"; // query
   $res = mysqli_query($conn, $sql); // execute query
   while($page = mysqli_fetch_assoc($res)){ // loop
      echo "<h2>". $page["name"]."</h2>".$page["price"]; // print all record (You can change pattern of printing according to your wish )
   }
   mysqli_close($conn); // close connection
?>

edited Jun 27 '16 at 18:25

answered Jun 27 '16 at 18:11

Alive to die - Anant

70,531
10
51
98

It worked for me, thank you very much ^_^ – Arevshatyan Gegham Jun 27 '16 at 19:15
@ArevshatyanGegham welcome :) – Alive to die - Anant Jun 27 '16 at 19:15

score 1 · Answer 2 · edited Jun 28 '16 at 10:19

1

This is because you need to loop your results that are in $page array. Try this:

<?php foreach($page as $value): ?>
    <h2><?=$value["name"]?></h2>
    <?=$value["price"]?>
<?php endforeach; ?>

if you need more info about foreach method go here

edited Jun 28 '16 at 10:19

Alive to die - Anant

70,531
10
51
98

answered Jun 27 '16 at 18:17

Sebastian S

807
6
15

1.`$page` is one row, not all the rows. 2. The same code is written by user1272855 and he deleted his answer, because it's wrong – Alive to die - Anant Jun 28 '16 at 07:02

I want to get all of my database items

2 Answers2