php+mysql实现简单的增删改查功能_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 "";
  while($row = mysql_fetch_array($result)) {
    echo "";
    echo "";
    echo "";
    echo "";
  }
  echo "<table border="1">
  <tbody><tr>
  <th>Username</th>
  <th>Password</th>
  </tr><tr><td>" . $row['username'] . "</td><td>" . $row['password'] . "</td></tr></tbody></table>";
  mysql_close($con);
?>

删除

<?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);
?>

  
    <title>用PHP向数据库中实现简单的增删改查</title>
  
  
    <br>
    <h2>Insert:</h2>
    
    <br><hr><br>
    <h2>Delete</h2>
    
    <br><hr><br>
    <h2>Update</h2>
    
    <br><hr><br>
  

以上所述就是本文的全部内容了，希望大家能够喜欢。