<?php
// array for JSON response
$response = array();
// include db connect class
require_once dirname(__FILE__) . '/db_connect.php';
// connecting to db
$db = new DB_CONNECT();
// check for post data
if (isset($_GET["ID"])) {
    $ID = $_GET['ID'];
    // get a clinique from cliniques table
    $result = mysql_query("SELECT *FROM cliniques WHERE ID = $ID");
if (!empty($result)) {
        // check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$clinique= array();
        
$clinique["ID"] = $result["ID"];
$clinique["NAME"] = $result["NAME"];        
$clinique["CATEGORIE"] = $result["CATEGORIE"];
$clinique["DIRECTEUR"] = $result["DIRECTEUR"];
$clinique["ACTIVITY"] = $result["ACTIVITY"];
$clinique["ADRESS"] = $result["ADRESS"];
$clinique["COMMUN"] = $result["COMMUN"];
$clinique["WILAYA"] = $result["WILAYA"];
$clinique["TEL"] = $result["TEL"];
$clinique["FAX"] = $result["FAX"]; 
$clinique["LA"] = $result["LA"];
$clinique["LO"] = $result["LO"];   
// success
            $response["success"] = 1;

            
// user node
            $response["clinique"] = array();

            
array_push($response["clinique"], $clinique);

            
// echoing JSON response
            echo json_encode($response);
        } 
else {
            // no product found
            
$response["success"] = 0;
            
$response["message"] = "No product found";

            
// echo no users JSON
            echo json_encode($response);
        }
    } 
else {
        // no clinique found
        $response["success"] = 0;
        
$response["message"] = "No product found";

        // echo no users JSON
        echo json_encode($response);
    }
} 
else {
    // required field is missing
    
$response["success"] = 0;
    $response["message"] = "Required field(s) is missing";

    
// echoing JSON response
    echo json_encode($response);
}
?>