CRUD with 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...

  <?php $stu_name = $_POST [ "sname" ]; $stu_address = $_POST [ "saddress" ]; $stu_class = $_POST [ "class" ]; $stu_phone = $_POST [ "sphone" ]; $conn = new mysqli ( "localhost" , "root" , "" , "crud" ); if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); } $sql = " INSERT INTO student(sname,saddress,sclass,sphone) VALUES ('{ $stu_name }','{ $stu_address }','{ $stu_class }','{ $stu_phone }') " ; if ( $conn -> query ( $sql ) == TRUE ) {     header ( "Location: http://localhost/crud/index.php" );     echo "New record created successfully" ; } else {     echo "Error : " . $sql . "<br>" . $conn -> error ; } $conn -> close ();

  <?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 ...

  <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0" >     < meta http-equiv = "X-UA-Compatible" content = "ie=edge" >     < title > CRUD </ title >     < link rel = "stylesheet" href = "css/style.css" > </ head > < body >     < div id = "wrapper" >         < div id = "header" >             < h1 > Crud </ h1 >         </ div >         < div id = "menu" >             < ul >                 < li >                     < a href = "index.php" > Home </ a >       ...

  <?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" ]...

  <?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 >         ...