<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { } // sql to delete a record $sql = "DELETE FROM tbl_registration WHERE tbl_registration_id = 2"; if ($conn->query($sql) === TRUE) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . $conn->error; } $conn->close(); ?>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; // Create connection // Check connection if (!$conn) { } // sql to delete a record $sql = "DELETE FROM tbl_registration WHERE tbl_registration_id = 2"; echo "Record deleted successfully"; } else { } ?>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // sql to delete a record $sql = "DELETE FROM tbl_registration WHERE tbl_registration_id = 2"; // use exec() because no results are returned echo "Record deleted successfully"; } catch(PDOException $e) { echo $sql . "<br>" . $e->getMessage(); } $conn = null; ?>
<table border="1" cellspacing="5" cellpadding="5" width="100%"> <thead> <tr> </tr> </thead> <tbody> <?php require_once('connection.php'); $result = $conn->prepare("SELECT * FROM tbl_registration ORDER BY tbl_registration_id ASC"); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ $id=$row['tbl_registration_id']; ?> <tr> <td> <a href="delete.php<?php echo '?tbl_registration_id='.$id; ?>" class="btn btn-danger"> <button class="btn_delete"> Delete Record </button> </a> </td> </tr> <?php } ?> </tbody> </table>
<?php require_once('connection.php'); $get_id=$_GET['tbl_registration_id']; // sql to delete a record $sql = "Delete from tbl_registration where tbl_registration_id = '$get_id'"; // use exec() because no results are returned echo "<script>alert('Successfully Deleted!'); window.location='index.php'</script>"; ?>