Server : LiteSpeed System : Linux in-mum-web1949.main-hosting.eu 5.14.0-503.40.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Mon May 5 06:06:04 EDT 2025 x86_64 User : u595547767 ( 595547767) PHP Version : 7.4.33 Disable Function : NONE Directory : /home/u595547767/domains/nilasevasamithi.com/public_html/admin/ |
<?php
include_once 'connect.php';
//------------------------------------------------DELETE QUERIES---------------------------------------------------------------
//promoters table delete
if(count($_POST)>0){
if($_POST['type']=='delpromo'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_promoters WHERE promoter_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$sql = "DELETE FROM `tbl_promoters` WHERE promoter_id=$id ";
if (mysqli_query($con, $sql)) {
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
// ends-------------------------------------------
//banners table delete
if(count($_POST)>0){
if($_POST['type']=='delbanner'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_banners WHERE banner_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['banner_image'];
$sql = "DELETE FROM `tbl_banners` WHERE banner_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//notifications table delete
if(count($_POST)>0){
if($_POST['type']=='delnote'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_notifications WHERE note_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$sql = "DELETE FROM `tbl_notifications` WHERE note_id=$id ";
if (mysqli_query($con, $sql)) {
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//services table delete
if(count($_POST)>0){
if($_POST['type']=='delservice'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_services WHERE service_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['service_image'];
$sql = "DELETE FROM `tbl_services` WHERE service_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//Service Impact table delete
if(count($_POST)>0){
if($_POST['type']=='delserviceimpact'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_serviceimpact WHERE serviceimpact_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['serviceimpact_image'];
$sql = "DELETE FROM `tbl_serviceimpact` WHERE serviceimpact_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//Partner table delete
if(count($_POST)>0){
if($_POST['type']=='delpartner'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_partners WHERE partner_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['partner_image'];
$sql = "DELETE FROM `tbl_partners` WHERE partner_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//Story table delete
if(count($_POST)>0){
if($_POST['type']=='delstory'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_story WHERE story_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['story_image'];
$sql = "DELETE FROM `tbl_story` WHERE story_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//Impact table delete
if(count($_POST)>0){
if($_POST['type']=='delimpact'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_impact WHERE impact_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['impact_image'];
$sql = "DELETE FROM `tbl_impact` WHERE impact_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//quote table delete
if(count($_POST)>0){
if($_POST['type']=='delquote'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_quote WHERE quote_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$sql = "DELETE FROM `tbl_quote` WHERE quote_id=$id ";
if (mysqli_query($con, $sql)) {
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//achievement table delete
if(count($_POST)>0){
if($_POST['type']=='delachieve'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_achievement WHERE achieve_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['achieve_image'];
$sql = "DELETE FROM `tbl_achievement` WHERE achieve_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//child laws table delete
if(count($_POST)>0){
if($_POST['type']=='delchildlaws'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_childlaws WHERE childlaws_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['childlaws_image'];
$sql = "DELETE FROM `tbl_childlaws` WHERE childlaws_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//team table delete
if(count($_POST)>0){
if($_POST['type']=='delteam'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_team WHERE team_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['team_image'];
$sql = "DELETE FROM `tbl_team` WHERE team_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//happyprogram table delete
if(count($_POST)>0){
if($_POST['type']=='delhappyprogram'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_happyprogram WHERE program_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['program_image'];
$sql = "DELETE FROM `tbl_happyprogram` WHERE program_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//teamphoto table delete
if(count($_POST)>0){
if($_POST['type']=='delteamphoto'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_teamphoto WHERE photo_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['photo_team'];
$sql = "DELETE FROM `tbl_teamphoto` WHERE photo_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//mediareport table delete
if(count($_POST)>0){
if($_POST['type']=='delmediareport'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_mediareport WHERE media_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['media_image'];
$sql = "DELETE FROM `tbl_mediareport` WHERE media_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//videoreport table delete
if(count($_POST)>0){
if($_POST['type']=='delvideoreport'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_videoreport WHERE video_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$sql = "DELETE FROM `tbl_videoreport` WHERE video_id=$id ";
if (mysqli_query($con, $sql)) {
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//newsletter table delete
if(count($_POST)>0){
if($_POST['type']=='delnewsletter'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_newsletter WHERE newsletter_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['newsletter_file'];
$filePath1 = $row['newsletter_image'];
$sql = "DELETE FROM `tbl_newsletter` WHERE newsletter_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
unlink($filePath1);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//event table delete
if(count($_POST)>0){
if($_POST['type']=='delevent'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_events WHERE event_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['event_image'];
$sql = "DELETE FROM `tbl_events` WHERE event_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//gallery table delete
if(count($_POST)>0){
if($_POST['type']=='delgallery'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_gallery WHERE gallery_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['gallery_image'];
$sql = "DELETE FROM `tbl_gallery` WHERE gallery_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//annualreport table delete
if(count($_POST)>0){
if($_POST['type']=='delannualreport'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_annualreport WHERE report_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['report_file'];
$filePath1 = $row['report_image'];
$sql = "DELETE FROM `tbl_annualreport` WHERE report_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
unlink($filePath1);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//csractivity table delete
if(count($_POST)>0){
if($_POST['type']=='delcsractivity'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_csractivity WHERE csractivity_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$sql = "DELETE FROM `tbl_csractivity` WHERE csractivity_id=$id ";
if (mysqli_query($con, $sql)) {
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//csrsubactivity table delete
if(count($_POST)>0){
if($_POST['type']=='delcsrsubactivity'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_csrsubactivity WHERE csrsub_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['csrsub_image'];
$sql = "DELETE FROM `tbl_csrsubactivity` WHERE csrsub_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//testimonial table delete
if(count($_POST)>0){
if($_POST['type']=='deltestimonial'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_testimonial WHERE testimonial_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['testimonial_image'];
$sql = "DELETE FROM `tbl_testimonial` WHERE testimonial_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//service details table delete
if(count($_POST)>0){
if($_POST['type']=='delservicedetails'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_servicedetails WHERE servicedetails_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['servicedetails_image'];
$sql = "DELETE FROM `tbl_servicedetails` WHERE servicedetails_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//work with us table delete
if(count($_POST)>0){
if($_POST['type']=='delwork'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_workwithus WHERE work_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['work_image'];
$sql = "DELETE FROM `tbl_workwithus` WHERE work_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
//donate with us table delete
if(count($_POST)>0){
if($_POST['type']=='deldonate'){
$id=$_POST['id'];
$sql1 = "SELECT * FROM tbl_donate WHERE donate_id=$id ";
$result = mysqli_query($con, $sql1);
$row = mysqli_fetch_assoc($result);
$filePath = $row['donate_image'];
$sql = "DELETE FROM `tbl_donate` WHERE donate_id=$id ";
if (mysqli_query($con, $sql)) {
unlink($filePath);
echo $id;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($con);
}
mysqli_close($con);
}
}
//ends-------------------------------------------
?>