<?php
$response = array();
 $WILAYA = $_GET['WILAYA'];

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

$db = new DB_CONNECT();

$result = mysql_query("SELECT *FROM cliniques WHERE WILAYA ='$WILAYA'") or die(mysql_error());

if (mysql_num_rows($result) > 0) {
        
$response["cliniques"] = array();
    
    
while ($row = mysql_fetch_array($result)) {
        
$clinique = array();
        
$clinique["ID"] = $row["ID"];
$clinique["NAME"] = $row["NAME"];
$clinique["CATEGORIE"] = $row["CATEGORIE"];
$clinique["DIRECTEUR"] = $row["DIRECTEUR"];
$clinique["ACTIVITY"] = $row["ACTIVITY"];
$clinique["ADRESS"] = $row["ADRESS"];
$clinique["COMMUN"] = $row["COMMUN"];
$clinique["WILAYA"] = $row["WILAYA"];
$clinique["TEL"] = $row["TEL"];
$clinique["FAX"] = $row["FAX"];                  
$clinique["LA"] = $row["LA"];                  
$clinique["LO"] = $row["LO"];                  
        
array_push($response["cliniques"], $clinique);
    }
        
$response["success"] = 1;
    
echo json_encode($response);
} 
else {
    
$response["success"] = 0;
    
$response["message"] = "No products found";
    
echo json_encode($response);
}
?>