How can i echo sql attributes to an HTML table using PHP

Question

  <div class="col-md-6">
                    <?php
                        include 'includes/connection.php';

                        $query = "SELECT * FROM customer";

                        $result = mysql_query($query);


                        while ($person = mysql_fetch_array($result)) {

                            //echo "<p>" . $person['customerID'] . "</p>";
                            //echo "<p>" . $person['firstName'] . "</p>";
                            //echo "<p>" . $person['lastName'] . "</p>";
                            //echo "<p>" . $person['address'] . "</p>";

                            $customerID  = $person['customerID'];
                            $firstName   = $person['firstName'];
                            $lastName    = $person['lastName'];
                            $address     = $person['address'];

                            echo $customerID; //A test echo that is working        just fine. But i need to echo this to the table
                        }




                        ?>
                        <table class="table table-striped">
                            <tr>
                                <th>Customer ID</th>
                                <th>First Name</th>
                                <th>Last Name</th>
                                <th>Address</th>
                            </tr>    
                            </th>
                            <tr>
                                <td> 
                                    <? echo $customerID;  ?>
                                </td>
                                <td>
                                    <? echo $firstName; ?>
                                </td>
                                <td>
                                    <? echo $lastName; ?>
                                </td>
                                <td> 
                                    <? echo $address; ?>
                                </td>
                            </tr>

                        </table>


    </div>
</div>

I am learning PHP and i need help with this as soon as possible.

When i run the web page nothing is being shown to the table apart from the table headers. Please help for i am learning PHP. I am using xampp on which i created a database.

Do not use the depricated `mysql_*` API. Use `mysqli_*` or `PDO` — Jens, Mar 14 '15 at 22:59
You probably want to echo your table data inside your WHILE loop. Right now you're only showing your last record. — BigScar, Mar 14 '15 at 23:01

score 2 · Answer 1 · answered Mar 14 '15 at 23:00

2

<? echo $customerID;  ?>

should be

<?php echo $customerID;  ?>

answered Mar 14 '15 at 23:00

Eric Lamas

114
5

. . . ?> is not recommended but is valid if properly enabled – BigScar Mar 14 '15 at 23:05

score 2 · Answer 2 · edited May 23 '17 at 11:43

Firstly:

Please, don't use mysql_* functions, They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO or MySQLi. This article will help you decide.

But to answer your question, you need to output your table data inside of your while loop like this:

<table class="table table-striped">
      <tr>
        <th>Customer ID</th>
        <th>First Name</th>
        <th>Last Name</th>
        <th>Address</th>
     </tr>    
     </th>
     <?php while ($person = mysql_fetch_array($result)) { ?>
     <tr>
        <td> 
        <?php echo $person['customerID'];  ?>
        </td>
        <td>
        <?php echo $person['firstName']; ?>
        </td>
        <td>
        <?php echo $person['lastName']; ?>
        </td>
        <td> 
        <?php echo $person['address']; ?>
        </td>
    </tr>
   <?php } ?>
</table>

Thanks alot. The code worked just fine and ill read more about PDO and MySQLi — Willie Mwewa, Mar 14 '15 at 23:14

How can i echo sql attributes to an HTML table using PHP

2 Answers2