Create table with PHP and populate from MySQL

by

Here is a full example of what you’re looking for:

  1. pull some data from mysql using php
  2. put that data into an html table
  3. apply alternating colored rows to the table

For the styling I cheat a little and use jquery which I find a bit easier then what you’re trying to do.

Also, remember $row[field] is case sensitive. So $row[id] != $row[ID].

Hope this helps:

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js" type="text/javascript"></script>
        <style type="text/css">
            tr.header
            {
                font-weight:bold;
            }
            tr.alt
            {
                background-color: #777777;
            }
        </style>
        <script type="text/javascript">
            $(document).ready(function(){
               $('.striped tr:even').addClass('alt');
            });
        </script>
        <title></title>
    </head>
    <body>
        <?php

            $server = mysql_connect("localhost","root", "");
            $db =  mysql_select_db("MyDatabase",$server);
            $query = mysql_query("select * from employees");
        ?>
        <table class="striped">
            <tr class="header">
                <td>Id</td>
                <td>Name</td>
                <td>Title</td>
            </tr>
            <?php
               while ($row = mysql_fetch_array($query)) {
                   echo "<tr>";
                   echo "<td>".$row[ID]."</td>";
                   echo "<td>".$row[Name]."</td>";
                   echo "<td>".$row[Title]."</td>";
                   echo "</tr>";
               }

            ?>
        </table>
    </body>
</html>

Here’s the table code only using PHP to alternate the styles like you’re trying to do in your example:

    <table class="striped">
        <tr class="header">
            <td>Id</td>
            <td>Title</td>
            <td>Date</td>
        </tr>
        <?php
           $i = 0;
           while ($row = mysql_fetch_array($query)) {
               $class = ($i == 0) ? "" : "alt";
               echo "<tr class=\"".$class."\">";
               echo "<td>".$row[ID]."</td>";
               echo "<td>".$row[Name]."</td>";
               echo "<td>".$row[Title]."</td>";
               echo "</tr>";
               $i = ($i==0) ? 1:0;
           }

        ?>
    </table>

More Related Contents:

  1. Creating dynamic tables in HTML using MySQL and PHP
  2. Getting links from db and displaying them in another div [closed]
  3. HTML Form/PHP connected but MySQL is empty
  4. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  5. Thank you for helping [closed]
  6. Create hyperlink from html table row to open record on a new page
  7. Is the following code valid? [closed]
  8. How to retrieve images from MySQL database and display in an html tag
  9. How to get multiple selected values of select box in php?
  10. Preserve Line Breaks From TextArea
  11. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  12. How to upload images into MySQL database using PHP code
  13. Fetching data from MySQL database to HTML dropdown list
  14. HTML – Change\Update page contents without refreshing\reloading the page
  15. Delete multiple rows by selecting checkboxes using PHP
  16. “slash before every quote” problem [duplicate]
  17. How to add a delete button to a PHP form that will delete a row from a MySQL table
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. display data from SQL database into php/ html table [closed]
  20. How can I parse JSON into a html table using PHP?
  21. Echo menu tree with recursive function
  22. How to display an BLOB image stored in MySql database?
  23. Javascript function post and call php script
  24. PHP: Inserting Values from the Form into MySQL
  25. onbeforeprint() and onafterprint() equivalent for non IE browsers
  26. Turkish characters are not displayed correctly [duplicate]
  27. How to create PHP two column table with values from the database?
  28. How to display two table columns per row in php loop
  29. Displaying BLOB image from Mysql database into dynamic div in html
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment