列表代码
<?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 |
---|---|
" . $row['username'] . " | "; echo "" . $row['password'] . " | "; echo "
删除
<?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); ?>
添加
<?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); ?>
修改
<?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); ?>
用PHP向数据库中实现简单的增删改查
Insert:
以上所述就是本文的全部内容了,希望大家能够喜欢。