Mysql query prerared but not executed

Asked Mar 30 '21 at 06:08

Active Mar 30 '21 at 06:08

Viewed 22 times

I need to find bug in my code but I can't figure out what is wrong query is preparing without problem and when executing is not working at all I always get "Not executed"

$query="INSERT INTO users (firstname,lastname,username,mail,password,user_ip,phone,premium,blocked) VALUES (?,?,?,?,?,?,?,?,?)";
    
    if ($stmt = $conn->prepare($query)) {
        $stmt->bind_param("ssssssiii",$firstname,$lastname,$username,$mail,$pass,$ip,$phone,$premium,$blocked);
        if ($stmt->execute()) {
          header("Location:complete.php");
          exit();
        }else{
          echo "Not executed";
        }
    }else{
        echo "Not prepared";
    }

asked Mar 30 '21 at 06:08

Tedo Dhdhdjdodk

Obtain complete error message text provided by SQL server. – Akina Mar 30 '21 at 06:11
Please provide the CREATE TABLE statement for this table – Strawberry Mar 30 '21 at 06:11
@Akina I tried trigger_error($conn->error); but it shows nothing – Tedo Dhdhdjdodk Mar 30 '21 at 06:12
Check `$stmt->error` - the error occures during statement execution, there is no problem with the connection... – Akina Mar 30 '21 at 06:14
@Akina also $stmt->error show nothing – Tedo Dhdhdjdodk Mar 30 '21 at 07:54

Mysql query prerared but not executed

0 Answers0