mysql 前台html
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>定飯</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<meta name="Microsoft Theme" content="arcs 011">
</head>
<body background="arctile.jpg" bgcolor="#FFFFFF" text="#000000" link="#3399FF"
vlink="#3366CC" alink="#FF9900">
<form enctype="multipart/form-data" action="eat.php" method="post" align="center">
<p> </p>
<p><font color="#0000FF"><strong><big><big><big><big>吃飯了！哈哈哈！</big></big></big></big></strong></font></p>
<!--mstheme--> </font><table border="1" width="100%" bordercolorlight="#FFCC66" bordercolordark="#CC9966">
<tr>
<td width="33%">點菜的同志: <select name="name" size="1">
<option value="老李">老李</option>
<option value="老張">老張</option>
<option value="小汪">小汪</option>
<option value="小馬">小馬</option>
</select><!--mstheme--></font></td>
<td width="33%">菜名選擇: <select name="eat" size="1">
<option value="魚香肉絲">魚香肉絲</option>
<option value="回鍋肉">回鍋肉</option>
<option value="蓮菜炒肉">蓮菜炒肉</option>
<option value="蒜薹炒肉">蒜薹炒肉</option>
<option value="泡菜炒肉">泡菜炒肉</option>
<option value="青筍炒肉">青筍炒肉</option>
<option value="糖醋裡脊">糖醋裡脊</option>
<option value="西芹炒肉">回鍋肉</option>
<option value="紅燒帶魚">回鍋肉</option>
<option value="火爆腰花">回鍋肉</option>
<option value="辣子雞">辣子雞</option>
<option value="時椒炒牛肉">回鍋肉</option>
<option value="紅燒排骨">回鍋肉</option>
<option value="糖醋裡脊">糖醋裡脊</option>
<option value="木耳肉片">木耳肉片</option>
<option value="幹煸波菜">幹煸波菜</option>
<option value="西芹炒蠟肉">西芹炒蠟肉</option>
<option value="細沙炒八寶">細沙炒八寶</option>
<option value="幹煸豆角">幹煸豆角</option>
<option value="五彩炒蝦仁">五彩炒蝦仁</option>
<option value="醋溜西葫蘆">醋溜西葫蘆</option>
<option value="大蒜肚條">大蒜肚條</option>
<option 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)
);
