Displaying MySQL Records in a HTML Table. What fails?

Question

i am having a Problem Displaying MySQL Records in a HTML Table

Here is the code:

    <html>
<head>
</head>
<body>
<?php
                        $con = mysql_connect("localhost", "root", "");
                        if (!con) {
                        die ("Can not connect: " . mysql_error());
                        }

                        mysql_select_db ("regform", $con);

                        $sql = "SELECT * FROM contacts";
                        $myData = mysql_query($sql, $con);
                      echo 'test';    
                        echo "<table border = '1'>

                        <tr>
                        <th>Name</th>
                        <th>Lastname</th>
                        <th>Phone</th>
                        <th>Email</th>
                        <th>Comment</th>
                        </tr>";

                        while($record = mysql_fetch_array($myData)) {
                        echo "<tr>";
                        echo "<td>" . $record['Name'] . "</td>";
                        echo "<td>" . $record['Lastname'] . "</td>";
                        echo "<td>" . $record['Phone'] . "</td>";
                        echo "<td>" . $record['Email'] . "</td>";
                        echo "<td>" . $record['Comment'] . "</td>";
                        echo "</tr>";

                        }

                        echo "</table>";

                        mysql_close ($con);

                        ?>
</body>
</html>

i get this on the browser:

Name Lastname Phone Email Comment "; while($record = mysql_fetch_array($myData)) { echo ""; echo "" . $record['Name'] . ""; echo "" . $record['Lastname'] . ""; echo "" . $record['Phone'] . ""; echo "" . $record['Email'] . ""; echo "" . $record['Comment'] . ""; echo ""; } echo ""; mysql_close ($con); ?>

Looks like your PHP isn't being parsed. Does the file end in .php? Are you getting any errors? Can you run a PHP page with just <?php phpinfo() ?>? — j08691
– j08691, Commented Mar 22, 2013 at 19:58
Sounds like your server doesn't have PHP installed or set-up. — Dai
– Dai, Commented Mar 22, 2013 at 19:59
what web server are you running? and do you have the correct modules installed (if you are running apache do you have mod-php)? — m79lkm
– m79lkm, Commented Mar 22, 2013 at 19:59

Kermit · Accepted Answer · 2013-03-22 19:58:48Z

2

Your php is not being rendered by your web engine. It needs to have a *.php extension and be on a server that handles it.

answered Mar 22, 2013 at 19:58

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

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

1 Comment

j08691 Over a year ago

Technically the pages don't have to end in .php as you can easily configure a web server to parse any extension as a PHP file.

karthikr · Accepted Answer · 2013-03-22 20:20:20Z

-1

I guess it has to do with the multiline

             echo "<table border = '1'>

                    <tr>
                    <th>Name</th>
                    <th>Lastname</th>
                    <th>Phone</th>
                    <th>Email</th>
                    <th>Comment</th>
                    </tr>";

Perhaps you try this:

echo <<<END
<table border = '1'>

                    <tr>
                    <th>Name</th>
                    <th>Lastname</th>
                    <th>Phone</th>
                    <th>Email</th>
                    <th>Comment</th>
                    </tr>

END;

edited Mar 22, 2013 at 20:20

karthikr

100k26 gold badges208 silver badges191 bronze badges

answered Mar 22, 2013 at 20:01

pythonmeister

1

3 Comments

UnholyRanger Over a year ago

not true. As long as the quote is open, you can do multiple lines with an echo

j08691 Over a year ago

Plus if that were the case it would error out, not render everything including the PHP.

Pedro Cordeiro Over a year ago

Yes, this has nothing to do with the issue in hand.

Collectives™ on Stack Overflow

Displaying MySQL Records in a HTML Table. What fails?

2 Answers 2

1 Comment

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Linked

Related