Breaking News
yeni film izle hd film seyret film izle

Deleting Records In PHP and MYSQL

Deleting Records In PHP and MYSQL Deleting rows of data in PHP is a similar to updating process.

mysql > DELETE FROM fruit WHERE id = 2;

Query OK, 1 row affected

To delete rows using PHP, pass a DELETE statement directly via PDO::query() , or create the statement using PDO::prepare() with placeholders, passing in values (such as the criteria for the WHERE clause) with PDOStatement::bindValue() and running the query with PDOStatement::execute() .

This script deletes the member record with the ID of 8 from the members table:

<?php
$dsn = “mysql:dbname=mydatabase”;
$username = “root”;
$password = “mypass”;
try {
$conn = new PDO( $dsn, $username, $password );
$conn- > setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
} catch ( PDOException $e ) {
echo “Connection failed: “ . $e- > getMessage();
}
$id = 8;
$sql = “DELETE FROM members WHERE id = :id”;
try {
$st = $conn- > prepare( $sql );
$st- > bindValue( “:id”, $id, PDO::PARAM_INT );
$st- > execute();
} catch ( PDOException $e ) {
echo “Query failed: “ . $e- > getMessage();
}
?>

Incidentally, rather than binding the value of a variable to a placeholder with PDOStatement:: bindValue() , use PDOStatement::bindParam() to bind the variable itself. then change the value of the variable after the call to bindParam() , the placeholder value is automatically updated to the new value.

Check Also

Copying, Renaming, and Deleting Files

PHP also allows you to copy, rename, and delete files. The functions to perform these …