PHP ?? ?? ?? ??? ??
??? ??
?????? ??
<?php
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect("localhost", "root", "root") or die("數(shù)據(jù)庫(kù)鏈接錯(cuò)誤");
mysql_select_db("sql", $conn);
mysql_query("set names 'utf8'"); //使用utf-8中文編碼;
?>? ??? ?? ??????? ?? ?? ??? ?????.
<?php
$sql="SELECT * FROM user WHERE username LIKE '%{$keywords}%'";
$rs= mysql_query($sql);
$users = array();//保存所以得查詢到的用戶
?>?? ?? ?? ???? ?? ???? ????
$users? ?????. ??? ?? ???? ?? ?? ???? ????. ??? Page
<?php
if ($keywords){
echo '<h3>查詢關(guān)鍵詞：<font color="red">'.$keywords.'</font></h3>';
}
if ($users){
echo '<table width="500" cellpadding="5">';
echo '<tr><th>用戶名</th><th>密碼</th><th>郵箱</th><th>性別</th><th>愛(ài)好</th>';
foreach ($users as $key=>$value){
echo '<tr>';
echo '<td>'.$value['username'].'</td>';
echo '<td>'.$value['password'].'</td>';
echo '<td>'.$value['sex'].'</td>';
echo '<td>'.$value['email'].'</td>';
echo '<td>'.$value['hobby'].'</td>';
echo '</tr>';
}
}else{
echo '沒(méi)有查詢到相關(guān)用戶';
}
?>? ???????. ??? ??? ????? ?? Key Points? ????????. 
SQL? ???? ???????? ?? ?? ??
