菜鸟学编程第三式——PHP编程环境搭建及实例2

最新推荐文章于 2023-03-12 09:46:34 发布

skysandy

最新推荐文章于 2023-03-12 09:46:34 发布

阅读量836

点赞数

分类专栏：编程技术文章标签：编程 php query mysql database delete

本文链接：https://blog.csdn.net/skysandy/article/details/5524079

版权

编程技术专栏收录该内容

14 篇文章 0 订阅

订阅专栏

修改某条记录的内容：MySQL>update DUser set UserPsd ='123' where UserId=1;<enter>；

删除某条记录的内容，可以使用：MySQL> delete from DUser where UserId =1 limit 1;<enter>，表示删除UserId 等于1的记录，且只删除一条记录。

注意：以上建库及表可以直接通过http://localhosy/phpMyAdmin用户界面来操作。

1.1 PHP编程实例

2.2.1设计

1、我们的目标是建立几个简单的网页来显示、添加、修改、删除用户；

2、建立以下几个网页：

页面show.php显示数据库中的所有用户

页面add.php添加用户

页面edit.php修改用户信息

页面del.php删除指定用户

2.2.2编程

1、显示用户

show.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h2>Show Data from DUser</h2> <?php mysql_connect(localhost, "root", "iloveu") or die ("Problem connecting to DataBase"); $query = "select * from DUser"; $result = mysql_db_query("PhpExample", $query); if ($result) { echo "Found these dataes in the database:<br><p></p>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#00FFFF>UserId</td> <td align=center bgcolor=#00FFFF>UserName</td> <td align=center bgcolor=#00FFFF>UserPsd</td> <td align=center bgcolor=#00FFFF>UserDetail</td> <td align=center bgcolor=#00FFFF>编辑操作</td> <td align=center bgcolor=#00FFFF>删除操作</td> </tr>"; while ($r = mysql_fetch_array($result)) { $myUserId = $r["UserId"]; $myUserName = $r["UserName"]; $myUserPsd = $r["UserPsd"]; $myUserDetail = $r["UserDetail"]; echo "<tr> <td>$myUserId</td> <td>$myUserName</td> <td>$myUserPsd</td> <td>$myUserDetail</td> <td><a href="/" mce_href="/""edit.php?UserId=$myUserId&UserName=$myUserName&UserPsd=$myUserPsd&UserDetail=$myUserDetail/">编辑</a></td> <td><a href="/" mce_href="/""del.php?UserId=$myUserId&UserName=$myUserName/">删除</a></td> </tr>"; } echo "</table>"; } else { echo "No data."; } mysql_free_result($result); ?> <br /> <table width=90% align=center> <tr> <td><a href="add.php" mce_href="add.php">添加用户</a></td> </tr> </table> </body> </html>

运行之后，界面如下所示：

2、添加用户

add.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h1>Add an User</h1> <form method="post" action="adddb.php"> <table width=90% align=center> <tr><td colspan=2>请填写用户信息(此处未做UserId唯一性认证)：</td></tr> <tr><td>UserId: </td><td><input type=text name=txt_UserId size=40 maxlength=3 value=""></td></tr> <tr><td>UserName: </td><td><input type=text name=txt_UserName size=40 maxlength=20 value=""></td></tr> <tr><td>UserPsd: </td><td><input type=text name=txt_UserPsd size=40 maxlength=50 value=""></td></tr> <tr><td>UserDetail: </td><td><input type=text name=txt_UserDetail size=40 maxlength=100 value=""></td></tr> <tr><td></td><td><input type=submit value="Add"></td></tr> </table> </form> </body> </html>

运行之后，界面如下所示：

adddb.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h2>Add an User Result</h2> <?php mysql_connect(localhost, "root", "iloveu") or die ("Problem connecting to DataBase"); $query = "INSERT INTO DUser VALUES($txt_UserId,'$txt_UserName','$txt_UserPsd','$txt_UserDetail')"; $result = mysql_db_query("PhpExample", $query); if ($result) { $query_2 = "SELECT * FROM DUser"; $result_2 = mysql_db_query("PhpExample", $query_2); echo "Add data success!<br><p></p>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#00FFFF>UserId</td> <td align=center bgcolor=#00FFFF>UserName</td> <td align=center bgcolor=#00FFFF>UserPsd</td> <td align=center bgcolor=#00FFFF>UserDetail</td> </tr>"; while ($r = mysql_fetch_array($result_2)) { $myUserId = $r["UserId"]; $myUserName = $r["UserName"]; $myUserPsd = $r["UserPsd"]; $myUserDetail = $r["UserDetail"]; echo "<tr> <td>$myUserId</td> <td>$myUserName</td> <td>$myUserPsd</td> <td>$myUserDetail</td> </tr>"; } echo "</table>"; mysql_free_result($result_2); } else { echo "Add data False."; } mysql_free_result($result); ?> </body> </html>

