mysqli 设定字符集连接

mysqli::set_charset

mysqli_set_charset

(PHP 5 >= 5.0.5)

mysqli::set_charset -- mysqli_set_charset — Sets the default client character set

Report a bug

 说明

面向对象风格

bool mysqli::set_charset ( string $charset )

过程化风格

bool mysqli_set_charset ( mysqli $link , string $charset )

Sets the default character set to be used when sending data from and to the database server.

Report a bug

 参数

link

仅以过程化样式：由 mysqli_connect() 或 mysqli_init() 返回的链接标识。

charset

The charset to be set as default.

Report a bug

 返回值

成功时返回 TRUE， 或者在失败时返回 FALSE.

Report a bug

 注释

Note:

To use this function on a Windows platform you need MySQL client library version 4.1.11 or above (for MySQL 5.0 you need 5.0.6 or above).

Note:

This is the preferred way to change the charset. Using mysqli::query() to execute SET NAMES .. is not recommended.

Report a bug

 范例

Example #1 mysqli::set_charset() example

面向对象风格

 1 <?php
 2 $mysqli = new mysqli("localhost", "my_user", "my_password", "test");
 3 
 4 /* check connection */
 5 if (mysqli_connect_errno()) {
 6     printf("Connect failed: %s\n", mysqli_connect_error());
 7     exit();
 8 }
 9 
10 /* change character set to utf8 */
11 if (!$mysqli->set_charset("utf8")) {
12     printf("Error loading character set utf8: %s\n", $mysqli->error);
13 } else {
14     printf("Current character set: %s\n", $mysqli->character_set_name());
15 }
16 
17 $mysqli->close();
18 ?>

 

过程化风格

 1 <?php
 2 $link = mysqli_connect('localhost', 'my_user', 'my_password', 'test');
 3 
 4 /* check connection */
 5 if (mysqli_connect_errno()) {
 6     printf("Connect failed: %s\n", mysqli_connect_error());
 7     exit();
 8 }
 9 
10 /* change character set to utf8 */
11 if (!mysqli_set_charset($link, "utf8")) {
12     printf("Error loading character set utf8: %s\n", mysqli_error($link));
13 } else {
14     printf("Current character set: %s\n", mysqli_character_set_name($link));
15 }
16 
17 mysqli_close($link);
18 ?>

 

以上例程会输出：

Current character set: utf8

Report a bug

 参见

 

posted @ 2013-08-28 16:21  竹三戒  阅读(1025)  评论(0)  编辑  收藏  举报