php mysqli 的使用

<?php


/**
 * 面向对象的风格
 * 
 */


/*//1.创建mysqli对象
$mysqli = new mysqli("localhost", "root", "root", "php");


//var_dump($mysqli->get_charset());


$mysqli->query("set names gbk");


if($mysqli->connect_errno){
echo "".$mysqli->connect_errno;
}
//操作数据库
$sql ="select * from user ";
 
$res = $mysqli->query($sql);
//var_dump($res);
while($row = $res->fetch_row()){
//printf ("%s (%s)\n", $row[0], $row[1]);
foreach ($row as $key=>$val){
echo "--$val";
}
echo "<br>";
}


//关闭资源
$res->free();
//释放内存
$mysqli->close();
*/










/**
 * 面向过程
 */
echo  "面向过程";
//1.创建mysqli对象
$mysqli = mysqli_connect("localhost", "root", "root", "php");


if (!$mysqli) {
    die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
}


mysqli_set_charset($mysqli,'gbk');


$res = mysqli_query($mysqli,"select * from user") ;


while($row = mysqli_fetch_row($res)){
foreach ($row as $key=>$val){
echo "--$val";
}
}


mysqli_free_result($res);
mysqli_close($mysqli);



?>