File Viewer

Choose a file to view: index.php json_query.php or go back to the demo

<?php
$mysqli = new mysqli("testdb.bavanyo.com", "bavanyodbuser01", "bavanyoDBPass01!", "bavanyo_example");
$array = array();

if ($mysqli->connect_errno) 
{
    $array[] = array("error"=>$mysqli->connect_error);
}
else
{
//Choose the sort order just for fun
	$orderBy = " ORDER BY `lname`,`fname` ASC";
	if(isset($_POST['listType']) and $_POST['listType'] == 'cert_date')
	{	 $orderBy = " ORDER BY `cert_date` DESC";}

//Create the LEFT JOIN which is equivalent in MySQL to LEFT OUTTER JOIN
	$query = "SELECT `lname`,`fname`,`cert_date`,`advanced_cert_date` FROM `scuba_divers` LEFT JOIN `advanced_divers` ON `scuba_divers`.`id` = `advanced_divers`.`diver_id` ".$orderBy;
	
//Transfer results to output array
	if ($result = $mysqli->query($query)) 
	{
	    while ($row = $result->fetch_assoc()) {
	        $array[] = $row;
	    }
	    $result->free();
	}
	else
	{
		$array[] = array("error"=>"Query Error");
	}
	$mysqli->close();	
}

//Encode and transmit
$jsonData = json_encode($array);
echo $jsonData;
?>