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

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


$db = new DB_CONNECT();

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

if (mysql_num_rows($result) > 0) {
    
$response["hopitaux"] = array();
    
while ($row = mysql_fetch_array($result)) {
        
$hopitau1 = array();
        
$hopitau1["ID"] = $row["ID"];       
$hopitau1["NAME"] = $row["NAME"];       
$hopitau1["CATEGORIE"] = $row["CATEGORIE"];
$hopitau1["ACTIVITY"] = $row["ACTIVITY"];
$hopitau1["ADRESS"] = $row["ADRESS"];
$hopitau1["COMMUN"] = $row["COMMUN"];
$hopitau1["WILAYA"] = $row["WILAYA"];
$hopitau1["TEL"] = $row["TEL"];
$hopitau1["FAX"] = $row["FAX"];
$hopitau1["LA"] = $row["LA"];
$hopitau1["LO"] = $row["LO"];                  
        
array_push($response["hopitaux"], $hopitau1);
    }
    
    
$response["success"] = 1;
    
echo json_encode($response);
} 
?>