1增
insert.php
<html>
<head>
</head>
<body>
<form action="doinsert.php" method="POST">
<p>
ID:<br/>
<input type="text" name="id" size="6" maxlength="6" />
</p>
<p>
给自己起一个名号:<br/>
<input type="text" name="name" size="10" maxlength="10" />
</p>
<p>
给自己设一个密码:<br/>
<input type="password" name="password" size="8" maxlength="8" value=""/>
</p>
<p>
你的email地址:<br/>
<input type="text" name="email" size="20" maxlength="20" value=""/>
</p>
<p>
<input type="submit" name="submit" value="Submit!"/>
</p>
</form>
</body>
</html>
doinsert.php
<?php
$linkID=@mysql_connect("localhost","root","123456");
if(!$linkID){
echo "没连接上";
}
$ss=@mysql_select_db("bean");
if(!$ss){
echo "没找到数据库";
}
$id = $_POST['id'];
$name = $_POST['name'];
$password = $_POST['password'];
$email = $_POST['email'];
$query = "INSERT INTO member3 (id,name,password,email) values(
'$id','$name','$password','$email')";
//$query = "insert into member3 set
// id='$id',name='$name',password='$password',email='$email'";
$result = mysql_query($query);
if($result) echo "<p>member successfuly insert!</p>";
else echo "<p>There was a problem inserting the member!</p>";
mysql_close();
include "insert.php" //返回并继续插入
?>
2查询并且修改
form.php
<html>
<head>
</head>
<body>
<form action="modify.php" method="post">
<select name="rowID">
<option value="">choose a ID:</option>
