PHP Connection database for simple query

Roar, just learn, record a bit ~

1. Start a new database, create a new data table test, and arbitrarily insert two records

2. Create a new PHP file.

Code to connect to the database:

$conn =mysql_connect ("localhost", "root", "");//Connect the database server if (! $conn) {die  (' Could not connect: '. Mysql_error ());} mysql_select_db ("MyTest", $conn);//Select Database Mytetstmysql_query ("Set names UTF8");//Set encoding format

Mysql_connect (Servername,username,password);

ServerName	Optional. Specifies the server to connect to. The default is "localhost:3306".
Username	Optional. Specifies the user name to use for the login. The default value is the name of the user who owns the server process.
Password	Optional. Specifies the password used to log in. The default is "".

3. Execute a database statement, such as a query statement

$arr =mysql_query ("SELECT * from Test", $conn);

Output query Results

       while ($row = Mysql_fetch_array ($arr)) {echo $row [' ID ']. " " . $row [' num '];echo '
";}

————————————————————————————————————————

Implementation results:

When you click Find All, the display:

When searching by ID, enter 1 to display:

Full code:

 
  "; echo" Idnumnamesexbithday ", if (isset ($_post[' Select_all ')) {$arr =mysql_query (" SELECT * from Test ", $conn); while ($ row = Mysql_fetch_array ($arr)) {echo "{$row [' id ']} {$row [' num ']} {$row [' name ']} {$row [' sex '}} {$row [' Birthday ']}";// echo $row [' ID ']. " " . $row [' num '];//echo '

• Size: 3.3 KB

• Size: 8.5 KB

• Size: 7.2 KB

• View Picture Attachments

The above introduces the PHP connection database to implement a simple query, including the aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

