epihackUSSD.php

<?php
    require_once('dbConnector.php');

    $sessionId   = $_POST["sessionId"];
    $serviceCode = $_POST["serviceCode"];
    $phoneNumber = $_POST["phoneNumber"];
    $text        = $_POST["text"];

    $level = explode("*", $text);

    if (isset($text)) {
   
        if ( $text == "" ) {
            $response="CON Welcome to the EpiHack portal.\nPlease enter Village/District name";
        }
        if(isset($level[0]) && $level[0]!="" && !isset($level[1])) {
          $response="CON Please enter your message";
             
        }
        else if(isset($level[1]) && $level[1]!="" && !isset($level[2])) {
                $response="CON Please enter number of cases\n"; 
        }
        else if(isset($level[2]) && $level[2]!="" && !isset($level[3])) {
                $response="CON Please enter number of dead\n"; 
        }
        else if(isset($level[3]) && $level[3]!="" && !isset($level[4])) {
            

            $sql01 = "INSERT INTO `epi_report` (`session_id`, `phone_number`, `village_dist_name`, `message`, `number_cases`, `number_dead`) VALUES('".$sessionId."','".$phoneNumber."', '".$level[0]."', '".$level[1]."', '".$level[2]."', '".$level[3]."')";
            $db->query($sql01);
            
            $response="END Thank you for reporting ".$level[0]." with ".$level[2]." cases and ".$level[3]." dead.\n District Health Facility will SMS/CALL soon"; 
        }
        header('Content-type: text/plain');
        echo $response;
    }
?>