Php+mysql implementation of simple additions and deletions to the function, MySQL additions and deletions _php tutorial

Php+mysql implementation of simple additions and deletions to check the function, MySQL additions and deletions

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

      Using PHP to implement simple additions and deletions to the database        
    
Insert:
        

 
  
    
Delete
        

 
  
    
Update
        

 
  
  

The above mentioned is the whole content of this article, I hope you can like.

http://www.bkjia.com/PHPjc/1031491.html www.bkjia.com true http://www.bkjia.com/PHPjc/1031491.html techarticle Php+mysql implementation of simple additions and deletions to check the function, MySQL additions and deletions list code php $con = mysql_connect ("localhost:3306", "Root", ""); if (! $con) {die (' Could not C Onnect: '. Mysql_error ()); ....

