<?php
	//
	function HTTPConnect($url){
		$ch = curl_init();
		curl_setopt($ch, CURLOPT_URL , $url);
		curl_setopt($ch, CURLOPT_HEADER, 0);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
	        //curl_setopt ( $ch, CURLOPT_CONNECTTIMEOUT, $timeout );
	        //
		$response = curl_exec($ch);
		curl_close($ch);	
		return $response;
	}
    // get these variable from url
require_once('connect.php');
$db=db_connect();
$sql="select matNo from realdata where matNo like 'ME%'";
$sql_ex=$db->query('$sql');
//while ($row=$sql_ex->fetch(PDO::FETCH_BOTH)) {

$row=$sql_ex->fetch(PDO::FETCH_BOTH);

    $RegNumber = $row[0];
    $Session = "2018/2019";
    $Semester = "First";
    $Category = "Regular"; // or Summer;
    //
    $PortalURL = "http://orchids-transactions.com/SMSMobile/orchids_call.php?";
    $parameters = $PortalURL . "opCode=RESULT_CHECKING&RegNumber=$RegNumber&Session=$Session&Semester=$Semester&Category=$Category";
    $jsondata = HTTPConnect($parameters);
    echo $jsondata;

    // Convert JSON string to Array
    $arrObj = json_decode($jsondata, true); // Set second argument as TRUE
    $RecKount = count($arrObj['Results']);
    if ($RecKount != 0) {
        echo $arrObj['Results'][0]['MatricNo'] .'-'.$arrObj['Results'][0]['FullNames'].'-'.$arrObj['Results'][0]['CGPA'].'<br>';
//        echo '<br>' . $arrObj['Results'][0][''];

    }
die();
//}
?>