Php+mysql to realize simple adding, deleting and checking function _php skill

List code

<?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 "<table border= ' 1 ' >
  <tr>
  <th>Username</th>
  <th>password</th >
  </tr> ";

  while ($row = Mysql_fetch_array ($result)) {
    echo "<tr>";
    echo "<td>". $row [' username ']. "</td>";
    echo "<td>". $row [' Password ']. "</td>";
    echo "</tr>";
  }
  echo "</table>";

  Mysql_close ($con);

? >

Delete

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

Add to

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

? >

Modify

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

The above is the entire contents of this article, I hope you can enjoy.