| Server IP : 104.21.73.108 / Your IP : 216.73.216.59 Web Server : Apache/2 System : Linux cat167-197.static.lnwhostname.com 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 User : paphayomho ( 1042) PHP Version : 5.6.40 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/paphayomho/domains/paphayomhospital.go.th/private_html/Purchasing/crud_pdo/ |
Upload File : |
<?php
session_start();
include_once('connection.php');
if(isset($_GET['id'])){
$database = new Connection();
$db = $database->open();
try{
$sql = "DELETE FROM members WHERE id = '".$_GET['id']."'";
//if-else statement in executing our query
$_SESSION['message'] = ( $db->exec($sql) ) ? 'Member deleted successfully' : 'Something went wrong. Cannot delete member';
}
catch(PDOException $e){
$_SESSION['message'] = $e->getMessage();
}
//close connection
$database->close();
}
else{
$_SESSION['message'] = 'Select member to delete first';
}
header('location: index.php');
?>