订单状态脚本

我正试图使一个订单状态页面，我将在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'];
?>