Php + mysql implements simple addition, deletion, modification, and query functions. mysql addition, deletion, and PHP Tutorial

Php + mysql implements simple addition, deletion, modification, and query functions, and mysql adds and deletes data. Php + mysql implements simple addition, deletion, modification, and query functions. mysql adds and deletes the list code php $ conmysql_connect (localhost: 3306, root,); if (! $ Con) {die (Couldnotconnect:. mysql_error (); php + mysql implements simple addition, deletion, modification, and query functions, and mysql adds and deletes

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 "
 
 "; while($row = mysql_fetch_array($result)) { echo " 
   
     "; echo " 
    "; echo " 
    "; echo " 
   "; } echo " 
  
  
  
  
 
   
 
    
Username
 
    
Password
 
   
" . $row['username'] . "
" . $row['password'] . "
 
 
";  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

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

      Use PHP to add, delete, modify, and query data in the database        
Insert:

 
Delete

 
Update

 
  

The above is all the content of this article. I hope you will like it.

Pipeline list code php $ con = mysql_connect ("localhost: 3306", "root", ""); if (! $ Con) {die ('could not connect: '. mysql_error ());...