MySQL foreground html
<meta http-equiv= "Content-type" content= "text/html; charset=gb2312 ">
<title> Set Meal </title>
<meta name= "generator" content= "Microsoft FrontPage 3.0" >
<meta name= "Microsoft Theme" content= "arcs 011" >
<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> eat! Haha ha! </big></big></big></big></strong></font></p>
<!--mstheme--> </font><table border= "1" width= "100%" "bordercolorlight=" #FFCC66 "bordercolordark=" CC9966 ">
<tr>
<TD width= "33%" > La carte Comrades: <select name= "Name" size= "1" >
<option value= "Lao li" > Lao li </option>
<option value= "Lao Zhang" > Lao Zhang </option>
<option value= "Xiao Wang" > Xiao Wang </option>
<option value= "Pony" > Pony </option>
</select><!--mstheme--></font></td>
<TD width= "33%" > Cuisine name Selection: <select name= "Eat" size= "1" >
<option value= "Shredded pork with fish flavor" > shredded pork with fish flavor </option>
<option value= "pan-cooked pork" > cooked pork </option>
<option value= "Lian Na fried Pork" > Lian Na Fried Pork </option>
<option value= "fried pork with garlic sauce" > Garlic fried Pork </option>
<option value= "Kimchi fried pork" > Fried pork with pickled vegetables </option>
<option value= "Green bamboo Shoots fry meat" > Green bamboo shoots fry meat </option>
<option value= "sweet and Sour Pork fillet" > Sweet and Sour Fillet </option>
<option value= "fried pork with celery" > cooked pork </option>
<option value= "braised fish in soy sauce" > cooked pork </option>
<option value= "hot kidney" > cooked pork </option>
<option value= "Spicy chicken" > Chili chicken </option>
<option value= "fried Beef with chili pepper" > Pork </option>
<option value= "Braised pork ribs" > cooked pork </option>
<option value= "sweet and Sour Pork fillet" > Sweet and Sour Fillet </option>
<option value= "agaric pork" > Edible fungus meat </option>
<option value= "gan bo cai" > Dried stir-fried vegetables </option>
<option value= "fried wax meat with celery" > sautéed wax meat with celery </option>
<option value= "Fried Babel with fine sand" > Sand fried Babel </option>
<option value= "Dry stir beans" > dry Stir Beans </option>
<option value= "Colorful fried shrimps" > Colorful fried shrimps </option>
<option value= "vinegar squash" > Vinegar squash </option>
<option value= "garlic belly strips" > garlic belly strips </option>
<option value= "Fish fragrant eggplant" > Fish fragrant Eggplant </option>
<option value= "chongqing spicy Chicken" > Chongqing spicy Chicken </option>
<option value= "Braised chicken Wings" > Braised chicken Wings </option>
<option value= "homemade tofu" > Homemade tofu </option>
<option value= "Scrambled eggs with tomatoes" > Scrambled eggs with tomatoes </option>
<option value= "Kung Pao Chicken" > Kung Pao Chicken </option>
<option value= "stir-fried beef with chili peppers" > Chili beef </option>
</select><!--mstheme--></font></td>
<TD width= "34%" > Staple: <select name= "ZS" size= "1" >
<option value= "Rice" > Rice </option>
<option value= "steamed bun" > steamed bun </option>
</select><!--mstheme--></font></td>
</tr>
</table>
<p><br>
<input type= "Submit" value= "submitted to Syed" > </p>
</form>
<!--mstheme--></font>
</body>
Background 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 "successfully sent!";
$query = "SELECT *";
$query. = "From Eat";
Odbc_result_all (Odbc_do ($conn, $query), "border=1");
Odbc_close ($conn);
?>
MySQL table structure
CREATE TABLE Eat (
Name Char (40),
Eat char (40),
ZS Char (40),
DateTime char (40)
);
