Jump to content

SQLSTATE[HY093]: Invalid parameter number: parameter was not defined


et4891

Recommended Posts

I have the following code just to insert a username and hashed password into the database but somehow I am getting this error and I couldn't find out where I am doing it wrong...can someone please give me a hand?

 

I tried it in two ways and both errors...

the first few lines are just connecting database which worked fine and a password.php so I can use password_hash() with my php version

$hash = password_hash('xx', PASSWORD_BCRYPT, array('cost' => 10));
$username = 'xx';


$insertQuery = $db->prepare("
		INSERT INTO et_todo (username, password)
		VALUES (:username, :hash)
	");

$insertQuery->execute(array(
		'username' => $username,
		'password' => $hash
	));

also tried

$hash = password_hash('xx', PASSWORD_BCRYPT, array('cost' => 10));

$insertQuery = $db->prepare("
		INSERT INTO et_todo (username, password)
		VALUES ('xx', :hash)
	");

$insertQuery->execute(array(
		'username' => 'xx',
		'password' => $hash
	));

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.