Delete inline File in PHP

 <?php

echo $stu_id = $_GET["id"];

include "config.php";

$sql = "DELETE FROM student WHERE sid={$stu_id}";

if($conn->query($sql) == TRUE) {
    echo "Record deleted Successfully";
}
else {
    echo "Error deleting record : " . $conn->error;
}
header("Location: http://localhost/crud/index.php");
$conn->close();
?>

Comments

Post a Comment

Popular posts from this blog

Update Record File in PHP

  <?php include 'header.php' ; ? > < div id = "main-content" >     < h2 > Edit Record </ h2 >     < form class = "post-form" action = " <?php $_SERVER [ 'PHP_SELF' ]; ? > " method = "post" >         < div class = "form-group" >             < label > Id </ label >             < input type = "text" name = "sid" />         </ div >         < input class = "submit" type = "submit" name = "showbtn" value = "Show" />     </ form >     <?php     if ( isset ( $_POST [ "showbtn" ])) {         include "config.php" ;         $stu_id = $_POST [ "sid" ];         $sql = " SELECT * FROM student WHERE sid = { $stu_id } " ;         $result = $conn...
Read more

Index File in PHP

  <?php include 'header.php' ; ? > < div id = "main-content" >     < h2 > All Records </ h2 >     <?php     include "config.php" ;     $sql = " SELECT * FROM student JOIN studentclass WHERE student.sclass = studentclass.cid " ;     $result = $conn -> query ( $sql );     if ( $result -> num_rows > 0 ) {     ? >         < table cellpadding = "7px" >             < thead >                 < th > Id </ th >                 < th > Name </ th >                 < th > Address </ th >                 < th > Class </ th >                 < th > Phone </ th ...
Read more

Edit OR Update Data File in PHP

  <?php include 'header.php' ; ? > < div id = "main-content" >     < h2 > Update Record </ h2 >     <?php     include "config.php" ;     $stu_id = $_GET [ "id" ];     $sql = " SELECT * FROM student WHERE sid = { $stu_id } " ;     $result = $conn -> query ( $sql );     if ( $result -> num_rows > 0 ) {         while ( $row = $result -> fetch_assoc ()) {     ? >             < form class = "post-form" action = "updatedata.php" method = "post" >                 < div class = "form-group" >                     < label > Name </ label >                     < input type = "hidden" name = "sid" value = " <?php echo $row [ "sid" ]...
Read more