一个用PHP和MYSQL写的定饭系统

value="鱼香茄子">鱼香茄子</option>
<option value="重庆辣子鸡">重庆辣子鸡</option>
<option value="红烧鸡翅">红烧鸡翅</option>
<option value="家常豆腐">家常豆腐</option>
<option value="西红柿炒鸡蛋">西红柿炒鸡蛋</option>
<option value="宫爆鸡丁">宫爆鸡丁</option>
<option value="时椒炒牛肉">时椒炒牛肉</option>
</select><!--mstheme--></font></td>
<td width="34%">主食: <select name="zs" size="1">
<option value="米饭">米饭</option>
<option value="馒头">馒头</option>
</select><!--mstheme--></font></td>
</tr>
</table>
<p><br>
<input type="submit" value=" 提交给李凯"> </p>
</form>
<!--mstheme--></font>
</body>
</html>
//后台php eat.php
<?php
$conn = odbc_connect("blue", "root", "");
$datetime=date("h:i A l")."_".date("F dS, Y");
$query ="insert into eat ( name,eat,zs,uptime) values (''$name'',''$eat'',''$zs'',''$datetime'')";
odbc_do($conn, $query);
echo "成功发送!";
$query = "select * ";
$query .= "from eat";
odbc_result_all( odbc_do($conn, $query), "border=1");
odbc_close($conn);
?>

//mysql表结构
CREATE TABLE eat(
name char(40),
eat char(40) ,
zs char(40) ,
datetime char(40)
);