php mysqli delete data in database

PHP MySQL Delete Data (or) Record

the delete query is delete user defined recored delete.

in the database table.

PHP mysql_query() function is used to delete record in a table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

• mysqli_query()
• PDO::__query()

PHP MySQLi Delete Record Example

Example

1. <?php  
2. $host = 'localhost';  
3. $user = 'root';  
4. $pass = '';  
5. $dbname = 'test';  
6.   
7. $conn = mysqli_connect($host, $user, $pass,$dbname);  
8. if(!$conn){  
9.   die('Could not connect: '.mysqli_connect_error());  
10. }  
11. echo 'Connected successfully<br/>';  
12.   
13. $id=2;  
14. $sql = "delete from staff where id=$id";  
15. if(mysqli_query($conn, $sql)){  
16.  echo "Record deleted successfully";  
17. }else{  
18. echo "Could not deleted record: ". mysqli_error($conn);  
19. }  
20.   
21. mysqli_close($conn);  
22. ?>  

Output:

Connected successfully
Record deleted successfully