<?php
// array for JSON response

$response = array();
// include db connect class
require_once dirname(__FILE__) . '/db_connect.php';
$db = new DB_CONNECT();
$result = mysql_query("SELECT *FROM medecin WHERE A=1") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    
    
$response["medecin"] = array();
    
    
while ($row = mysql_fetch_array($result)) {
        
$medecin1 = array();
        
$medecin1["ID"] = $row["ID"];       
$medecin1["NAME"] = $row["NAME"];       
$medecin1["SPICIALITE"] = $row["SPICIALITE"];
$medecin1["MODE"] = $row["MODE"];
$medecin1["ADRESS"] = $row["ADRESS"];
$medecin1["COMMUN"] = $row["COMMUN"];
$medecin1["WILAYA"] = $row["WILAYA"];
$medecin1["TEL"] = $row["TEL"];
$medecin1["OPTIONE"] = $row["OPTIONE"]; 
$medecin1["LA"] = $row["LA"];
$medecin1["LO"] = $row["LO"];                 
        
array_push($response["medecin"], $medecin1);
    }
    
    
$response["success"] = 1;

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