Updating mysql database with php
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.
we need updation in this table as devesh change to dev and his mobile number also need to be changed.