Crud Operation in PHP using oops concept

3 years ago
1 Comment
by admin
Written by admin

Table

CREATE TABLE `add_student` (
  `id` int(11) NOT NULL,
  `name` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `mobile` varchar(45) DEFAULT NULL,
  `address` varchar(45) DEFAULT NULL,
  `create_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Dbconfig.php

<?php
define("DEMO_PORT","3306");
define("DEMO_CharSet","utf8");
define("DEMO_USER",'root');
define("DEMO_HOST",'localhost');
define("DEMO_PASS",'');
define("DEMO_DB","student_record");
?>

index.php

<!DOCTYPE html>
<html lang="en">

<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
</head>

<body>
  <div class="container">
    <div class="container py-5">
      <div class="row">
        <div class="col-md-12">
          <div class="row">
            <div class="col-md-12"> <a href="insert.php" class="btn btn-success">Insert Data</a>
              <div class="card card-outline-secondary">
                <div class="card-header">
                  <h3 class="mb-0">All Display Data From Database</h3> </div>
                <div class="card-body">
                  <table class="table table-striped">
                    <thead>
                      <tr>
                        <th>Sr.No</th>
                        <th>Name</th>
                        <th>Email</th>
                        <th>Mobile</th>
                        <th>Address</th>
                        <th>Action</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php 
                 include 'phplib/MysqliDb.php'; 
                $fetch = "select id, name, email, mobile, address from add_student";
                $myDB= new MysqliDb();
                $result=$myDB->Query($fetch);
                $count=1;
                if($result =="0")
           {
            echo "No Data Found";
           }
               else
                { 
                     foreach($result as $key=>$value)
                        {
                            echo '<tr class="data">
                                    <td class="data" width="25px">'.$count.'</td>
                                    <td class="name">'.$value['name'].'</td>
                                      <td class="email">'.$value['email'].'</td>
                                    <td class="mobile">'.$value['mobile'].'</td>
                                    <td class="address">'.$value['address'].'</td>
                                    <td><a href="update.php?id='.$value['id'].'" class="btn btn-warning">Edit Data</a>|<a href="delete.php?id='.$value['id'].'" class="btn btn-danger">Delete Data</a></td> 
                                   
                            </tr>';
                           $count++;
                        }
                }
     ?>
                    </tbody>
                  </table>
                </div>
              </div>
              <!-- /form card register -->
            </div>
          </div>
        </div>
        <!--/row-->
        <br>
        <br>
        <br>
        <br> </div>
      <!--/col-->
    </div>
    <!--/row-->
  </div>
  <!--/container-->
  </div>
</body>

</html>
<script>
$(document).ready(function() {
  $(".alert-danger").fadeOut(3000);
  $(".alert-success").fadeOut(3000);
  $('#update').hide();
  $('.material-icons').click(function() {
    $('#submit').hide();
    //$('#pass').hide();
    $('#update').show();
  });
});
</script>

insert.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

</head>
<body>
<?php
include 'phplib/MysqliDb.php';  
$msg1 = NULL; 
$msg= NULL;
if(isset($_POST['submit']))
{
$name = $_POST['name'];
$email  = $_POST['email'];
$mobile = $_POST['mobile'];
$address = $_POST['address'];
// $classs = "call new_tblinsert('".$name."','".$email."','".$mobile."','".$address."')";
    $classs = "insert into add_student(name, email, mobile, address) values('".$name."','".$email."','".$mobile."','".$address."')";
     $myDB =  new MysqliDb();
     $query = $myDB->rawQuery($classs);
     $mysql_error = $myDB->getLastError();
    if($myDB->count >0)
    {
        $msg1= '<div class="alert alert-success alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                <h6><i class="icon fa fa-check"></i>Data Insert Successfully.</h6>
                
                 </div>';
    }
    else
        {
        $msg1= '<div class="alert alert-danger alert-dismissible"><button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button><h6><i class="icon fa fa-check"></i>Data Insert not Successfully.</h6></div>';
        }
}
        
        ?>
<div class="container">
 <div class="container py-5">
    <div class="row">
        <div class="col-md-12">
           <div class="row">
               <div class="col-md-6 offset-md-3">
                    <!-- form card register -->
                    <div class="card card-outline-secondary">
                        <div class="card-header">
                            <h3 class="mb-0">Data Insert Using OOPs Concept</h3>
                        </div>
                        <?php echo $msg1;?>
                        <div class="card-body">
                            <form class="form" method="POST" autocomplete="off">
                                <div class="form-group">
                                    <label for="name">Name</label>
                                    <input type="text" class="form-control" name="name"  id="name" placeholder="Name">
                                </div>
                                <div class="form-group">
                                    <label for="email">Email</label>
                                    <input type="text" class="form-control" name="email" id="email" placeholder="Email">
                                </div>
                                <div class="form-group">
                                    <label for="inputPassword3">Mobile</label>
                                    <input type="text" class="form-control" name="mobile" id="mobile" placeholder="Mobile">
                                </div>
                                <div class="form-group">
                                    <label for="inputVerify3">Address</label>
                                    <textarea class="form-control" id="address" name="address"></textarea>
                                </div>
                                <div class="form-group">
                                    <input type="submit" name="submit" id="submit" value="Submit" class="btn btn-primary">
                                     <a href="index.php" class="btn btn-success">Back Now</a> 
                                </div>
                            </form>
                        </div>
                    </div>
                    <!-- /form card register -->

                </div>
              </div>

            </div>
            <!--/row-->

        <br><br><br><br>

        </div>
        <!--/col-->
    </div>
    <!--/row-->
    
</div>
<!--/container-->

  
</div>

</body>
</html>
<script>
        $(document).ready(function(){
            $(".alert-danger").fadeOut(3000);
            $(".alert-success").fadeOut(3000);
         $('#update').hide();
        $('.material-icons').click(function(){
            $('#submit').hide();
            //$('#pass').hide();
            $('#update').show();
        });
        });
     </script>

edit.php

<!DOCTYPE html>
<html lang="en">

<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
</head>

<body>
  <div class="container">
    <div class="container py-5">
      <div class="row">
        <div class="col-md-12">
          <div class="row">
            <div class="col-md-12">
              <!-- form card register -->
              <div class="card card-outline-secondary">
                <div class="card-header">
                  <h3 class="mb-0">All Display Data From Database</h3> </div>
                <div class="card-body">
                  <table class="table table-striped">
                    <thead>
                      <tr>
                        <th>Sr.No</th>
                        <th>Name</th>
                        <th>Email</th>
                        <th>Mobile</th>
                        <th>Address</th>
                        <th>Action</th>
                      </tr>
                    </thead>
                    <tbody>
                      <?php 
                include 'phplib/MysqliDb.php';  
                $fetch = "select id, name, email, mobile, address from add_student";
                $myDB= new MysqliDb();
                $result=$myDB->Query($fetch);
                $count=1;
                if($result =="0")
           {
            echo "No Data Found";
           }
               else
                { 
                     foreach($result as $key=>$value)
                        {
                            echo '<tr class="data">
                                    <td class="data" width="25px">'.$count.'</td>
                                    <td class="name">'.$value['name'].'</td>
                                      <td class="email">'.$value['email'].'</td>
                                    <td class="mobile">'.$value['mobile'].'</td>
                                     <td class="addresss">'.$value['address'].'</td>
                                                    <td> 
              <a href="update.php?id='.$value['id'].'" class="btn btn-warning">Edit Data</a>
              
              </td> 
                            </tr>';
                           $count++;
                        }
                }
     ?>
                    </tbody>
                  </table>
                </div>
              </div>
              <!-- /form card register -->
            </div>
          </div>
        </div>
        <!--/row-->
        <br>
        <br>
        <br>
        <br> </div>
      <!--/col-->
    </div>
    <!--/row-->
  </div>
  <!--/container-->
  </div>
</body>

</html>
<script>
$(document).ready(function() {
  $(".alert-danger").fadeOut(3000);
  $(".alert-success").fadeOut(3000);
  $('#update').hide();
  $('.material-icons').click(function() {
    $('#submit').hide();
    //$('#pass').hide();
    $('#update').show();
  });
});
</script>

update.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

</head>
<body>

<div class="container">

<div class="container py-5">
    <div class="row">
        <div class="col-md-12">
           <div class="row">
               <div class="col-md-6 offset-md-3">
                  <?php
                   include 'phplib/MysqliDb.php'; 
                     $id = $_GET['id'];
                  
                        $Quesry="select * from  add_student where id='".$id."' ";
                        $myDB =  new MysqliDb();
                        $result = $myDB->rawQuery($Quesry);
                        foreach($result as $key=>$value)
                        {
                       $name=$value['name'];
                        $email=$value['email'];
                        $mobile=$value['mobile'];
                        $address=$value['address'];
            
                        }
                     ?>


<?php
 
$msg1 = NULL; 
$msg= NULL;
if(isset($_POST['submit']))
{
$name = $_POST['name'];
$email  = $_POST['email']; 
$mobile = $_POST['mobile']; 
$address = $_POST['address']; 
$idd = $_POST['idd'];
   $Updatesql = "update add_student set  name='".$name."',email='".$email."', mobile='".$mobile."', address='".$address."' where id='".$idd."'";
     $myDB =  new MysqliDb();
     $query = $myDB->rawQuery($Updatesql);
     if($query>'0')
    {
        $msg1= '<div class="alert alert-success alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                <h6><i class="icon fa fa-check"></i>Data Insert Successfully.</h6>
                
                 </div>';
    }
    else
        {
        $msg1= '<div class="alert alert-danger alert-dismissible"><button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button><h6><i class="icon fa fa-check"></i>Data Insert not Successfully.</h6></div>';
        }
}
        
        ?>
                    <!-- form card register -->
                    <div class="card card-outline-secondary">
                        <div class="card-header">
                            <h3 class="mb-0">Data Update</h3>
                        </div>
                        <?php echo $msg1;?>
                        <div class="card-body">
                            <form class="form" method="POST" autocomplete="off">
                                <div class="form-group">
                                    <label for="name">Name</label>
                                    <input type="text" class="form-control" name="name"  id="name" placeholder="Name" value="<?php echo $name;?>">

                                      <input type="hidden" name="idd"  id="idd" placeholder="Name" value="<?php echo $id;?>">
                                </div>
                                <div class="form-group">
                                    <label for="email">Email</label>
                                    <input type="text" class="form-control" name="email" id="email" placeholder="Email" value="<?php echo $email;?>">
                                </div>
                                <div class="form-group">
                                    <label for="inputPassword3">Mobile</label>
                                    <input type="text" class="form-control" name="mobile" id="mobile" placeholder="Mobile" value="<?php echo $mobile;?>">
                                </div>
                                <div class="form-group">
                                    <label for="inputVerify3">Address</label>
                                    <textarea class="form-control" id="address" name="address"><?php echo $address; ?></textarea>
                                </div>
                                <div class="form-group">
                                    <input type="submit" name="submit" id="submit" value="update" class="btn btn-primary">
                                     <a href="index.php" class="btn btn-primary">Back Now</a>
                                </div>
                            </form>
                        </div>
                    </div>
                    <!-- /form card register -->

                </div>
              </div>

            </div>
            <!--/row-->

        <br><br><br><br>

        </div>
        <!--/col-->
    </div>
    <!--/row-->
    
</div>
<!--/container-->

  
</div>

</body>
</html>
<script>
        $(document).ready(function(){
            $(".alert-danger").fadeOut(3000);
            $(".alert-success").fadeOut(3000);
         $('#update').hide();
        $('.material-icons').click(function(){
            $('#submit').hide();
            //$('#pass').hide();
            $('#update').show();
        });
        });
     </script>

delete.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

</head>
<body>
<?php
include 'phplib/MysqliDb.php';  

if(isset($_REQUEST['id']))
{
  $sql ="delete from add_student where id='".$_REQUEST['id']."'";
  //echo $sql;
  $myDB= new MysqliDb();
  $result =$myDB->query($sql);
  
  if($result > '0')
  {
      $msg1= '<div class="alert alert-danger alert-dismissible"><button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button><h6><i class="icon fa fa-check"></i>Delete Data Successfully.</h6></div>';
  }
  
  else
  {
   $msg1=  '<div class="alert alert-success alert-dismissible">
                <button type="button" class="close" data-dismiss="alert" aria-hidden="true"></button>
                <h6><i class="icon fa fa-check"></i>Delete is not Successfully.</h6>
                
                 </div>';
  }
  
}
?>

<div class="container">

<div class="container py-5">
    <div class="row">
        <div class="col-md-12">
           
            <?php echo $msg1;?>
            <div class="row">
               
                <div class="col-md-12">
                    
                   

                    <!-- form card register -->
                    <div class="card card-outline-secondary">
                        <div class="card-header">
                            <h3 class="mb-0">All Display Data From Database</h3>
                        </div>
                   
                        <div class="card-body">
<a href="index.php" class=" btn btn-success">Back Now</a>
                        </div>
                    </div>
                    <!-- /form card register -->

                </div>
              </div>

            </div>
            <!--/row-->

        <br><br><br><br>

        </div>
        <!--/col-->
    </div>
    <!--/row-->
    
</div>
<!--/container-->

  
</div>

</body>
</html>
<script>
        $(document).ready(function(){
            $(".alert-danger").fadeOut(3000);
            $(".alert-success").fadeOut(3000);
         $('#update').hide();
        $('.material-icons').click(function(){
            $('#submit').hide();
            //$('#pass').hide();
            $('#update').show();
        });
        });
     </script>
Crud Operation in PHP using oops Concept With Source Code
Size: 5kb
Version: 3.4
Download Now!301 Downloads

You may also like

About the author

admin

Hi there! I'm Shiv Gupta. I specialized in building Websites. I write blogs in my free time. I really like to find out and share my knowledge with others.I founded ThePhpConcept in March 2020. I started this blog in order that I can interact with some like-minded people and also help people learning PHP, Mysql, jQuery, Html, and PHP Projects and related technologies.
Support-thephpconcept@gmail.com

View all posts

1 Comment

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.