Retrieving values from the Table Using PHP built-in functions

Retrieving values from the Table Using PHP built-in functions

<?php

$us ername = "xyz";

 $hostname = "localhost";

$dbhandle = mysqlconnect($hostname,$username);

echo "connected to MYSQL";

$stmt = mysqliquery $con,"SELECT * FROM TEST TABLE");

while($row = mysqllfetcharray($stmt))

{

echo $row[ISNOT] . " " . $row[TNAMEI];

echo "<br>";

}

mysqliclose($dbhandle);

?>

<?php

$username = "xyz";

$hostname = "localhost";

$dbhandle = mysqlconnect($hostname,$username);

echo "connected to MYSQL";

$stmt = mysqli_query ($con,"SELECT * FROM TEST_TABLE");

echo "<table border=’1‘>

<tr> <th>S.NO</th>

<th>Name</th> </tr>";

while($row = mysqlifetcharray($stmt))

{

echo "<tr>";

echo "<td>" . $row['SNO'] . "</td>";

echo "<td>" . $row['NAME'] . "</td>";

echo "</tr>";

}

echo "</table>";

mysciliclose($dbhandle);

?>