<?php

$response = array();

require_once dirname(__FILE__) . '/db_connect.php';

$db = new DB_CONNECT();

if (isset($_GET["ID"])) {
    $ID = $_GET['ID'];

    $result = mysql_query("SELECT *FROM labo WHERE ID = $ID");
if (!empty($result)) {
        // check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$lab= array();
        
$lab["ID"] = $result["ID"];
$lab["NAME"] = $result["NAME"];       
$lab["ADRESS"] = $result["ADRESS"];
$lab["WILAYA"] = $result["WILAYA"];
$lab["TEL"] = $result["TEL"];
$lab["FAX"] = $result["FAX"];   
$lab["LA"] = $result["LA"];
$lab["LO"] = $result["LO"]; 
// success
            $response["success"] = 1;

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

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

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

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

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

    
    echo json_encode($response);
}
?>