Updating mysql database with php

Posted by / 05-Mar-2020 12:33

I'll give a practical example because this is kind of hard to understand. In the example shown above, we update a table named Users_table and set the state column equal to FL where the name column equals to John.In simpler words, we want to update the user John's state to FL. This setup is great anytime you need to update values.

it usually need a where clause to find out in which record change is to be done.We will show how to tie this in with PHP to update a value in a table. After we do this, we create a variable named $update.This $update variable is set equal to a mysql_query() function that has the parameter "UPDATE Users_Table SET state='FL' WHERE name='John'". The UPDATE keyword is used followed by the table name.I am trying to make a page with an HTML form that will update my MYSQL database.You can view my pages online here: need help with the "Edit" section, if you look online.

updating mysql database with php-43updating mysql database with php-41updating mysql database with php-30

we need updation in this table as devesh change to dev and his mobile number also need to be changed.