Update Data File in PHP

 <?php


$stu_id = $_POST["sid"];
$stu_name = $_POST["sname"];
$stu_address = $_POST["saddress"];
$stu_class = $_POST["sclass"];
$stu_phone = $_POST["sphone"];

include "config.php";
$sql = "UPDATE student SET sname = '{$stu_name}',saddress = '{$stu_address}',sclass = '{$stu_class}',sphone = '{$stu_phone}' WHERE sid = '{$stu_id}'";

if ($conn->query($sql) == TRUE) {
    header("Location: http://localhost/crud/index.php");
    echo "New record Updated Successfully";
} else {
    echo "Error : " . $sql . "<br>" . $conn->error;
}
$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