escape(trim($_GET['searchTerm'])); // $search_q = " AND concat(sd.code,' - ',sd.`name`) LIKE '%$search%' "; // }else{ // $search = ""; // $search_q = ""; // } if(isset($_POST['dealer_id'])){ $dealer_id = $db -> escape(trim($_POST['dealer_id'])); // $dealer_q = " AND scd.company_id = '$company_id' "; }else{ $dealer_id = ""; // $dealer_q = ""; } // $type = $_GET['type']; $query = "SELECT sb.id, sb.name AS brand_name FROM source_dealer sd INNER JOIN source_brand sb ON sd.brand_id=sb.id WHERE sd.id = '$dealer_id'"; // echo $query; exit; $count = $db->select($query); $fetch_brand = $db->sql_query($query); // $json = []; if($count == 0){ echo ''; } else { while($row = $fetch_brand->fetch_assoc()) { echo ''; } } // $employee_info = $db -> return_result(sprintf($query,$search_q,$company_q)); // $json = []; // foreach($employee_info as $data){ // $json[] = ['id'=>$data['id'], 'text'=>$data['code'] .' - '. $data['name']]; // } // if(isset($_GET['import'])){ // $json[] = ['id'=>0, 'text'=>'DIFFERENT DEALERSHIP (SYSTEM DECIDED)']; // } // echo json_encode($json); ?>