How to update data into database using PHP

Update Data into database



There are two to three styles to write query for update into database ,Below is effective way to update into database

Syntax:

$query="UPDATE TABLE SET column1='value',column2='value' WHERE id='1' ";

For example.

$query="UPDATE login SET username='admin',password='admin' WHERE id='1' ";