Call to a Member Function Execute() on Boolean In

Call to a member function execute() on boolean in

mysqli->prepare can also return FALSE (check http://php.net/manual/en/mysqli.prepare.php) if an error occurred. Your problem is that you have INSET instead of INSERT.

Fatal error: Call to a member function execute() on boolean in

You need to use prepare() to create a prepared statement, not query. You're also mixing PDO and mysqli, that won't work.

If you're using PDO, it should be:

$result = $connection->prepare('DELETE FROM blog WHERE id = :id');
$result->execute(array(':id' => $_GET['delpost']));

If you're using mysqli, it should be:

$result = $connection->prepare('DELETE FROM blog WHERE id = ?');
$result->bind_param('i', $_GET['delpost']);
$result->execute();

PHP Fatal error: Uncaught Error: Call to a member function execute() on boolean

Your INSERT query is missing quotes around the timestamp value. Just change

updated_at = ".$row["updated_at"].",

to

updated_at = '".$row["updated_at"]."',

This would fix the insert functionality but your code remains susceptible to SQL injection attacks. Please avoid simple string concatenation in your SQL queries and prefer prepared statements with placeholders.

FATAL ERROR: Uncaught Error: Call to a member function execute() on boolean in

The prepare functions can return the statement object or false. If you get a false that means that there was an error.

Try printing the error with $conn->errno or $conn->error, to have a better understanding of what your issue is.

You can change your code to something like this:

function get_kurs($block){
    open_connection();
    global $conn;

    if($stmt = $conn->prepare("SELECT FachKürzel FROM `Fach` LEFT JOIN `Stunde` ON Fach.Fachname = Stunde.Fachname WHERE Stunde.Stunde = ?")){
        $stmt->bind_param("s", $block);
        $stmt->execute();
        $stmt->bind_result($kuerzel);
        $stmt->fetch();
    }else{
        printf('errno: %d, error: %s', $conn->errno, $conn->error);
        die;
    }

    print $kuerzel;

    $stmt->close();
    $conn->close();
}

Fatal error: Call to a member function execute() on boolean() when trying to update database in ajax

you should use bind_params();

replace this

  $data = array(
    ':first_name'  => $_POST['first_name'],
    ':last_name'  => $_POST['last_name'],
    ':email'   => $_POST['email'],
    ':password'   => $_POST['password'],
    ':website'   => $_POST['website']
   );

   $query = "
   INSERT INTO tbl_register 
   (first_name, last_name, email, password, website) 
   VALUES (:first_name, :last_name, :email, :password, :website)
   ";
   $statement = $connect->prepare($query);

   if($statement->execute($data))
   {
    echo 'Registration Completed Successfully...';
   }

  with

  $query = "
   INSERT INTO tbl_register 
   (first_name, last_name, email, password, website) 
   VALUES (?,?,?,?,?)
   ";
   $statement = $connect->prepare($query);

   $statement->bind_param('sssss',$_POST['first_name'],$_POST['last_name'],$_POST['email'],$_POST['password'],$_POST['website']);

   //here 's' in sssss stands for string and all your parameters are string so five 's' are added 

   if($statement->execute())
   {
    echo 'Registration Completed Successfully...';
   }

---

Related Topics