<?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 dist_mat from dist_mat table
    $result = mysql_query("SELECT *FROM dist_mat WHERE ID = $ID");
if (!empty($result)) {
        // check for empty result
if (mysql_num_rows($result) > 0) {
$result = mysql_fetch_array($result);
$dist_mat1= array();
        
$dist_mat1["ID"] = $result["ID"];
$dist_mat1["NAME"] = $result["NAME"];        
$dist_mat1["ACTIVITY"] = $result["ACTIVITY"];
$dist_mat1["ADRESS"] = $result["ADRESS"];
$dist_mat1["WILAYA"] = $result["WILAYA"];
$dist_mat1["TEL"] = $result["TEL"];
$dist_mat1["FAX"] = $result["FAX"];  
$dist_mat1["LA"] = $result["LA"];
$dist_mat1["LO"] = $result["LO"];   
// success
            $response["success"] = 1;

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

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

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