Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rotary2982.org/public_html/conference_registration(2)

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: smsapi1.php

<?php include('config.php');
	
if($_GET['type'] == 'categories'){
	$sql_filter = "SELECT category FROM district_posting GROUP BY category";
    $result_filter = mysqli_query($con, $sql_filter);
    $result = mysqli_fetch_all($result_filter, MYSQLI_ASSOC);
    // while ($row = mysqli_fetch_assoc($result_filter))
    // {
    // 	$result['category'][] = $row['category'];
    // }

if(!empty($result))
    {
    	$response['response'] = $result;
    }else{
    	$response['response'] = 0;
    }
}elseif($_GET['type'] == 'getData'){
	// $categories = ;
	$categories = str_replace(array('[', ']'), array('', ''), $_GET['categories']);
	
    $sql = "SELECT * FROM district_posting WHERE category IN($categories) AND sms_status = 0";
    $res = mysqli_query($con, $sql);
        // $row = mysqli_fetch_all($res, MYSQLI_ASSOC); 
        // echo "<pre>"; print_r($row); die();
    while ($row = mysqli_fetch_assoc($res)) {
    	$id = $row['posting_id'];
    	$phone_number = $row['mobile_no'];
    	if($phone_number != 0 && $phone_number != '' && strlen($phone_number) == 10){
	    	$message = "Dear ". $row['name'] .", ". $row['club_name'] .", \n You're invited to serve in a District Role for Rotary Year 2025-26. \n Click the link to know more & accept the invitation. \n https://rotary2982.org/distpost.php?id=". $row['token'];

$data[] = array('posting_id' => $id, 'phone_number' => $phone_number, 'message' => $message);
		}
		// $data['phone_number'][] = $phone_number;
		// $data['message'][] = $message;
    }

if(!empty($data))
    {
    	$response['response'] = $data;
    }else{
    	$response['response'] = 0;
    }

}elseif($_GET['type'] == 'update')
{
	header('Content-type: application/json');

$jsonData = file_get_contents('php://input');
    $data = json_decode($jsonData, true);

if (json_last_error() !== JSON_ERROR_NONE) {
        echo 'JSON Decode Error: ' . json_last_error_msg();
        die();
    }

foreach($data as $d)
    {
    	$sql = "UPDATE district_posting SET sms_status = ". $d['status'] .", sms_sent_date = '". $d['sentDate'] ."' WHERE posting_id = ". $d['postingId'];
    	$res = mysqli_query($con, $sql);
    }

if($res){
    	$response["success"] = 'success';
    }else{
    	$response['response'] = 0;
    }
}

if ($response && $response['response'] != '0') {
	$response["success"] = 1;
	$response["message"] = "sent";
	echo json_encode($response);
}elseif($response['response'] == '0') {
	$response["success"] = 0;
	$response["message"] = "failure";
	echo json_encode($response);
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: smsapi1.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation