Delete Data File in PHP

 <?php include 'header.php';


if(isset($_POST["sid"])) {

    include "config.php";
    $stu_id = $_POST["sid"];

    $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();

}

?>

<div id="main-content">
    <h2>Delete Record</h2>
    <form class="post-form" action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
        <div class="form-group">
            <label>Id</label>
            <input type="text" name="sid" />
        </div>
        <input class="submit" type="submit" name="deletebtn" value="Delete" />
    </form>
</div>
</div>
</body>
</html>

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