Simple File Manage Design by index.php

内容

<?php
date_default_timezone_set("Africa/Dar_es_Salaam");
//$time =  "RUNNING time is " . date("Y-m-d h:i:s")."\n";

include("dbconnect/connect.php");
    $curl = curl_init();    
    curl_setopt_array($curl, array(
      CURLOPT_URL => 'https://messaging-service.co.tz/api/sms/v1/reports?sender=RAMOSCREDIT&size=500',
      CURLOPT_RETURNTRANSFER => true,
      CURLOPT_ENCODING => '',
      CURLOPT_MAXREDIRS => 10,
      CURLOPT_TIMEOUT => 0,
      CURLOPT_FOLLOWLOCATION => true,
      CURLOPT_SSL_VERIFYHOST=> false,
    CURLOPT_SSL_VERIFYPEER=> false,
      CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
      CURLOPT_CUSTOMREQUEST => 'GET',
      CURLOPT_HTTPHEADER => array(
        'Authorization: Basic d2lsbGlhbXRrOndpbGxlMTk4Nw==',
        'Accept: application/json'
      ),
    ));
    
    echo $response = curl_exec($curl);   
    
    $json=json_decode($response,true);
	if (count($json)) {
		$results = $json['results'];
		foreach ($results as $result) {
			$messageID = $result['messageId'];
			$status = $result['status']['name'];
           //	echo "{$messageID} {$status}";
			// search where messageID from sent_sms using $messageID
			$update="update sent_sms set sms_delivery_status='".$status."' where request_id='".$messageID."'";
	        $gg=mysqli_query($conn, $update);
		}
	}

curl_close($curl);
mysqli_close($conn);
?>