各位大侠,帮我看下面的$name变量,为什么把它放到查询语句中
$query='select * from books.book where book_id=$_POST["name"]; ';
得不到变量,如果只是显示的话,又没问题。???1.
<font size="7">图书管理</font>
<form action="dekita.php" method="post">
<p>请输入查询内容: <input type="text" name="name" VALUE=""/></p>
<p><input type="submit" value="开始查询" /></p>
</form>2.$link = mysql_connect('localhost','root','') or die('could not connect:' . mysql_error());
echo 'conected successfully';
mysql_select_db('mysql') or die('Could not select database');
$query='select * from books.book where book_id=$_POST["name"]; ';$result= mysql_query($query) or die('Query failed:' . mysql_error()) ;//用HTML显示结果
echo "<table>\n";
while ($line =mysql_fetch_array($result,MYSQL_ASSOC)){
echo "\t<tr>\n";
foreach($line as $col_value){
echo"\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";//释放数据集
mysql_free_result($result);//关闭连接
mysql_close($link);
?>
$query='select * from books.book where book_id=$_POST["name"]; ';
得不到变量,如果只是显示的话,又没问题。???1.
<font size="7">图书管理</font>
<form action="dekita.php" method="post">
<p>请输入查询内容: <input type="text" name="name" VALUE=""/></p>
<p><input type="submit" value="开始查询" /></p>
</form>2.$link = mysql_connect('localhost','root','') or die('could not connect:' . mysql_error());
echo 'conected successfully';
mysql_select_db('mysql') or die('Could not select database');
$query='select * from books.book where book_id=$_POST["name"]; ';$result= mysql_query($query) or die('Query failed:' . mysql_error()) ;//用HTML显示结果
echo "<table>\n";
while ($line =mysql_fetch_array($result,MYSQL_ASSOC)){
echo "\t<tr>\n";
foreach($line as $col_value){
echo"\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";//释放数据集
mysql_free_result($result);//关闭连接
mysql_close($link);
?>
用2个字符串相连
头大呀!!!
改
$query='select * from books.book where book_id='.$_POST["name"];
在双引号下变量可以不用.号来连接
改下面试一下:
$query="select * from books.book where book_id='$_POST["name"]'";