MySQLi Delete Query Execute Using PHP

DELETE keyword is used basically to delete 1 or more than one record from the database table. even if we delete each and every row of a table then also the schema of the table remains undeleted. It,s necessary to use where clause in delete query, otherwise all the records will be deleted.

Syntax

DELETE FROM table_name WHERE some_column = some_value

Demo Database Record : Users

PHP MySQLi Delete Record Example

<?php  
	$host = "localhost";  
	$user = "";  
	$pass = "";  
	$dbname = "users";  
	  
	$conn = mysqli_connect($host,$user,$pass,$dbname) or die(mysqli_error($conn));  
	
	$id=2;  
	$sql = "delete from users where id=".$id;  
	if(mysqli_query($conn,$sql)){  
		echo "Record deleted successfully";  
	}else{  
		echo "Could not deleted record: ". mysqli_error($conn);  
	} 
?>  

Output:

Record deleted successfully  

After Delete Database Record: Users