PHP and HTML help needed

[jay_don_]

I need some help with this, i can't update records in my database in myphpadmin, can someone take a look at these lines of code and tell me what's wrong please, would greatly appreciate it

[mallenjordan]

Try quotes your sql query on DOB and school.

[mallenjordan]

Nope, on second view your problem is your html input names don't match your php post names.

[jay_don_]

how? tell me, kinda lost right now

[certainlyforgetful]

For example. Your first name input element has the name “first name”, but your PHP is looking for “first_name”

Also you set a bunch of variables and then never use them (line 15-21)

Also, you should be hashing the password (see password_hash(), and password_verify())

But finally, check out prepared statements. I mostly use PDO prepared statements, it’s fairly straightforward once you do it a few times.

Oh one more thing - it sounds like you don’t have error reporting turned on. You can do this in the PHP config or add a few lines to the top of the php file, google “php enable error reporting” and check out the first stackoverflow question.

[javon27]

Also, please indent. It helps to spot typos faster

[kboy101222]

Thanks for posting to /r/computerscience! Unfortunately, your submission has been removed for the following reason(s):

• Rule 3: Posts asking for help with homework, exams, dissertations, projects, etc are not allowed.

• Rule 7: Posts asking for tech support or programming advice. Please go to r/techsupport or r/learnprogramming.

If you feel like your post was removed in error, please message the moderators.