Posts

deletecode File for Delete Data in PHP

Image
  <?php include ( "mysqli_conn.php" ); if ( isset ( $_POST [ "deletedata" ])) {     $id = $_POST [ "delete_id" ];     $sql = " DELETE FROM student WHERE id = $id " ;     if ( $conn -> query ( $sql ) == TRUE ) {         echo "<script>alert('Data Deleted');</script>" ;         header ( "Location:index.php" );     } else {         echo "<script>alert('Data Not Deleted');</script>" ;     } }
Post a Comment
Read more

updatecode File for Update Data in PHP

Image
  <?php include ( "mysqli_conn.php" ); if ( isset ( $_POST [ "updatedata" ])) {     $id = $_POST [ "update_id" ];     $fname = $_POST [ "fname" ];     $lname = $_POST [ "lname" ];     $course = $_POST [ "course" ];     $contact = $_POST [ "contact" ];     $sql = " UPDATE student SET fname = ' $fname ', lname = ' $lname ', course = ' $course ', contact = ' $contact ' WHERE id = ' $id ' " ;     if ( $conn -> query ( $sql ) == TRUE ) {         echo "<script>alert(`Data Updated`);</script>" ;         header ( "Location:index.php" );     } else {         echo "<script>alert(`Data Not Updated`);</script>" ;     } }
Post a Comment
Read more

insertcode File for Insert data in PHP

Image
  <?php include ( "mysqli_conn.php" ); if ( isset ( $_POST [ "insertdata" ])) {     $fname = $_POST [ "fname" ];     $lname = $_POST [ "lname" ];     $course = $_POST [ "course" ];     $contact = $_POST [ "contact" ];     $sql = " INSERT INTO student(`fname`, `lname`, `course`, `contact`) VALUES (' $fname ',' $lname ',' $course ',' $contact ') " ;     if ( $conn -> query ( $sql ) == TRUE ) {         echo "<script>alert('Data Saved');</script>" ;         header ( "Location: index.php" );     } else {         echo "<script>alert('Data Not Saved');</script>" ;     } }
Post a Comment
Read more

mysqli_conn database Connection File in PHP

  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $database = "phpcrud" ; // Create Connection $conn = new mysqli ( $servername , $username , $password , $database ); // Check Connection if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); }
Post a Comment
Read more

Index File (with Bootstrap Modal and JavaScript) in PHP

Image
  <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0, shrink-to-fit=no" >     < meta http-equiv = "X-UA-Compatible" content = "ie=edge" >     < title > PHP CRUD with Bootstrap </ title >     < link href = "https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel = "stylesheet" integrity = "sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin = "anonymous" >     < link rel = "stylesheet" href = "https://cdn.datatables.net/2.1.8/css/dataTables.bootstrap5.min.css" > </ head > < body >     <!-- Modal -->     < div class = "modal fade" id = "studentaddmodal" tabindex = "-1" aria-labelledby = ...
Post a Comment
Read more