PHP simple read for MySQL instance

Read MySQL Database

Cases.

Code to copy code as follows
<?php
$link =mysql_connect ("localhost", "root", "previous Administrator password");
if (! $link) echo "Not connected successfully!";
mysql_select_db ("Infosystem", $link); Select Database
$q = "SELECT * from Info"; SQL query Statements
mysql_query ("SET NAMES GB2312");
$rs = mysql_query ($q); Get Data Set
if (! $rs) {die ("Valid result!");}
echo "<table>";
echo "<tr><td> department name </td><td> employee name </TD><TD>PC name </td></tr>";
while ($row = Mysql_fetch_array ($rs)) echo "<tr><td> $row [1]</td><td> $row [2]</td>< td> $row [3]</td></tr> "; Show data
echo "</table>";
Mysql_free_result ($RS); To close a data set
?>

Chinese display garbled problem

When we access the MySQL database by PHP in the original way, even if the default character set of the table is UTF8 and the query is sent through UTF-8 encoding, you will find that the database is still garbled.
In fact Jane (www.111cn.net) Single method is set by phpMyAdmin.
Set the following:

1: Language set to Chinese (zh-utf-8)

2:mysql Character Set: UTF-8 Unicode (UTF8)
3:mysql Connection Proofing: Utf8_general_ci
4: When adding database and data table, organize item selection utf8_general_ci

Through the above settings, in the phpMyAdmin operation and query, the Chinese characters are not garbled.
But you will find that in the PHP program with the previous SQL statement query results or garbled, the problem is on the connection connection layer.

The workaround is to send a query statement after the database is successfully connected:

Code to copy code as follows
1: $this->linkid = mysql_connect ($this->host, $this->user, $this->password);
2:mysql_query (' SET NAMES ' UTF8 ', $this->linkid);
Or:

DEFINE (' LINK ', mysql_connect (Db_host, Db_user, Db_password));
mysql_query ("SET NAMES ' UTF8 '", LINK);

GBK-encoded

Code to copy code as follows
$mysql _mylink = mysql_connect ($mysql _host, $mysql _user, $mysql _pass);
mysql_query ("SET NAMES ' GBK '");

From:http://www.111cn.net/phper/php-database/57069.htm

PHP simple read for MySQL instance