mysql execute 方法,mysqli语句execute（），正确的方法

I have this code in MyFile.php

$db= mysqli_connect("host","user","pw","db");//connect to db

if (mysqli_connect_errno($con))//check connection

{echo "Failed to connect to MySQL: " . mysqli_connect_error();}

//Create a token for the unique link

$title= $_GET[apt_title];

$email= $_GET[mail_address];

$token = sha1(uniqid($email, true));

$time = $_SERVER["REQUEST_TIME"];

//prepare the query to be executed

$query = $db->prepare(

"INSERT INTO pending_users (email, token, title_apt, tstamp) VALUES (?, ?, ?, ?)"

);

$query->execute(

array(

$title,

$email,

$token,

$time

)

);

Error Message from MySQL

Warning: mysqli_stmt::execute() expects exactly 0 parameters, 1 given in /websites

I have spent a few hours to try to fix this but I could not.

Any help?

解决方案

you need to bind params before executing the query,

in procedural way do like this

mysqli_stmt_execute($stmt);

if you are doing it like object oriented way after binding params

/* Execute the statement */

$stmt->execute();

Docs link.