PHP write Mysql Data Implementation Code

PHP writes data to the MySQL database in three steps:
1. Establish a connection between PHP and MySQL
2. Open the MySQL database
3. Accept page data. Input PHP Data to the specified table.
Steps 1 and 2 can directly use a database link file: conn. php CopyCode The Code is as follows: <? PHP
Mysql_connect ("localhost", "root", ""); // connect to MySQL
Mysql_select_db ("hello"); // select a database
?>

Of course, the premise is that you have installed the web server, PHP, and MySQL, and created the MySQL table "cnbruce"
The three parameters of mysql_connect () are MySQL address, MySQL user name, and MySQL password.
Then, the data is transmitted through the web page, so that PHP writes data to the table specified by the MySQL database through SQL statements, such as creating a new file post. phpCopy codeThe Code is as follows: <? PHP
Require_once ("conn. php"); // reference the database link file
$ Uname = $ _ Get ['n']; // The get method is passed as a URL parameter.
$ Psw = $ _ Get ['P'];
$ Psw = MD5 ($ psw); // use MD5 encryption directly
$ SQL = "insert into members (username, password) values ('$ uname',' $ psw ')";
Mysql_query ($ SQL); // use SQL statements to insert data
Mysql_close (); // close the MySQL connection
Echo "successfully entered data ";
?>

Test page: http: // localhost/post. php? N = cnbruce & P = i0514
You can insert the new data "cnbruce" to the username field and "i0514" to the password field into the members table of MySQL database hello.