运行之后，界面如下所示：

3、修改用户

Edit.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h1>Edit an User</h1> <form method="post" action="editdb.php"> <table width=90% align=center> <tr><td>UserId:</td><td><?php echo $_GET['UserId']; ?></td></tr> <tr><td>UserName: </td><td><input type=text name=txt_UserName size=40 maxlength=100 value="<?php echo $_GET['UserName'];?>"></td></tr> <tr><td>UserPsd: </td><td><input type=text name=txt_UserPsd size=40 maxlength=100 value="<?php echo $_GET['UserPsd'];?>"></td></tr> <tr><td>UserDetail:</td><td><input type=text name=txt_UserDetail size=40 maxlength=100 value="<?php echo $_GET['UserDetail'];?>"></td></tr> <tr><td></td><td><input type=submit value="Edit"></td></tr></table> <input type=hidden name=txt_UserId value="<?php echo $_GET['UserId'];?>"> </form> </body> </html>

运行之后，界面如下所示：

editdb.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h2>Edit an User Result</h2> <?php mysql_connect(localhost, "root", "iloveu") or die ("Problem connecting to DataBase"); $query = "update DUser set UserName='$txt_UserName',UserPsd='$txt_UserPsd',UserDetail='$txt_UserDetail' where UserId=$txt_UserId "; $result = mysql_db_query("PhpExample", $query); if ($result) { $query_2 = "SELECT * FROM DUser"; $result_2 = mysql_db_query("PhpExample", $query_2); echo "Edit data success!<br><p></p>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#00FFFF>UserId</td> <td align=center bgcolor=#00FFFF>UserName</td> <td align=center bgcolor=#00FFFF>UserPsd</td> <td align=center bgcolor=#00FFFF>UserDetail</td> </tr>"; while ($r = mysql_fetch_array($result_2)) { $myUserId = $r["UserId"]; $myUserName = $r["UserName"]; $myUserPsd = $r["UserPsd"]; $myUserDetail = $r["UserDetail"]; echo "<tr> <td>$myUserId</td> <td>$myUserName</td> <td>$myUserPsd</td> <td>$myUserDetail</td> </tr>"; } echo "</table>"; mysql_free_result($result_2); } else { echo "Edit data False."; } mysql_free_result($result); ?> </body> </html>

运行之后，界面如下所示：

4、删除用户

del.php内容如下：

<html> <head> <title>Robin PHP Exmaple</title> </head> <body> <h2>Delete an User Result</h2> <?php $userId=$_GET['UserId']; $userName=$_GET['UserName']; mysql_connect(localhost, "root", "iloveu") or die ("Problem connecting to DataBase"); $query = "delete from DUser where UserId=$UserId and UserName='$userName' "; $result = mysql_db_query("PhpExample", $query); if ($result) { $query_2 = "SELECT * FROM DUser"; $result_2 = mysql_db_query("PhpExample", $query_2); echo "Delete data success!<br><p></p>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#00FFFF>UserId</td> <td align=center bgcolor=#00FFFF>UserName</td> <td align=center bgcolor=#00FFFF>UserPsd</td> <td align=center bgcolor=#00FFFF>UserDetail</td> </tr>"; while ($r = mysql_fetch_array($result_2)) { $myUserId = $r["UserId"]; $myUserName = $r["UserName"]; $myUserPsd = $r["UserPsd"]; $myUserDetail = $r["UserDetail"]; echo "<tr> <td>$myUserId</td> <td>$myUserName</td> <td>$myUserPsd</td> <td>$myUserDetail</td> </tr>"; } echo "</table>"; mysql_free_result($result_2); } else { echo "delete data False."; } mysql_free_result($result); ?> </body> </html>

运行之后，界面如下所示：

skysandy

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
菜鸟学编程第三式——PHP编程环境搭建及实例2

修改某条记录的内容：MySQL>update DUser set UserPsd =123 where UserId=1;；删除某条记录的内容，可以使用：MySQL> delete from DUser where UserId =1 limit 1;，表示删除UserId 等于1的记录，且只删除一条记录。注意：以上建库及表可以直接通过http://localhosy/ph
复制链接

扫一扫

专栏目录