Question

How to bind variables to a prepared statement with bind_result() 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);
 
$sql = "
  SELECT src, alt
  FROM images
  WHERE alt LIKE ?
  AND add_date BETWEEN ? AND ?
";    
  
// i = variable type integer
// d = variable type double
// s = variable type string
// b = variable type blob 
     
if ($stmt = $con->prepare($sql)) 
{
    $alt = 'w%';
    $date1 = '2016-07-01';
    $date2 = '2016-07-31';
    $stmt->bind_param('sss', $alt, $date1, $date2); // 'sss' = 3 variables type string
 
    $stmt->execute();
    if ($stmt->errno) 
       die("Error: " . $stmt->error);
  
    // mysqli_stmt::bind_result - mysqli_stmt_bind_result
    // binds columns in the result set to variables
    $stmt->bind_result($src, $alt);   
        
    while ($stmt->fetch()) 
    {
        echo $src . " - " . $alt . "<br />";
    }
 
    $stmt->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
 
*/

 

70+ SQL courses for beginners and professionals