MySQLi Update Using PHP

PHP MySQLi Update Query

The update keyword is basically used to modify or edit the existing records in the database table. it usually needs a where clause to find out in which record change is to be done. It is a must to specify the where clause otherwise all records of that table got modify. 

Syntax

UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_value 

Demo Database Record: Users

Note: Notice the WHERE clause in the UPDATE syntax is a must otherwise all records will be updated!.

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysqli_connect($host,$user,$pass,$dbname) or die(mysqli_error());  
	$id=1;  
	$name="Rahul";  
	$salary=80000;  
	$sql = "update users set name='".$name."',salary='".$salary."' where id='".$id; 
	//if not working then use all variable with in single quote 
	if(mysqli_query($conn,$sql)){  
		echo "Record updated successfully";  
	}else{  
		echo "Could not update record: ". mysqli_error($conn);  
	}  
	mysqli_close($conn);  
?>  

Output:

Record updated successfully

Update Database Record: Users