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
326 Downloads
very easy and simple way of crude operation sir nice