Delete

<?php


$publisher_id = 1;


// connect to the database and select the publisher

$pdo = require 'connect.php';


// construct the delete statement

$sql = 'DELETE FROM publishers

        WHERE publisher_id = :publisher_id';


// prepare the statement for execution

$statement = $pdo->prepare($sql);

$statement->bindParam(':publisher_id', $publisher_id, PDO::PARAM_INT);


// execute the statement

if ($statement->execute()) {

echo 'publisher id ' . $publisher_id . ' was deleted successfully.';

} 

<?php

include('DBC.php');


    $S = $_GET['i'];

    $sql1 = "delete from subject where Password = '$S' ";

if(mysqli_query($con, $sql1)){

    header("refresh:0; url=LoginRe.php");

    }

    else{echo'Not Delete';}


?>