PHPクエリ関數(shù)（クエリ條件により該當(dāng)テーブルのフィールドを取得する方法）
Jun 13, 2016 pm 12:01 PM
PHPクエリ関數(shù)（クエリ條件により該當(dāng)テーブルのフィールドを取得する方法）
<?php<br />//獲得連接<br />$db = mysql_connect("localhost", "root", "root") or die(mysql_error());<br />//echo "Connected to MySQL<br/>";<br />//連接數(shù)據(jù)庫(kù)<br />mysql_select_db("test") or die(mysql_error());<br />//echo "Connected to Database";<br /><br /> //查詢數(shù)據(jù)，并用表格顯示出來(lái) <br /> @$checked = $_POST['checked'];<br /> @$result = mysql_query("select * from books",$db);<br /> echo "<table border=1>\n"; <br /> echo "<tr><br /> <td>isbn</td><br /> <td>author</td><br /> <td>title</td><br /> <td>price</td><br /> "; <br /> echo "</tr>\n"; <br /> //循環(huán)遍歷 <br /> while ($myrow = mysql_fetch_row($result)){ <br /> printf("<tr><br /> <td>%s</td><br /> <td>%s</td><br /> <td>%s</td><br /> <td>%s</td>", $myrow[0], $myrow[1],$myrow[2],$myrow[3]);<br /> } <br /> echo "</table>\n";<br />?><br /><html><br /><head><br /><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><br /><title>無(wú)標(biāo)題文檔</title><br /></head><br /><body><br /><form action="" name=""><br/><br /> <br/><br /> <input type="button" value="查詢" name="submit"/><br /> <input type="text" name="checked"/><br /></form><br /></body><br /></html>-----解決策-------------- - -----
result = mysql_query("select * from Books where selected='$checked' ");
------解決策------ ----------------
if(isset($_POST['checked'])){
@$result = mysql_query (" select * from Books",$db);
echo "
| isbn |
