PHP连接数据库实现注册页面的增删改查操作

2024-05-04 22:01:40

字体：大中小

来源：转载

供稿：网友

本文实例为大家分享了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 "";

//Vevb.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");

//Vevb.com

}else{

echo "alert('删除失败')";

}

?>