The DELETE query is used to delete records from a database table.
It is generally used multiple record & selected record also
Syntax delete single record :
DELETE FROM table_name WHERE uniq_id=value;
Syntax delete multiple record :
DELETE FROM table_name WHERE (col1,col2) IN ((1,2),(3,4),(5,6));
Curd operation delete code :
<?php
$deleteQuery = "DELETE FROM phpmaincrud WHERE id='$id'";
$data = mysqli_query($con, $deleteQuery);
?>
Download Full Code HERE