PHP to the database to achieve simple additions and deletions (pure code, to be perfect), PHP additions and deletions
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);? > Get all user information from the server (SQL SELECT statement) and appear in a tabular format
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 );?> 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
< HTML > < Head > < title >FORM title> Head> <Body> <BR/> <H1>Insert: H1> <formAction= "insert.php"Method= "POST">Username:<inputtype= "Name"name= "username"/> <BR/>Password:<inputtype= "Password"name= "Password"/> <inputtype= "Submit"value= "Submit"/> form> <BR/><HR/><BR/> <H1>Delete H1> <formAction= "delete.php"Method= "POST">Username:<inputtype= "Name"name= "username" /> <BR/>Is you sure?<inputtype= "Submit"value= "Sure" /> form> <BR/><HR/><BR/> <H1>Update H1> <formAction= "update.php"Method= "POST">Username:<inputtype= "Name"name= "username"/> <BR/>You want to change your password into:<inputtype= "Password"name= "Password"/> <inputtype= "Submit"value= "Submit"/> !-- form ; < BR />< HR />< BR /> !-- Body ; !-- HTML ; above three features submit source operate.html
http://www.bkjia.com/phpjc/1030847.html Span id= "Indexurl" itemprop= "Indexurl" >www.bkjia.com true http://www.bkjia.com/phpjc/1030847.html techarticle