Question

How to read all record from MySQL table and display the fields using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli("localhost", $db_user, $db_password , $db_name);

if (mysqli_connect_errno()) 
    die("Connection Error: " . mysqli_connect_error() . "<br />");

if ($result = $con->query("SELECT * FROM images")) 
{
    while($row = $result->fetch_array())
    {
        echo $row['href'] . " - " . $row['src'] . "<br />";;
    }
    $result->close();
}
else
    echo "Query Error: " . mysqli_error($con);

$con->close();


/*
run: 

https://www.ws.com - http://www.ws.com/images/us-flag.gif
https://www.ws.com - http://www.ws.com/images/logo.png
https://www.ws.com - http://www.ws.com/images/tools.png
...

*/

 

70+ SQL courses for beginners and professionals