PHP查询的问题

Rqprqp

从表单的文本框中获得的信息是不是都保存在$post中，我想根据用户输入的信息，检索出相关的内容，各位大大看看这段代码行不行，谢谢了！


<?php
//connect to MySQL
$connect = mysql_connect("localhost", "bp5am", "bp5ampass"
  or die("Hey loser, check your server connection.";

//make sure we're using the right database
mysql_select_db("moviesite";

$query = "SELECT *" .
         "FROM products " .
         "WHERE book=$post " .\\这样的条件对么，book是我表中书名字的字段
        
$results = mysql_query($query)
  or die(mysql_error());

while ($row = mysql_fetch_array($results)) {
  extract($row);
  echo $book;
  echo "<br>;";
}

?>;

james.liu

$query = "SELECT *" .
        "FROM products " .
        "WHERE book=$post " .\\这样的条件对么，book是我表中书名字的字段

将$post用单引号抱一下，，Like this ,,'$post'
后面到底是小点点还是分号;啊？

yanjing5462

$query = "SELECT * FROM products WHERE book='$post' " ;
其中双引号里的代表字符串

Rqprqp

谢谢各位大大帮助~

geel

从头开始扎扎实实的学习

post过来的数据是保存在 $_POST[] 数组中的

narkissos

楼主，当你register_globals = On时，才可以使用直接post过来的变量，否则，请使用$_POST['post'];对于get的数据，$_GET['get']……

Rqprqp

太感谢了，我说怎么变量老是传不过来~
还有6天就毕业答辩了，真是及时呀！

Rqprqp

大侠在帮我看看，我试了，用$_POST['post']，还是不行
<?php
//connect to MySQL
$connect = mysql_connect("localhost", "peng", "123456"
  or die("Hey loser, check your server connection.";

<?php
//connect to MySQL
$connect = mysql_connect("localhost", "peng", "123456"
  or die("Hey loser, check your server connection.";

//make sure we're using the right database
mysql_select_db("good";

$query = "SELECT * FROM products where price= '$_POST['post']'" ;
      
$results = mysql_query($query)
  or die(mysql_error());

while ($rows=mysql_fetch_array($results)) {
extract($rows);
echo $name;
echo " - ";
echo $price;
echo "<br>;";
}

?>;

Rqprqp

是我搞错了，现在就好了~
这样写就好了，
$query = "SELECT * FROM products where price='$_POST[chaxun]'" ;