Question

How to fetch a result row as a numeric array 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->connect_error);
    
$query = "SELECT * FROM images";
$result = $con->query($query);

// numeric array 
$row = $result->fetch_array(MYSQLI_NUM);
echo $row[1] . " - " . $row[3];   

$result->close();
$con->close();


/*
run: 

60 - http://www.ws.com/images/us-flag.gif 

*/

 

70+ SQL courses for beginners and professionals

Answer 2

$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->connect_error);
    
$query = "SELECT * FROM images";
$result = $con->query($query);

// numeric array 
while ($row = $result->fetch_array(MYSQLI_NUM)) 
{
    echo $row[1] . " - " . $row[3] . "<br />"   ;
}

$result->close();
$con->close();


/*
run: 

60 - http://www.wp.com/images/us-flag.gif
60 - http://www.wp.com/images/logo.png
...


*/

 

70+ SQL courses for beginners and professionals