user3671937 user3671937 - 1 year ago 60
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">
<meta charset="UTF-8">
<title>database connections</title>
$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;" >
while( $row = mysql_fetch_assoc( $result ) ){
<?php mysql_close($connector); ?>

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 Source

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