get_results("SELECT * FROM ".$wpdb->prefix."adminnote WHERE (`name` LIKE '%".$_POST['s']."%' OR `text` LIKE '%".$_POST['s']."%') AND `create_by` = '$current_user->ID' ORDER BY `id` DESC" ); $xhtml = ''; if(!empty($note_info)){ foreach($note_info as $k=>$note): $xhtml .= ''; $xhtml .= ''; $xhtml .= ''.$note->name.''; $xhtml .= ''.getUserName($note->userid).''; $xhtml .= ''.getUserName($note->create_by).''; $xhtml .= ''.$note->time.''; $xhtml .= ''; endforeach; }else{ $xhtml .= 'No data show'; } echo $xhtml; } if(!function_exists('getUserName')){ function getUserName($id){ global $wpdb; $user_info = $wpdb->get_row("SELECT * FROM $wpdb->users WHERE `ID` = ".$id); return $user_info->display_name; } } ?>