php 面向对象mysql_PHP数据访问（面向对象方式：mysqli类）

//1.创建连接对象

//$db = new MySQLi("localhost","root","123","mydb");

//2.判断当前连接是否正确

//if(mysqli_connect_error()){

//echo "连接失败！";

//exit;

//}

//3.写一个SQL语句

//$sql = "select * from info";

//4.执行SQL语句,如果成功返回一个结果集对象

//$result = $db->query($sql);

//5.读取查询结果

//if($result){

//从结果集对象里面读取所有数据，返回二维数组

//$arr = $result->fetch_all();

//从结果集中读取数据，每次读一条，返回一维数组(索引关联都有)

//$arr = $result->fetch_array();

//从结果中读取数据，每次读一条，返回一维数组(关联)

//$arr = $result->fetch_assoc();

//从结果中读取数据，每次读一条，返回是一个对象

//$arr = $result->fetch_object();

//从结果中读取数据，每次读一条，返回一维数组(索引)

//$arr = $result->fetch_row();

/*while($arr = $result->fetch_row()){

var_dump($arr);

}*/

//}

/*$db = new MySQLi("localhost","root","123","mydb");

mysqli_connect_error()?die("连接失败！"):"";

$sql = "delete from nation where code='n006'";

if($db->query($sql)){

echo "删除成功！";

}else{

echo "删除失败！";

}*/

?>

例子：

代号名称性别民族生日

$db = new MySQLi("localhost","root","123","mydb");

$sql = "select * from info";

$result = $db->query($sql);

if($result){

$arr = $result->fetch_all();

foreach($arr as $v){

echo "

{$v[0]}{$v[1]}{$v[2]}{$v[3]}{$v[4]}";

}

}?>