php $con = mysql_connect(localhost:3306,root,); if (!$con) { die('could not connect: ' . mysql_error()); } mysql_select_db(test, $con); $result = mysql_query(select * from user); echo username password
; while($row = mysql_fetch_array($result)) { echo ; echo . $row['username'] . ; echo . $row['password'] . ; echo
; } echo
; mysql_close($con);?>
从服务器中获取用户所有信息（sql select语句）并以表格形式出现
php $con = mysql_connect(localhost,root,); if (!$con) { die('could not connect: ' . mysql_error()); } mysql_select_db(test, $con); mysql_query(delete from user where username = '$_post[username]'); mysql_close($con);?>
删除该用户所有信息delete.php
php $con = mysql_connect(localhost:3306,root,); if (!$con) { die('could not connect: ' . mysql_error()); } mysql_select_db(test, $con); $sql = insert into user (username,password) values ('$_post[username]','$_post[password]'); if (!mysql_query($sql,$con)) { die('error: ' . mysql_error()); } echo 1 record added; mysql_close($con);?>
注册一个新用户insert.php
php $con = mysql_connect(localhost,root,); if (!$con) { die('could not connect: ' . mysql_error()); } mysql_select_db(test, $con); mysql_query(update user set password = '$_post[password]' where username = '$_post[username]'); mysql_close($con);?>
修改一个用户密码update.php
用php向数据库中实现简单的增删改查
insert:
username:
password:
delete username:
are you sure?
update username:
you want to change your password into:
以上三个功能的提交源operate.html 以上就介绍了用php向数据库中实现简单的增删改查（纯代码，待完善），包括了方面的内容，希望对php教程有兴趣的朋友有所帮助。