mysql 处理结果集_使用mysqli操作数据库和处理结果集

include "Page.class.php";

$mysqli=@new MySQLi("localhost","root","123456","xiaoqiang");

if(mysqli_connect_errno()){

echo "连接数据库失败:".mysqli_connect_error();

$mysqli=null;

exit;

}

//$mysqli->select_db("dbname"); //切换数据库

/********************执行非select语句,执行成功返回true,失败返回false*********************/

$sql="insert into shops(name,price,num,desn) values('hello','34.56','22','good')";

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

if(!$result){

echo "sql语句有误!";

echo "ERROR:".$mysqli->errno."|".$mysqli->error;

exit;

}

if($mysqli->affected_rows > 0){

echo "有行数被影响
";

}

echo "最后自动增长的ID".$mysqli->insert_id;

/********************执行select语句,执行成功返回结果集(对象),失败返回false*********************/

$result=$mysqli->query("select * from shops");

$page=new Page($result->num_rows);

$sql="select id cid,name shopname from shops {$page->limit}";

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

$rows=$result->num_rows;

$cols=$result->field_count;

echo "表中{$rows}行,{$cols}列
";

//记录信息

//$result->fetch_row() ---- mysql_fetch_row() 索引数组

//$result->fetch_assoc() ---- mysql_fetch_assoc() 关联数组(下标是列名)

//没执行一次取出一条记录(可以使用data_seek(5)移动),然后指针指向下一行,当结果集没有记录是返回false!

echo '

echo '

';

while($field=$result->fetch_field()){

echo '

'.$field->name.'';

}

echo '

';

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

echo '

';

foreach($row as $col){

echo '

'.$col.'';

}

echo '

';

}

echo '

'.$page->fpage().'';

echo '

';

$result->free();

$mysqli->close();

?>