PHP to the database to achieve simple additions and deletions (pure code, to be perfected)

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

Get all user information (SQL SELECT statement) from the server and appear in a tabular format

 <? php   $con  = mysql_connect  ("localhost", "root    "," ");  if  (!  die  (' Could not connect: ') . mysql_error      ());  mysql_select_db  ("Test",  $con  Span style= "color: #000000;"    >);  mysql_query  ("DELETE from user WHERE username = ' $_post  [username] ' ");  mysql_close  ( $con  );? 

Delete all information for this user 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);?>

register a new user 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);?>

Modify a user password update.php

username: <input type= "name" name= "username"/> <br/>Password: <input type= "password" name= "password"/> <input type= "Submit" value= "Submit"/> </form&gt        ; <br/>username: <input type= "name" name= "username"/> <br/>Is you sure? <input type= "Submit" value= "sure"/> </form> <br/>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&gt        ; <br/>Submission Source operate.html for the above three features
PHP to the database to achieve simple additions and deletions (pure code, to be perfected)