<?php header("Content-type:text/html;charset=UTF-8"); //1.建立到Mysql数据的链接 $mysqli=new mysqli('localhost','root',''); print_r($mysqli); //2.打开制定的数据库 $mysqli->select_db('shanshi'); //第二种方式 $mysqli=new mysqli(); $mysqli->connect('localhost','root',''); print_r($mysqli); //简历链接的同时打开制定数据库 $mysqli=new mysqli('localhost','root','','shanshi'); print_r($mysqli); if ($mysqli->connect_error){ die('Connect Error'). $mysqli->connect_error(); } print_r($mysqli); echo '<hr color="red">'; echo '客户端的信息:'.$mysqli->client_info.'<br />'; echo $mysqli->get_client_info().'<br />'; echo '客户端的版本:'.$mysqli->client_version.'<br />'; echo '<hr />'; echo '服务器端信息:'.$mysqli->server_info.'<br />'; echo '<hr />'; echo '服务器版本:'.$mysqli->server_version.'<br />'; echo '<hr />';
以下个人习惯性用法
//1.建立到Mysql的连接 $mysqli=new mysqli('localhost','root','','shanshi'); if ($mysqli->connect_errno){ die('Connect Error:'.$mysqli->connect_error); } //2.设置默认的客户端编码方式utf8 $mysqli->set_charset('utf8'); //3.执行sql查询 //新建一张表 $sql = <<<EOF CREATE TABLE IF NOT EXISTS mysqli( id TINYINT UNSIGNED AUTO_INCREMENT KEY, username VARCHAR(20) NOT NULL ); EOF; //执行一条sql语句 返回bool $res = $mysqli->query($sql); var_dump($res); /** * SELECT/DESC/DESCRIBE/SHOW/EXPLAIN执行成功返回mysqli_result对象 * 对于其他SQL语句的执行,执行成功返回true,否则返回false */ //关闭连接 $mysqli->close();