mysqli学习笔记 mysqli连接，multi_query多语句查询，SQL预处理stmt，事务处理

一、数据库连接

<?php
 $conn = new mysqli('localhost','root','abc123','newbbs',3306);
 
 if(mysqli_connect_errno()){
     echo '数据库连接出错，错误信息：'.mysqli_connect_error();
 }
 
 $conn->select_db('test');
 
 $conn->set_charset('utf8');
 
 
 $sql = 'select id,username,password from user';
 
 $result = $conn->query($sql);
 
 //$result->fetch_array()   MYSQLI_NUM MYSQLI_ASSOC MYSQLI_BOTH
 //$result->fetch_object()
 //$result->fetch_assoc()
 //$result->fetch_row()
 //
 if($result && $conn->affected_rows){
     echo '<table width=800 border=1>';
     while($row = $result->fetch_object()){  
         echo '<tr><td>'.$row->id.'</td><td>'.$row->password.'</td><td>'.$row->username.'</td></tr>';
     }
     echo '</table>