<?php include("db_config.php"); 
if($_SERVER['REQUEST_METHOD']=='POST'){
	$usersList_array =array();
    $row_array = array();
    $note_array = array();
	$sql="select * from category";
    $result = mysqli_query($conn, $sql);
     $json_response = array();
	if(mysqli_num_rows($result) > 0) {
	while($row = mysqli_fetch_assoc($result)) {
    $row_array['cat_banner'] = $row['cat_banner'];        
    $row_array['cat_name'] = $row['cat_name'];        
    $row_array['id'] = $row['id'];
    $row_array['notes'] = array();
	$category = $row['id'];
	$sqls="select sub_category.* from sub_category where category_id='$category'";
    $results = mysqli_query($conn, $sqls);
	while($rows = mysqli_fetch_assoc($results)){
             $note_array['id'] = $rows['id'];
             $note_array['sub_category_name'] = $rows['sub_category_name'];
            $note_array['sub_categoryimg'] = $rows['sub_categoryimg'];
            $note_array['subcat_banner'] = $rows['subcat_banner'];
            array_push($row_array['notes'],$note_array);
	   }
      array_push($usersList_array, $row_array);
	 }
	}
	echo json_encode($usersList_array, JSON_PRETTY_PRINT);
	//echo json_encode($response);
	mysqli_close($conn);
}