PHP Introductory Learning Knowledge Point one PHP and MySQL connection and query _php Foundation

One, the connection database
1, mysql_connect: Open MySQL Link

Mysql_connect (' host ', ' username ', ' password ')

2, mysql_select_db: Open a Database
mysql_select_db (' database name ', $ link identifier)//link identifier not filled out defaults to last open connection

3, mysql_query ("Set names ' GBK '") to solve the Chinese garbled problem;

mysql_query ("Set Names ' encoding (UTF8 or GBK)")//utf8 cannot have "-"

Second, query data

1, mysql_query (SQL statement, connection identifier);

$sql = "SELECT * FROM Test"
$result =mysql_query ($sql)//Connection identification Fummer considered the last open link

Get error message

$result = @mysql_query ($sql) or Die (Mysql_error ())

2, get the results of the query

A, mysql_fetch_row ($result);

$row =mysql_fetch_row ($result);
echo $row [0];

B, Mysql_fetch_array ($result);

$row =mysql_fetch_array ($result);
echo $row [0];
echo $row [' key '];


Description: Mysql_fetch_array and Mysql_fetch_row functions are basically the same, except that it can be indexed by the offset from 0, but also by domain name.
Value returns all the field values for the next row and saves them to an array, with no rows returning false.