ansaurus

Question

Create table with PHP and populate from MySQL

Answer 1

A:

What HTML source is sent to the browser from that code?

Aaron 2010-06-16 03:45:51

Answer 2

+1 A:

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

pull some data from mysql using php
put that data into an html table
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>

brendan 2010-06-16 04:10:01

I still cannot get what I want (I guess I just am not explaining it well) so I just went with what I had (which worked if I moved my PHP code into the HTML file and changed the extension) and configured the server to process HTML as PHP. I was just being anal wanting all HTML with separate PHP code in another file. Thanks for your help.

typoknig 2010-06-16 06:45:07

Answer 3

+2 A:

The reason your code is not executing is that you cannot include PHP with the Script tag. You must use PHP's include function, and the original page must be parsed as PHP.

<?php
include('./my_other_file.php');
?>

Fosco 2010-06-16 04:15:14

Maybe I am not being clear, as far as this question is concerned I only have one HTML file and one PHP file. I am calling the code in the PHP file from the HTML file via JavaScript. I could just combine all the HTML and PHP code of both files into one big PHP file, but I don't want to do that, I want all of my web pages to be HTML. I can see now (in FireBug) that all of the data I want to display in my table is being sent retrieved and sent from the PHP file to the HTML file, but it just isn't displaying for some reason. I can get it to work, but not as two separate files like I want.

typoknig 2010-06-16 04:37:38

You're being quite clear, but it's not something that is possible. That's what we're all trying to say. There's no reason to separate it like that, though there are other methods of separation. Template engines, including the HTML instead of vice-versa, etc.

Fosco 2010-06-16 21:49:28

Answer 4

A:

The starting of the coding is a little bit wrong. It should be:-

<?php
$query = "SELECT * FROM employees";
$result = mysql_query($query);

$num = mysql_num_rows($result);

echo '<table>';

if($num) {
    while( $row = mysql_fetch_array($result) ) {
        // all logic for each of the rows comes here
    }
}
else {
    // no rows fetched, so display proper message in a row
}

echo "</table>";
?>

The first time "mysql_fetch_array" function is used on a Resource Handler, after that it does not work properly. This answer may seem a bit vague, but I have seen it many times, so I always use a "while" or "do-while" loop for fetching multiple rows from DB.

Try using the above code, & see if any information crops up.

Knowledge Craving 2010-06-16 05:25:25

ansaurus

tags:

views:

answers:

Create table with PHP and populate from MySQL

related questions