[請益] PHP查詢資料庫
最近在做一個運用表單去搜詢資料庫後再顯示出搜尋結果的系統
有兩個部分，一個是表單PHP(送出查詢字串)，另一個是顯是結果的PHP
但是結果無法顯示出來
以下是接收查詢字串並顯示搜尋結果的PHP
<?php
header("Content-Type: text/html; charset=utf-8");
include("connMysql.php");
$seldb=@mysql_select_db ("search");
if (!$seldb) die ("Error!");
$sql_query =" SELECT * FROM vocabulary WHERE ";
$sql_query .= "cChinese LIKE '%".$_POST["input"]."%'";
註:
已經測試過echo $sql_query的SQL語法是正確的，但在之後卻無法顯示出查詢結果
//echo $sql_query;
$result = mysql_query($sql_query);
$row_result=mysql_fetch_assoc($result);
while($row_result=mysql_fetch_assoc($result)){
foreach($row_result as $item=>$value){
echo $item."=".$value."<br />";
}
echo "<hr />";
}
?>
想知道問題出在哪裡，感謝~!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.25.212
推
10/13 11:34, , 1F
10/13 11:34, 1F
推
10/13 11:38, , 2F
10/13 11:38, 2F
→
10/13 13:19, , 3F
10/13 13:19, 3F
→
10/13 22:29, , 4F
10/13 22:29, 4F
→
10/13 22:30, , 5F
10/13 22:30, 5F
→
10/13 22:30, , 6F
10/13 22:30, 6F
→
10/13 22:31, , 7F
10/13 22:31, 7F
推
10/13 23:36, , 8F
10/13 23:36, 8F
→
10/17 07:32, , 9F
10/17 07:32, 9F
→
10/17 09:03, , 10F
10/17 09:03, 10F
→
10/17 22:46, , 11F
10/17 22:46, 11F
→
10/17 22:47, , 12F
10/17 22:47, 12F
→
10/17 23:45, , 13F
10/17 23:45, 13F
→
10/17 23:46, , 14F
10/17 23:46, 14F
→
10/18 06:44, , 15F
10/18 06:44, 15F
→
10/18 07:35, , 16F
10/18 07:35, 16F
→
10/18 10:18, , 17F
10/18 10:18, 17F
→
10/18 10:18, , 18F
10/18 10:18, 18F
→
10/18 12:51, , 19F
10/18 12:51, 19F
→
10/19 16:04, , 20F
10/19 16:04, 20F
討論串 (同標題文章)
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
