<?php
$response = array();
require_once dirname(__FILE__) . '/db_connect.php';
$db = new DB_CONNECT();
$result = mysql_query("SELECT *FROM dist_mat WHERE A=1") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
    
        
$response["dist_mat"] = array();
    
    
while ($row = mysql_fetch_array($result)) {
        
$dist_mat1 = array();
        
$dist_mat1["ID"] = $row["ID"];
        
$dist_mat1["NAME"] = $row["NAME"];

$dist_mat1["ACTIVITY"] = $row["ACTIVITY"];        
$dist_mat1["ADRESS"] = $row["ADRESS"];
$dist_mat1["WILAYA"] = $row["WILAYA"];
$dist_mat1["TEL"] = $row["TEL"];
$dist_mat1["FAX"] = $row["FAX"];
$dist_mat1["LA"] = $row["LA"];
$dist_mat1["LO"] = $row["LO"];                   
        
array_push($response["dist_mat"], $dist_mat1);
    }
    
    
$response["success"] = 1;

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

    
    
echo json_encode($response);
}
?>