Update a Database in PHP MySqli

To Update a Database in PHP MySqli you will have to make sure that the following steps have been taken.

1. You Created A Database
2. You Granted Privileges to the database
3. Created a config.php file to access the database
4. Make sure you Connect to a Database before using this code.

The purpose of updating a database is that you will make the information within the database different. You will be updating values within a table row. This is different than inserting into a database. You will actually change whatever value is in there.

 mysqli_query($con,"UPDATE table SET row1='$var'
WHERE username='$var' ");

Update a Database in PHP MySqli *

Remember that you will have to include the config file for this to work. You can put include(‘config.php’); at the top of the file. Right below that you will have to make sure that you are using the connection code to the database code.