John Davidson

php - mysqli_stmt::execute() expects exactly 0 parameters, 1 given

0 comments
Message:


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:



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



How should I call execute() the right way?



My Answer:
"localhost", "username", "password", "database");

$stmt = $db->prepare("SELECT * FROM table WHERE id = ?");
$stmt->bind_param("i", $id);

$id = 1;

$stmt->execute();

Rate this post

5 of 5 based on 3459 votes

Comments




© 2024 Hayatsk.info - Personal Blogs Platform. All Rights Reserved.
Create blog  |  Privacy Policy  |  Terms & Conditions  |  Contact Us