php 向数据库表中插入数据
php插入数据页面insertData.php
<html>
<head>
<title>向数据库中插入数据</title>
</head>
<body>
<center>
<form name="myForm" method="post" action="processInsertData.php">
<table bgcolor="cyan">
<tr>
<td>学号</td>
<td><input type="text" name="txtId" /></td>
</tr>
<tr>
<td>姓名</td>
<td><input type="text" name="txtName" /></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="txtAge"></td>
</tr>
<tr>
<td>性别</td>
<td>
<select name="sSex">
<option value="male">male</option>
<option value="female">female</option>
</select>
</td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="txtAddress"/></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="添加"/>
<input type="reset" name="reset" value="重置">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
处理数据插入页面processInsertData.php
<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("rorely");
$id=$_POST["txtId"]|null;
$name=$_POST["txtName"];
$age=$_POST["txtAge"];
$sex=$_POST["sSex"];
$address=$_POST["txtAddress"];
$exec="insert into test values($id,"$name",$age,"$sex","$address")";
$result=mysql_query($exec);
if($result) echo "学生已添加到数据表中<br>";
else echo "该学生没有添加进数据表，请重新输入。<br>";
mysql_close();
?>
<a href="insertData.php">返回添加页面</a>
<html>
<head>
<title>向数据库中插入数据</title>
</head>
<body>
<center>
<form name="myForm" method="post" action="processInsertData.php">
<table bgcolor="cyan">
<tr>
<td>学号</td>
<td><input type="text" name="txtId" /></td>
</tr>
<tr>
<td>姓名</td>
<td><input type="text" name="txtName" /></td>
</tr>
<tr>
<td>年龄</td>
<td><input type="text" name="txtAge"></td>
</tr>
<tr>
<td>性别</td>
<td>
<select name="sSex">
<option value="male">male</option>
<option value="female">female</option>
</select>
</td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="txtAddress"/></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="添加"/>
<input type="reset" name="reset" value="重置">
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
处理数据插入页面processInsertData.php
<?php
$link=mysql_connect("localhost","root","root");
mysql_select_db("rorely");
$id=$_POST["txtId"]|null;
$name=$_POST["txtName"];
$age=$_POST["txtAge"];
$sex=$_POST["sSex"];
$address=$_POST["txtAddress"];
$exec="insert into test values($id,"$name",$age,"$sex","$address")";
$result=mysql_query($exec);
if($result) echo "学生已添加到数据表中<br>";
else echo "该学生没有添加进数据表，请重新输入。<br>";
mysql_close();
?>
<a href="insertData.php">返回添加页面</a>
声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。
- 上一篇： PHP 将大量数据导出到 Excel 的方法
- 下一篇： ThinkPHP多表联合查询的常用方法
