Question

How to perform a query on MySQL 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 ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);
 
if ($result = $con->query("SELECT * FROM images LIMIT 10")) 
{
    while($row = $result->fetch_array())
    {
        echo $row['src'] . " - " . $row['alt'] . "<br />";;
    }
 
    $result->close();
}

$con->close();

/*
run: 

http://www.ws.com/images/logo-wordpress.png - wordpress logo   
http://www.ws.com/images/why-choose.png - why choose us
http://www.ws.com/images/logo.png - site logo
...

*/

 

70+ SQL courses for beginners and professionals