Delete with Where Query (without parameters ), Object Oriented Style
require "config.php";// Database connection file.
$query="DELETE FROM student WHERE class='Four'";
$connection->query($query);
echo " Records Deleted ".$connection->affected_rows;
Output
Records Deleted 9
Student Table : Sample Data and query to create table
config.php Database connection object $connection is taken from config.php file.
mysqli_affected_rows() Getting number of rows affected
if($stmt=$connection->query("DELETE FROM student WHERE class='Four'")){
$msg.= " One class deleted <br>";
}else {
$msg.=" Class can't be deleted <br>" ;
}