php插入數(shù)據(jù)頁(yè)面insertData.php
<html>
<head>
<title>向數(shù)據(jù)庫(kù)中插入數(shù)據(jù)</title>
</head>
<body>
<center>
<form name="myForm" method="post" action="processInsertData.php">
<table bgcolor="cyan">
<tr>
<td>學(xué)號(hào)</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>
處理數(shù)據(jù)插入頁(yè)面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 "學(xué)生已添加到數(shù)據(jù)表中<br>";
else echo "該學(xué)生沒(méi)有添加進(jìn)數(shù)據(jù)表，請(qǐng)重新輸入。<br>";
mysql_close();
?>
<a href="insertData.php">返回添加頁(yè)面</a>
posted on 2009-07-01 14:03
期待明天 閱讀(6033)
評(píng)論(7) 編輯 收藏 所屬分類(lèi):
PHP