php
MySQL UPDATE Query
The MySQL UPDATE statement is used to update or modify  data of the existing MySQL records  within the database table .

MySQL query using the UPDATE statement and WHERE clause, after that we will execute this query through passing it to the PHP mysqli_query() function to update the tables records.
Syntax

UPDATE table_name SET column1=value, column2=value2,... WHERE column_name=some_value

Consider the following student_details table inside the demo database :

ID Name College Email ID Mobile
1V V Ramana ReddyS V Arts and Science Collegeinfo@freetimelearning.com9963666068
2ChantiVidhyalaya Degree Collegefreetimelearn@gmail.com9010023210
3RamanaS V Universityvvramanareddy9963@gmail.com9966463846
MySQLi UPDATE Query (Procedural)
<!DOCTYPE html>
<html>
<head>
	<title>PHP MySQL UPDATE Query</title>
</head>
<body>

<?php

	// Create connection
	$ftl_connect = mysqli_connect("localhost", "root", "", "ftl_db");
	// Check connection
	if (!$ftl_connect) {
		die("Connection failed: " . mysqli_connect_error());
	}
	
	$sql = "UPDATE student_details SET email='ramana@freetimelearn.com' WHERE stu_id=3";
	
	if (mysqli_query($ftl_connect, $sql)) {
		echo "Record has successfully updated..! ";
	} else {
		echo "Error updating record : " . mysqli_error($ftl_connect);
	}
	
	mysqli_close($ftl_connect);
	
?>

</body>
</html>
MySQLi UPDATE Query (Object-oriented)
<!DOCTYPE html>
<html>
<head>
	<title>PHP MySQL UPDATE Query</title>
</head>
<body>

<?php

	// Create connection
	$ftl_connect = mysqli_connect("localhost", "root", "", "ftl_db");
	// Check connection
	if ($ftl_connect->connect_error) {
		die("Connection failed: " . $ftl_connect->connect_error);
	} 
	
	$sql = "UPDATE student_details SET email='ramana@freetimelearn.com' WHERE stu_id=3";
	
	if ($ftl_connect->query($sql) === TRUE) {
		echo "Record successfully updated..!";
	} else {
		echo "Error updating record: " . $ftl_connect->error;
	}
	//Close Connection
	$ftl_connect->close();
	
?>
</body>
</html>
MySQL UPDATE Query (PDO)
<!DOCTYPE html>
<html>
<head>
	<title>PHP MySQL UPDATE Query</title>
</head>
<body>

<?php

	try {
		$ftl_connect = new PDO("mysql:host=localhost;dbname=ftl_db", "root", "");
		// set the PDO error mode to exception
		$ftl_connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	
		$sql = "UPDATE student_details SET email='ramana@freetimelearn.com' WHERE stu_id=3";
	
		// Prepare statement
		$ft_up = $ftl_connect->prepare($sql);
	
		// execute the query
		$ft_up->execute();
	
		// echo a message to say the UPDATE succeeded
		echo $ft_up->rowCount() . " Records has successfully updated ..! ";
		}
	catch(PDOException $e)
		{
		echo $sql . "<br>" . $e->getMessage();
		}
	//Close Connection
	$ftl_connect = null;
	
?>


</body>
</html>
Output :
The above examples update the record with stu_id=3 (email id) in the "student_details" table :

We see you’re using an ad blocker.

Our website is made possible by displaying ads to our visitors.

Please help us continue to provide you with free. So please disabling your ad blocker.