$corporate_id = $v['other_id']; } // set where condition $wherearr[] = "id = '{$corporate_id}' "; // if auth != 2 } else { if (isset($_GET['id']) && $_GET['id'] != '') { $id = $_GET['id']; $wherearr[] = "id = '{$id}' "; } else { // get search condition from page $condition = $forms['condition']; if (!empty($condition)) { // get corporate_id $where_corporate_tantou_arr[] = "tantou_name like '%{$condition}%'"; $tantou_data = $corporate_tantou_dao->search($where_corporate_tantou_arr, $page); foreach ($tantou_data as $k => $v) { $corporate_id_arr[] = $v['corporate_id']; } foreach ($corporate_id_arr as $k => $v) { $where_search_arr[] = "a.id = '{$v}'"; } // set where search condition if (!empty($corporate_id_arr)) { //$where_search_arr [] = "a.id = '$corporate_id'"; } $where_search_arr[] = "a.corporate_name like '%{$condition}%'"; $where_search_arr[] = "a.another_name like '%{$condition}%'"; $where_search_arr[] = "a.address like '%{$condition}%'"; $where_search_arr[] = "a.tel like '%{$condition}%'"; $where_search_arr[] = "REPLACE(a.tel , '-', '') like '%{$condition}%' ";