The SQL code for the student_details table:
CREATE TABLE `student_details` ( `id` int(11) NOT NULL, `name` varchar(100) DEFAULT NULL, `email` varchar(45) DEFAULT NULL, `contact_no` varchar(45) DEFAULT NULL, `gender` varchar(45) DEFAULT NULL, `qualification` varchar(45) DEFAULT NULL, `address` varchar(450) DEFAULT NULL, `create_date` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Here we are utilizing PDO Object-Oriented strategy to Open a Connection to MySQL.
This code for the database connection file.
servername=localhost Username=root Password="" Databasename='student'
dbconnection.php
<?php define('DB_HOST','localhost'); define('DB_USER','root'); define('DB_PASS',''); define('DB_NAME','student'); // Establish database connection. try { $dbconnection = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'")); } catch (PDOException $e) { exit("Error: " . $e->getMessage()); } ?>
Delete Record Query
delete from student_details WHERE id=:id”;
delete.php
<?php include 'dbconnection.php'; if(isset($_REQUEST['del'])) { //Get row id $uid=intval($_GET['del']); //Qyery for deletion $sql = "delete from student_details WHERE id=:id"; // Prepare query for execution $query = $dbconnection->prepare($sql); // bind the parameters $query-> bindParam(':id',$uid, PDO::PARAM_STR); // Query Execution $query -> execute(); // Mesage after updation echo "<script>alert('Record Delete successfully');</script>"; // Code for redirection echo "<script>window.location.href='delete.php'</script>"; } ?> <link href="https://netdna.bootstrapcdn.com/bootstrap/3.1.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css"> <div class="container"> <div class="row centered-form"> <div class="col-xs-10 "> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">Data Delete From Database Using PHP PDO</h3> </div> <div class="panel-body"> <table class="table table-bordered"> <thead> <tr> <th>Sr.No</th> <th>Name</th> <th>Email</th> <th>Contact-No</th> <th>Gender</th> <th>Qualification</th> <th>Address</th> <th>Action</th> </tr> </thead> <tbody> <?php $sql ="SELECT id,name,email,contact_no,gender,qualification,address from student_details"; $query= $dbconnection -> prepare($sql); $query-> execute(); $results = $query -> fetchAll(PDO::FETCH_OBJ); $cnt=1; if($query -> rowCount() > 0) { foreach($results as $result) { ?> <tr> <td><?php echo($cnt);?></td> <td><?php echo htmlentities($result->name);?></td> <td><?php echo htmlentities($result->email);?></td> <td><?php echo htmlentities($result->contact_no);?></td> <td><?php echo htmlentities($result->gender);?></td> <td><?php echo htmlentities($result->qualification);?></td> <td><?php echo htmlentities($result->address);?></td> <td><a href="delete.php?del=<?php echo htmlentities($result->id);?>"><button class="btn btn-danger btn-xs" onClick="return confirm('Do you really want to delete');">Delete</button></a></td></td> </tr> <?php $cnt=$cnt+1; } } ?> </tbody> </table> </div> </div> </div> </div> </div> <style type="text/css"> body { background-color: #000; } .centered-form { margin-top: 60px; } .centered-form .panel { background: rgba(255, 255, 255, 0.8); box-shadow: rgba(0, 0, 0, 0.3) 20px 20px 20px; } </style>
How To Data Delete From Database Using in PHP PDO, MySQL With Source Code
Size: 2kb
Version: 2.1
21 Downloads
Leave a Comment