用php向数据库中实现简单的增删改查(纯代码,待完善),php增删
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
html> head> title>formtitle> head> body> br /> h1>insert:h1> form action=insert.php method=post> username:input type=name name=username/> br /> password:input type=password name=password/> input type=submit value=submit/> form> br />hr />br /> h1>deleteh1> form action=delete.php method=post> username:input type=name name=username /> br /> are you sure?input type=submit value=sure /> form> br />hr />br /> h1>updateh1> form action=update.php method=post> username:input type=name name=username/> br /> you want to change your password into:input type=password name=password/> input type=submit value=submit/> form> br />hr />br /> body>html>以上三个功能的提交源operate.html
http://www.bkjia.com/phpjc/1030847.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/1030847.htmltecharticle用php向数据库中实现简单的增删改查(纯代码,待完善),php增删 ? php $con = mysql_connect (localhost:3306,root, ); if (! $con ) { die ('could not con...