Php stmt prepare error

$stmt = $mysqli->prepare("INSERT INTO testtable VALUES (?,?,?)");
// prepare() can fail because of syntax errors, missing privileges, ....
if ( false===$stmt ) {
  // and since all the following operations need a valid/ready statement object
  // it doesn't make sense to go on
  // you might want to use a more sophisticated mechanism than die()
  // but's it's only an example
  die('prepare() failed: ' . htmlspecialchars($mysqli->error));
}

$rc = $stmt->bind_param('iii', $x, $y, $z);
// bind_param() can fail because the number of parameter doesn't match the placeholders in the statement
// or there's a type conflict(?), or ....
if ( false===$rc ) {
  // again execute() is useless if you can't bind the parameters. Bail out somehow.
  die('bind_param() failed: ' . htmlspecialchars($stmt->error));
}

$rc = $stmt->execute();
// execute() can fail for various reasons. And may it be as stupid as someone tripping over the network cable
// 2006 "server gone away" is always an option
if ( false===$rc ) {
  die('execute() failed: ' . htmlspecialchars($stmt->error));
}

$stmt->close();

Source: stackoverflow.com

Similar codes

0 vote141 views1 answer
Php curl async callback
PHP
0 vote135 views2 answers
Woocommerce disable zoom on product image
PHP
0 vote138 views1 answer
Php is object
PHP
0 vote164 views1 answer
Laravel delete controller still cached
PHP Laravel
0 vote128 views1 answer
PHP include causes white space at the top of the page
PHP
0 vote164 views1 answer
Make model inside module laravel
PHP
20 votes148 views6 answers
Array random php
PHP
31 votes145 views3 answers
Carbon laravel use
PHP Laravel
29 votes135 views6 answers
Laravel model with migration
PHP
12 votes178 views4 answers
Wordpress get post thumbnail
PHP