<?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 medecin from medecin table
    $result = mysql_query("SELECT *FROM medecin WHERE ID = $ID");
if (!empty($result)) {
        // check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$medecin1= array();
        
$medecin1["ID"] = $result["ID"];
        
$medecin1["NAME"] = $result["NAME"];
        
$medecin1["SPICIALITE"] = $result["SPICIALITE"];
$medecin1["MODE"] = $result["MODE"];
$medecin1["ADRESS"] = $result["ADRESS"];
$medecin1["COMMUN"] = $result["COMMUN"];
$medecin1["WILAYA"] = $result["WILAYA"];
$medecin1["TEL"] = $result["TEL"];
$medecin1["OPTIONE"] = $result["OPTIONE"];   
$medecin1["LA"] = $result["LA"];
$medecin1["LO"] = $result["LO"]; 

            $response["success"] = 1;

            
            $response["medecin1"] = array();

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

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