日期: 2019-11-14 09:53:21 人气: -
本文实例为大家分享了PHP连接数据库实现注册页面的增删改查操作的方法,供大家参考,具体内容如下
1.连接数据库
<?php
//本地测试
$host = '127.0.0.1';
$port = 3306;
$user = "root";
$pwd = "";
$link = @mysql_connect("{$host}:{$port}",$user,$pwd,true);
if(!$link) {
die("Connect Server Failed: " . mysql_error());
}
//选择连接的数据库库名
mysql_select_db("my");
//设置字符编码utf8
mysql_set_charset('utf8');
?>
2.注册页面(html页面)
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>Document</title>
<h3>注册页面</h3>
<form action="add.php" method="post">
<table border="1" cellpadding="0" cellspacing="0" width="80%" bgcolor="#ABCDEF">
<tbody><tr>
<td align="right">用户名</td>
<td><input type="text" name="username" id="">以小写字母开始,长度要求5~10</td>
</tr>
<tr>
<td align="right">密码</td>
<td><input type="password" name="password" id="">密码不能为空</td>
</tr>
<tr>
<td align="right">邮箱</td>
<td><input type="text" name="email" id=""></td>
</tr>
<tr>
<td align="right">性别</td>
<td>
<input type="radio" name="sex" id="" value="1">男
<input type="radio" name="sex" id="" value="2">女
<input type="radio" name="sex" id="" value="3">保密
</td>
</tr>
<tr>
<td align="right">个人简介</td>
<td>
<textarea name="txt" id="" cols="50" rows="10"></textarea>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="act" value="注册"></td>
</tr>
</tbody></table>
</form>
3.将注册数据显示在数据库
//往数据库中添加数据
<?php
header("Content-type:text/html; charset=utf-8");
//-----------------------连接数据库---------------------------
include_once "connect.php";
//-------------------------将数据连接到数据库------------------
$time=time();
$sql="insert into user (username,password,email,sex,txt,`time`) value('{$_POST['username']}','{$_POST['password']}','{$_POST['email']}','{$_POST['sex']}','{$_POST['txt']}','{$time}')";
$res=mysql_query($sql);
header("location:hello.php");
?>
4.返回后台界面
<?php
header("Content-type:text/html; charset=utf-8");
//-----------------------连接数据库------------------------------
include_once "connect.php";
//--------------------查询数据库--------------------------------
$query="select * from user";
$result=mysql_query($query);
if(!$result)
{
die("could not to the database<br>".mysql_error());
}
//-------------------封装函数-----------------------------
//该函数将数据库的数据写成数组形式
function result2Arr($result){
while($result_row=mysql_fetch_assoc($result)){
$arr[] = $result_row;
}
return $arr;
}
$arr = result2Arr($result);
foreach($arr as $key=>$value){
echo "";
echo "<table border="1px"></table>";
echo " ";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
//phpfensi.com
echo "";
echo "<table border="1px"><tbody><tr><td width="100px">".$value['id']."</td><td width="100px">".$value['username']."</td><td width="100px">".$value['password']."</td><td width="200px">".$value['email']."</td><td width="100px">".$value['sex']."</td><td width="100px">".$value['txt']."</td><td width="100px">".date('Y-m-d H:i:s',$value['time'])."</td><td width="100px"><a href="update1.php?id=$value[id]">修改</a> <a href="delete.php?id=$value[id]">删除</a></td></tr><tr></tr></tbody></table>";
}
?>
5.修改数据
//当用户要修改信息时,返回页面,页面中包含之前填写的信息
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>Document</title>
<div>
<?php
include_once "connect.php";
$sql="select * from user where id='".$_GET['id']."'";
//echo "sql:".$sql;(显示出修改哪一行)
$result=mysql_query($sql,$link);
$arr = result2Arr($result);
//print_r($arr);
$row = $arr[0];
function result2Arr($result){
while($result_row=mysql_fetch_assoc($result)){
$arr[] = $result_row;
}
return $arr;
}
?>
<h3>注册页面</h3>
<form action="update.php" method="post">
<input type="hidden" name="id" id="" value="<?php echo $row['id']?>">
<table border="1" cellpadding="0" cellspacing="0" width="80%" bgcolor="#ABCDEF">
<tbody><tr>
<td align="right">用户名</td>
<td><input type="text" name="username" id="" value="<?php echo $row['username']?>">以小写字母开始,长度要求5~10</td>
</tr>
<tr>
<td align="right">密码</td>
<td><input type="password" name="password" id="" value="<?php echo $row['password']?>">密码不能为空</td>
</tr>
<tr>
<td align="right">邮箱</td>
<td><input type="text" name="email" id="" value="<?php echo $row['email']?>"></td>
</tr>
<tr>
<td align="right">性别</td>
<td>
<input type="radio" name="sex" id="" value="1" <?php="" if($row['sex']="='1'){" echo="" 'checked';}?="">/>男
<input type="radio" name="sex" id="" value="2" <?php="" if($row['sex']="='2'){" echo="" 'checked';}?="">/>女
<input type="radio" name="sex" id="" value="3" <?php="" if($row['sex']="='3'){" echo="" 'checked';}?="">/>保密
</td>
</tr>
<tr>
<td align="right">个人简介</td>
<td>
<textarea name="txt" id="" cols="50" rows="10"><?php echo $row['txt']?></textarea>
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="act" value="修改"></td>
</tr>
</tbody></table>
</form>
</div>
//将修改的信息存入数据库
<?php
header("Content-type:text/html; charset=utf-8");
//通过post获取页面提交数据信息
$data = $_POST;
//print_r($data);
include_once "connect.php";
$sql = "update `user` set username='{$data['username']}',password='{$data['password']}', email='{$data['email']}',sex='{$data['sex']}',txt='{$data['txt']}' where id='{$data['id']}'";
echo $sql;
$res = mysql_query($sql,$link);
if($res){
header("Location:hello.php");
//echo "alert('修改成功')";
}else{
header("Location:update1.php?id=".$data['id']);
//echo "alert('修改失败')";
}
?>
6.删除数据
//删除数据库里的数据
<?php
header("Content-type:text/html; charset=utf-8");
include_once 'connect.php';
$sql = "delete from user where id='".$_GET['id']."'";
$sus=mysql_query($sql,$link);
if($sus){
header("location:hello.php");
//phpfensi.com
}else{
echo "alert('删除失败')";
}
?>
若要删除李四,点击删除后,会自动跳转到后台页面,数据库里数据也删除。