PHP writes data to the MySQL database-specified table via SQL statements

PHP writes data to a MySQL database in three steps:

1,php and MySQL establish a connection relationship

2, open MySQL database

3, accept the page data, PHP input to the specified table

1, 22 steps can directly use a database link file can: conn.php

<?php
mysql_connect ("localhost", "root", "");//Connect MySQL
mysql_select_db ("Hello");//Select Database
?>

Of course, the premise is that the Web server, PHP and MySQL are installed, and the MySQL table "WEBJX" is established.

Three parameters in mysql_connect () are MySQL address, MySQL username and mysql password respectively

Then it is through the Web page to pass data, so that PHP through SQL statements to write data to the MySQL database specified tables, such as new files post.php

<?php
Require_once ("conn.php");//referencing Database link file

$uname = $_get[' n '];//get method is passed to the URL parameter
$PSW = $_get[' P '];
$PSW =md5 ($PSW);//Direct use of MD5 encryption

$sql = "INSERT into the members (Username,password) VALUES (' $uname ', ' $psw ')";
mysql_query ($sql);//Borrow SQL statement to insert data

Mysql_close ()//close MySQL connection
echo "Successful data entry";
?>

You can insert new data "WEBJX" to Username field, "i0514" to Password field in the members table of the MySQL database hello