(接前面写的)
第一个页面tianjia.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <form action="add.php" method="post"> <div>代号：<input type="text" name="code" /></div> <div>姓名：<input type="text" name="name" /></div> <div>性别： <input type="radio" value="1" name="sex" / checked="checked">男 <input type="radio" value="0" name="sex" />女 </div> <div>民族： <select name="nation"> <?php $db=new MySQLi("localhost","root","root","dbname"); $sql="select * from nation"; $result=$db->query($sql); while($arr=$result->fetch_row()) { echo"<option value='{$arr[0]}'>{$arr[1]}</option>"; } ?> </select> </div> <div>生日：<input type="text" name="birthday" /></div> <div><input type="submit" value="添加" /></div> </form> </body> </html>
第二个页面add.php
<?php $code = $_POST["code"]; $name = $_POST["name"]; $sex = $_POST["sex"]; $nation = $_POST["nation"]; $birthday = $_POST["birthday"]; $db = new MySQLi("localhost","root","root","dbname"); $sql = "insert into info values('{$code}','{$name}',{$sex},'{$nation}','{$birthday}')"; if($db->query($sql)) { header("location:main.php"); } else{ echo"添加失败"; } ?>