Task 8: create a delete page for Task 7

 <?php
$sn = $_GET['sn']; // use $_GET instead of $_POST because you're passing sn via the URL
$conn = mysqli_connect('localhost', 'ksumanadhikari', 'welcome', 'task');
$sql = "DELETE FROM data WHERE sn = $sn";  // Potential risk of SQL injection
mysqli_query($conn, $sql);  

mysqli_close($conn);

header("location: index.php");
exit();
?>

Filed in PHP_MYSQL |  No comments |  December 25, 2024