Issue with creating insert specific password hash values with created database, table

Asked Aug 01 '17 at 17:08

Active Aug 01 '17 at 17:20

Viewed 76 times

I already manage to create my database and table with the help of Can I create a database using PDO in PHP but I have difficulties with inserting my password_hash code with this setup page.

CREATE TABLE `users` (
`user_id` INT(11) NOT NULL AUTO_INCREMENT,
`password_hashcode` VARCHAR(60) NOT NULL DEFAULT '',
 PRIMARY KEY (`user_id`),
INDEX `FK_users_role_status` (`role_id`),
CONSTRAINT `FK_users_role_status` FOREIGN KEY (`role_id`) REFERENCES `role_status` (`role_id`)
 )
 COLLATE='utf8_general_ci'
 ENGINE=InnoDB
 AUTO_INCREMENT=80
 ;

 INSERT INTO `users`(`user_id`, `password_hashcode`) VALUES (1,'$2y$10$g7WTN4QEKH6VxjPX6Wfao.GuxYyIMTi4.E0c8BxJEjJDBkkt73JZO');

For example: '$2y$10**$g7WTN4QEKH6VxjPX6Wfao**.GuxYyIMTi4.E0c8BxJEjJDBkkt73JZO'
'$2y$10**$vrIbKaO5uIreh**.wGtYHn1OU/ttVXnWjZ16ZukPbqngwptawLlleU2'

Undefined variable: g7WTN4QEKH6VxjPX6Wfao

Undefined variable:  vrIbKaO5uIreh

Strangely, I don't get any error with that hash password
 '$2y$10$3awSIi/YVAVierYR79Vj0u9bAsLK00PMaHQAE6We7UWS7SzEavoAq'

How can I also inserted those hash values without affecting the password?

edited Aug 01 '17 at 17:20

asked Aug 01 '17 at 17:08

John Laimuin

True using ` instead of ' – Vagabond Aug 01 '17 at 17:11
Do you mean to use ` $2y$10$g7WTN4QEKH6VxjPX6Wfao.GuxYyIMTi4.E0c8BxJEjJDBkkt73JZO ` instead of '$2y$10$g7WTN4QEKH6VxjPX6Wfao.GuxYyIMTi4.E0c8BxJEjJDBkkt73JZO' cause I dont think that would work... will try it. – John Laimuin Aug 01 '17 at 17:13
Yes, give it a shot and let me know the outcome. – Vagabond Aug 01 '17 at 17:15
Does not work and this time some of my tables are not being created as a result of adding ` password ` – John Laimuin Aug 01 '17 at 17:19

Issue with creating insert specific password hash values with created database, table

0 Answers0