$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect('localhost','root','admin')or die('数据库连接失败');
mysql_query('use phpvideo');
mysql_query('set names utf8');
$sql = "SELECT * FROM t_one WHERE username LIKE '%{$keywords}%'";
$rs = mysql_query($sql);
$users = array();
if(!empty($keywords)){
while($row = mysql_fetch_assoc($rs)){
$users[]= $row;
}
}
print_r($users);
?>
ee22
xx:
echo '
查询关键字 '.$keywords.'的结果
';if($users){
echo '
echo '
用户>';//这里有个FOR循环我就不写了,写了也没用
echo '
';}else{
echo '没有用户';
}
?>