Search code examples
phpmysqli

Call to undefined method mysqli_stmt::bindValue

I have the following function

<?php 

  error_reporting(E_ALL); ini_set("display_errors", true);
  @ $dbh= new mysqli('localhost', 'root', 'hsenidsoft', '1005');
  $stmt = $dbh->prepare("CALL populateDefaultTrainStructureTest(?,?)");
  $startdate = '2011-05-16';
  $counter =1 ;
  $stmt->bindValue(1, $startdate, PDO::PARAM_DATE);

  $stmt->bindValue(2, $counter, PDO::PARAM_INT);
  $stmt->execute();
?>

when I execute the function I got:

Fatal error: Call to undefined method mysqli_stmt::bindValue() in /var/www/sp.php on line 8 error

Solution

  • There is no bindValue function but there is mysqli_stmt::bind_param