Fetching results from database

Once you have a resource returned from a mysql_query function, you can use it to retrieve the data you want. The simplest way to do this is to fetch the cells you want, one at a time, using the mysqli_query function.


$con = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();

// execute query
$Query = "SELECT * FROM newrecords";
$result = mysqli_query($con, $Query);

// displaying results
echo "<ul>";
while ($row = mysqli_fetch_array($result)) {
    echo '<li>' . $row['ID'] . '</li>'; /* name of the database column ID */
    echo '<li>' . $row['Name'] . '</li>'; /* name of the database column Name */
echo "</ul>";


You may also like...