php连接数据库的两种方式

　　$mysql_conf = array(

'host' => 'localhost:3306',

'db' => 'ssql',

'db_user' => 'root',

'db_pwd' => '',

);

$mysqli = mysqli_connect($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);

if ($mysqli->connect_errno) {

die("could not connect to the database:

　　" . $mysqli->connect_error);//诊断连接错误

}

$mysqli->query("set names 'utf8';");//编码转化

$select_db = $mysqli->select_db($mysql_conf['db']);

if (!$select_db) {

die("could not connect to the db:

　　" . $mysqli->error);

}

$sql = "select * from users where name = 'lisi';";

$res = $mysqli->query($sql);

if (!$res) {

die("sql error:

　　" . $mysqli->error);

}

while ($row = $res->fetch_assoc()) {

var_dump($row);

}

$res->free();

$mysqli->close();

BC链 http://www.chinabic.com/?id=176 转载需授权！