options类相关项
MYSQLI_OPT_CONNECT_TIMEOUT 连接超时 (supported on Windows with TCP/IP since PHP 5.3.1)
MYSQLI_OPT_LOCAL_INFILE 启用/禁用 加载本地二进制文件
MYSQLI_INIT_COMMAND 连接服务器后,需要执行的命令
MYSQLI_READ_DEFAULT_FILE 从命名选项文件读取选项
MYSQLI_READ_DEFAULT_GROUP 读取指定且的选项文件.
MYSQLI_SERVER_PUBLIC_KEY RSA基于公钥文件与sha-256一起使用的身份验证
方式一:
$mysqli = mysqli_init();
if (!$mysqli) {
die('mysqli_init failed');
}
if (!$mysqli->options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {
die('Setting MYSQLI_INIT_COMMAND failed');
}
if (!$mysqli->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5)) {
die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
}
if (!$mysqli->real_connect('localhost', 'root', '123', 'db_database16')) {
die('Connect Error (' . mysqli_connect_errno() . ') '
. mysqli_connect_error());
}
echo 'Success... ' . $mysqli->host_info . "\n";
$mysqli->close();
?>
方式二:
class foo_mysqli extends mysqli {
public function __construct($host, $user, $pass, $db) {
parent::init();
if (!parent::options(MYSQLI_INIT_COMMAND, 'SET AUTOCOMMIT = 0')) {
die('Setting MYSQLI_INIT_COMMAND failed');
}
if (!parent::options(MYSQLI_OPT_CONNECT_TIMEOUT, 5)) {
die('Setting MYSQLI_OPT_CONNECT_TIMEOUT failed');
}
if (!parent::real_connect($host, $user, $pass, $db)) {
die('Connect Error (' . mysqli_connect_errno() . ') '
. mysqli_connect_error());
}
}
}
$db = new foo_mysqli('localhost', 'my_user', 'my_password', 'my_db');
echo 'Success... ' . $db->host_info . "\n";
$db->close();
?>
$mysqli = new mysqli("localhost","root","123","db_database16");
echo 'Success... ' . "\n";
$sql = "INSERT INTO tb_user (type,username,password,email)
VALUES ('user_admin','oppo888','123456','oppo4545@hotmail.com')";
$mysqli->query($sql);
printf("Count :" . $mysqli->insert_id);
echo "Insert seuccess";
/*$sql = "SELECT * FROM tb_user";
if($result = mysqli_query($link ,$sql, MYSQLI_USE_RESULT)){
while($row = $result->fetch_array()){
echo $row['username'] . " " . $row['type'];
echo "
";
}
/*while ($row = mysqli_fetch_array($result)) {
# code...
echo $row['username'] . " " . $row['type'];
echo "
";
}
mysqli_free_result($result);
}*/
$mysqli->close();
?>