首页 > 代码库 > 页面添加数据的PHP

页面添加数据的PHP

第一个页面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="http://www.mamicode.com/1" name="sex" / checked="checked"><input type="radio" value="http://www.mamicode.com/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=http://www.mamicode.com/‘{$arr[0]}‘>{$arr[1]}</option>";
                    }
            
            ?>
        </select>
</div>
<div>生日:<input type="text" name="birthday" /></div>
<div><input type="submit" value="http://www.mamicode.com/添加" /></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"添加失败";
    }
?>

 

页面添加数据的PHP