PHP MySQL Update

PHP MySQL Update Query

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. It is must to specify the where clause otherwise all records of that table got modify. Syntax

UPDATE table_name SET column1=value1,column2=value2... WHERE column = value

Note : Notice the WHERE clause in the UPDATE syntax is must otherwise all records will be updated! Ex Previous records in empInfo table are:

Emp_id	Name	Email	Mobile
1	devesh	devesh@gmail.com	9910099100
2	deepak	deepak@gmail.com	9210053520
3	ravi	ravi@gmail.com	9810098100

This example updates some data in the "empInfo" table

 <?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());

//update values of empInfo table
$data="UPDATE empInfo SET name='dev',mobile=9015501256 WHERE email='devesh@gmail.com'";
mysqli_query($con,$data);			
?>

In the above example , empInfo table has 3 records of devesh,deepak, and ravi. we need updation in this table as devesh change to dev and his mobile number also need to be changed. here first we create connection with the database,then database is selected using mysql_select_db(), then update query is passed to the mysql_query( ) and the database table is updated.

« Previous Next »

MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO

No Sidebar ads