我正试图使一个订单状态页面,我将在phpmyadmin手动调整,但我希望人们能够使用表单来输入他们的订单号,然后给予适当的名称和状态附加到该订单号。
这是index.php
<?php
$username = "username";
$password = "password";
$hostname = "localhost";
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
?>
<form method="POST" action="action.php">
<input type="text" name="term" />
<input type="submit" value="Submit" name="submit" />
</form>
这是我的动作。php
<?php
$username = "evo_readle";
$password = "judo08";
$hostname = "localhost";
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "Connected to MySQL<br>";
$term = mysql_real_escape_string($_REQUEST['term']);
$query = mysql_query("SELECT * FROM orders WHERE number ='%".$term."%'");
$user = mysql_fetch_assoc($query);
echo "Hello User, your name is" .$user['name'];
?>
如果要在SQL查询中使用通配符,则需要关键字LIKE
。所以
$query = mysql_query("SELECT * FROM orders WHERE number ='%".$term."%'");
将成为:
$query = mysql_query("SELECT * FROM orders WHERE number LIKE '%".$term."%'");
我还可以建议你开始学习为什么不使用mysql_*
函数吗?阅读这篇文章