標籤：tac res fetch replace 顯示 utf-8 result sql語句 org
頁面1.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>無標題文檔</title></head><body><h1>資訊</h1><form action="1.php" method="post"><div> 請輸入姓名：<input type="text" name="name" /> <input type="submit" value="查詢" /></div></form><br /><table width="100%" border="1" cellpadding="0" cellspacing="0"><tr> <td>代號</td> <td>姓名</td> <td>電話</td> <td>分組</td></tr><?php//實現兩個邏輯//1.如果沒有POST資料，查所有//2.如果有POST資料，根據條件查$db = new MySQLi("localhost","root","root","dbname");/*if(POST傳值){ SQL語句1}else{ SQL語句2}*/$tj = " 1=1 "; //預設條件$name = "";//外面要寫一個預設值，若不寫，當不走if時會沒有值if(!empty($_POST)){ $name = $_POST[‘name‘]; $tj = " Name like ‘%{$name}%‘ ";}//將條件拼接到SQL語句$sql = "select * from contacts where {$tj}";//echo $sql;$result = $db->query($sql);while($arr = $result->fetch_row()){ //關鍵字的特殊顯示 $str = str_replace($name,"<mark>{$name}</mark>",$arr[1]); //尋找替換 //substr_replace(); //指定位置替換 echo "<tr> <td>{$arr[0]}</td> <td>{$str}</td> <td>{$arr[2]}</td> <td>{$arr[3]}</td></tr>";}?></table></body></html>
單條件查詢php
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
