vlapi.php

<?php
error_reporting(0);
//error_reporting(E_ALL);
$format = 'json';
$mflcode = intval($_GET['mfl']);
 //Set our variables

//Connect to the Database
$con = mysqli_connect("10.230.50.11", "root", "FnP5FjbnMrzXCm.", "national_db");
if(mysqli_connect_errno())
{
	echo "Could not establish a connection to the Database";
}
if ($mflcode !='')
{
$sql2=mysqli_query($con, "select ID from facilitys where facilitycode='$mflcode'");
$ss2=mysqli_fetch_array($sql2, MYSQLI_ASSOC);
$facilityid=$ss2['ID'];
}
$sqlSelect = "SELECT v.ID as `ID`,v.patient as Patient,f.facilitycode as MFLCode,v.datecollected,v.datetested as DateTested,v.result as Result, j.name AS Justification FROM viralsamples_view v , facilitys f , viraljustifications j  WHERE  f.ID=v.facility_id and v.facility_id='$facilityid' and v.justification=j.ID and  v.repeatt=0 AND  v.flag=1  order by v.datetested desc";
// print_r($sqlSelect);die();
//echo 'uu'.$mflcode. '- : '. $facilityid;
//Run our query v.facility='$facilityid' and
$vresult = mysqli_query($con, $sqlSelect) or die('errpt');

 
//Preapre our output
if($format == 'json') {
 
$viralsamples = array();
while($viralsample = mysqli_fetch_array($vresult,MYSQLI_ASSOC)) {
$viralsamples [] = array('post'=>$viralsample);
}
 
$output = json_encode(array('posts' => $viralsamples ));
 
} 
elseif($format == 'xml') {
/*
 
header('Content-type: text/xml');
$output  = "<?xml version=\"1.0\"?>\n";
$output .= "<viralsamples >\n";
 
for($i = 0 ; $i < mysql_num_rows($vresult) ; $i++){
$row = mysql_fetch_assoc($vresult);

if  ($row['result'] == '< LDL copies/ml')
{
$outcome="Below LDL copies/ml";
}
elseif ($row['result'] == '<550') 
{
$outcome="Below 550 copies/ml";
}
elseif ($row['result'] == '< 400 ') 
{
$outcome="Below 400 copies/ml";
}
elseif ($row['result'] == '<150') 
{
$outcome="Below 150 copies/ml";
}
elseif ($row['result'] == '< 20 ') 
{
$outcome="Below 20 copies/ml";
}
elseif ($row['result'] == '< 2.00E+1 (1.30) ') 
{
$outcome="Below 20 copies/ml";
}
else
{
$outcome=$row['result'];
}

$output .= "<viralsample> \n";
$output .= "<viralsample_ID>" . $row['ID'] . "</viralsample_ID> \n";
$output .= "<viralsample_ccc_no>" . $row['patient'] . "</viralsample_ccc_no> \n";
$output .= "<viralsample_MFL_Code>" . $row['facilitycode'] . "</viralsample_MFL_Code> \n";
$output .= "<viralsample_datetested>" . $row['datetested'] . "</viralsample_datetested> \n";
$output .= "<viralsample_result>" . $outcome . "</viralsample_result> \n";
$output .= "<viralsample_justification>" . $row['justification'] . "</viralsample_justification> \n";

$output .= "</viralsample> \n";
}
 
$output .= "</viralsamples >";
 */
} else {
die('Improper response format.');
}
 
//Output the output.
echo $output;

 
?>