MYSQLI DELETE query

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>" ;
} 
With Parameters by using bind_param()
<?Php
require "config.php";// Database connection
/////////////////////
$id=5;
$query="DELETE FROM student  WHERE id=?";
$stmt = $connection->prepare($query);
if ($stmt) {
$stmt->bind_param('i', $id);
$stmt->execute();
echo "Record Deleted :";
echo $stmt->affected_rows;
}else{
echo $connection->error;
}
?>
Procedural style
<?Php
require "config.php";// Database connection
/////////////////////
$id=6;
$class='Four';
$query="DELETE FROM  student  WHERE class=? AND id=?";
if ($stmt = mysqli_prepare($connection,$query)){
mysqli_stmt_bind_param($stmt, "si",$class, $id);
mysqli_stmt_execute($stmt);
echo "Record Deleted:";
echo mysqli_affected_rows($connection);
}else{
echo mysqli_error($connection);
}
?>

MySQL DELETE Query

Procedural style
<?Php
require "config.php";// Database connection
/////////////////////
$id=7;
$class='Fifth';
$query="DELETE FROM  student  WHERE class=? AND id=?";
if ($stmt = mysqli_prepare($connection,$query)){
mysqli_stmt_bind_param($stmt, "si",$class, $id);
mysqli_stmt_execute($stmt);
echo "Record Deleted:";
echo mysqli_affected_rows($connection);
}else{
echo mysqli_error($connection);
}
?>

MySQL DUMP of student table

MYSQLI Functions mysqli_num_rows() Number of rows in result set SELECT query UPDATE query
Subscribe to our YouTube Channel here


Subscribe

* indicates required
Subscribe to plus2net

    plus2net.com







    Post your comments , suggestion , error , requirements etc here





    PHP video Tutorials
    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2024 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer