user3671937 user3671937 - 3 months ago 9
PHP Question

Fetch from mySQL to HTML TABLE

I have used this code but its not fetching anything other than displaying the table on the web.

<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>database connections</title>
</head>
<body>
<?php
$username = "root";
$password = " ";
$host = "localhost";

$connector = mysql_connect($host,$username,$password)
or die("Unable to connect");
echo "Connections are made successfully::";
$selected = mysql_select_db("ticad", $connector)
or die("Unable to connect");

//execute the SQL query and return records
$result = mysql_query("SELECT * FROM users ");

?>
<table border="2" style= "background-color: #84ed86; color: #761a9b; margin: 0 auto;" >
<thead>
<tr>
<th>id</th>
<th>Names</th>
<th>Company</th>
<th>Position</th>
<th>Email</th>
<th>Event</th>
<th>Comments</th>
</tr>
</thead>
<tbody>
<?php
while( $row = mysql_fetch_assoc( $result ) ){
echo
"<tr>
<td>{$row\['id'\]}</td>
<td>{$row\['Names'\]}</td>
<td>{$row\['Company'\]}</td>
<td>{$row\['Position'\]}</td>
<td>{$row\['Email'\]}</td>
<td>{$row\['Event'\]}</td>
<td>{$row\['Comments'\]}</td>
</tr>\n";
}
?>
</tbody>
</table>
<?php mysql_close($connector); ?>
</body>
</html>


This is my Table and dabase

This is what am getting when I run the code as a web. I want all the records to be displayed on the table as we fetch from the table users

Answer

try this and don't escape... And as I saw your picture. You need to upload your file onto webserver with support of PHP. Rename your file to .php extension

  echo
        "<tr>
          <td>".$row['id']."</td>
          <td>".$row['Names']."</td>
          <td>".$row['Company']."</td>
          <td>".$row['Position']."</td>
          <td>".$row['Email']."</td>
          <td>".$row['Event']."</td> 
          <td>".$row['Comments']."</td> 
        </tr>\n";
Comments