<?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 hopitau from hopitaux table
    $result = mysql_query("SELECT *FROM hopitaux WHERE ID = $ID");
if (!empty($result)) {
        // check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$hopitau = array();
        
$hopitau["ID"] = $result["ID"];        
$hopitau["NAME"] = $result["NAME"];        
$hopitau["CATEGORIE"] = $result["CATEGORIE"];
$hopitau["ACTIVITY"] = $result["ACTIVITY"];
$hopitau["ADRESS"] = $result["ADRESS"];
$hopitau["COMMUN"] = $result["COMMUN"];
$hopitau["WILAYA"] = $result["WILAYA"];
$hopitau["TEL"] = $result["TEL"];
$hopitau["FAX"] = $result["FAX"];
$hopitau["LA"] = $result["LA"];
$hopitau["LO"] = $result["LO"];
  
// success
            $response["success"] = 1;

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

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

            
// 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 hopitau 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);
}
?>