php-mysql

发表于 分类于 阅读次数： 本文字数： 954 阅读时长 ≈ 1 分钟

work with mysql

连接数据库

<?php
//phpinfo();
// 5.0 之前的接口，已废弃
//mysql_connect("192.168.153.139:3306","root","1qaz") or die("dd");
//mysql_select_db("demo") or die("connect db failed.");
//mysql_query("SET NAMES 'utf8mb4'") or die (mysql_error());
//mysql_query("SET CHARACTER SET utf8mb4")or die (mysql_error());
//mysql_query("SET CHARACTER_SET_RESULT = utf8mb4")or die (mysql_error());

// 5.0 之后使用新接口
$mysqli = new mysqli("192.168.153.139:3306", "root", "1qaz", "demo");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* change character set to utf8mb4 */
if (!$mysqli->set_charset("utf8mb4")) {
    printf("Error loading character set utf8mb4: %s\n", $mysqli->error);
} else {
    printf("Current character set: %s\n", $mysqli->character_set_name());
}