$mysql _server_name= ""; Database server name
$mysql _username= ""; Connect to database user name
$mysql _password= ""; Connect Database Password
$mysql _database= ""; The name of the database
$conn = mysql_connect ($mysql _server_name, $mysql _username, $mysql _password);
if (! $conn)
{
echo "<script language=javascript>alert (' Error connecting remote server! '); </script> ";
Exit
}
mysql_select_db ($mysql _database);
mysql_query ("SET NAMES UTF8");
mysql_query ("Set CHARACTER set UTF8");
mysql_query ("SET collation_connection= ' utf8_general_ci '");
$strsql = ' select * from Team_member ';
$result = mysql_query ($strsql, $conn);
while ($row = Mysql_fetch_row ($result)) {
}
================================
mysql_query ("Set names CharSet UTF8") sets the client character set to UTF-8
mysql_query ("Set character set UTF8") sets the connection character set
The former contains: client | result | connection
The latter package affects: connection
PHP Connection Database