Displaying mysql data in html table PHP

Question

I have to make data from a MySQL table display in an HTML table. I've got the code to where it will display the first of seven rows from the MySQL table, but it is repeating the row nine times, instead of displaying all seven rows. What have I done wrong?

<?php
require 'database.php';

//get all product data
$query = 'SELECT * FROM products';
          $products = $db->query($query);
          $products = $products->fetch();
?>

    <!doctype html>
    <html>
    <head>
    <meta charset="utf-8">
    <title>SportsPro</title>
    </head>

    <body>
    <form id="Header" name="Header" method="post">
    <?php include 'header.php'; ?>
    </form>
    <form id="Content" name="Content" method="post">
    <table width="500" border="1">
    <tr>
    <th scope="col">Code</th>
    <th scope="col">Name</th>
    <th scope="col">Version</th>
    <th scope="col">Release Date</th>
    <th scope="col">&nbsp;</th>
    </tr>
    <?php foreach ($products as $product) { ?>
    <tr>
    <td><?php echo $products['productCode']; ?></td>
    <td><?php echo $products['name']; ?></td>
    <td><?php echo $products['version']; ?></td>
    <td><?php echo $products['releaseDate']; ?></td>
    <td><input type = "submit" value = "Delete" align = "right" ></td>

    </tr> 
    <?php } ?>
    </table>

    <p><a href="add_product.php">Add Product</a></p>
    </form>
    <form id="Footer" name="Footer" method="post">
    <?php include 'footer.php'; ?>
    </form>
    </body>
    </html>

Check the result of var_dump($products);

deviloper
– deviloper

2014-02-23 07:00:43 +00:00
Commented Feb 23, 2014 at 7:00 — deviloper
– deviloper, Commented Feb 23, 2014 at 7:00

Akshat Singhal · Accepted Answer · 2014-02-23 07:09:53Z

2

Why are you using $products?

FIX:

<?php 
foreach ($products as $product) {  //See *$products as $product*, so no need to use $products below instead use $product
    echo "<tr>";
    echo "<td>". $product['productCode']. "</td>";
    echo "<td>". $product['name']. "</td>";
    echo "<td>". $product['version']. "</td>";
    echo "<td>". $product['releaseDate']. "</td>";
    echo "<td><input type = \"submit\" value = \"Delete\" align = \"right\" ></td>";
    echo "</tr>" 
} 
?>

edited Feb 23, 2014 at 7:09

Akshat Singhal

1,81119 silver badges20 bronze badges

answered Feb 23, 2014 at 7:02

Osama Yawar

3692 gold badges6 silver badges19 bronze badges

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

Comments

Ramesh · Accepted Answer · 2014-02-23 06:58:54Z

1

You have to replace,

$products = $products->fetch();

with

$products = $products->fetchAll();

Inside td tags, you have,

<?php echo $products['productCode']; ?>

Change it to like below for all lines,

<?php echo $product['productCode']; ?>

answered Feb 23, 2014 at 6:58

Ramesh

4,3032 gold badges20 silver badges24 bronze badges

Collectives™ on Stack Overflow

Displaying mysql data in html table PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related