Updating mysql database with php

Posted by / 07-Jan-2020 10:51

Updating mysql database with php

The update keyword is basically used to modify or edit the existing records in the database table.

it usually need a where clause to find out in which record change is to be done.

And this is how a value in a My SQL table can be updated using PHP.

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with.

As well as using a loop to get information from a database as we have before, you can also use loops to execute queries.

Try out following example to understand update operation.

You need to provide an employee ID to update an employee salary.

It is must to specify the where clause otherwise all records of that table got modify.

Syntax In the above example , emp Info table has 3 records of devesh,deepak, and ravi.

updating mysql database with php-37updating mysql database with php-83updating mysql database with php-24

 In this article, we show how to update a value in a My SQL table using PHP.

One thought on “updating mysql database with php”