PDO Connectivity Step 5

5. Delete Data

<?php
// include database connection file
require_once 'dbconfig.php';
$database = new Connection();
$db = $database->openConnection();

// Code for record deletion
if (isset($_REQUEST['del'])) {
//Get row id
    $uid = intval($_GET['del']);
//Qyery for deletion
    $sql = "delete from pdo_practice WHERE  id=:id";
// Prepare query for execution
    $query = $db->prepare($sql);
// bind the parameters
    $query->bindParam(':id', $uid, PDO::PARAM_STR);
// Query Execution
    $query->execute();
// Mesage after updation
    echo "<script>alert('Record Deleted successfully');</script>";
// Code for redirection
    echo "<script>window.location.href='index.php'</script>";
}