et4891 Posted September 6, 2014 Share Posted September 6, 2014 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 )); Link to comment https://forums.phpfreaks.com/topic/290895-sqlstatehy093-invalid-parameter-number-parameter-was-not-defined/ Share on other sites More sharing options...
et4891 Posted September 7, 2014 Author Share Posted September 7, 2014 nevermind I was so stupid I should have used password all the way instead of using hash Link to comment https://forums.phpfreaks.com/topic/290895-sqlstatehy093-invalid-parameter-number-parameter-was-not-defined/#findComment-1490211 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.