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>
";
}
?>
</tbody>
</table>
<?php mysql_close($connector); ?>
</body>
</html>
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>
";
Don't escape the brackets:
<td>{$row['id']}</td>