PHP mysqli原生查询语句

连接mysqli 查询

//面向对象的方法
<?php
 //连接数据库
 $con = new mysqli('host','username','password','db_name','port');
 
 if(mysqli_connect_errno()){
 echo '数据库连接错误！错误信息是：'.mysqli_connect_error();
 exit;
 }
 
 //准备SQL语句
 $sql = 'select * from table';
 
 //执行SQL语句
 $query = $con->query($sql);
 
 while($row = $query->fetch_array()){
 echo $row['id'],'<br>';
 }
 
 //释放资源
 $query->close();
 
 //关闭连接
 $con->close();
?>

<?php
//连接数据库
$con = mysqli_connect('host','user','password','database','port');

//判断是否连接成功
if(!$con){
 echo "数据库失败！";
}

//准备sql语句
$sql = "select * from table";

//执行sql语句
$query = mysqli_query($con,$sql);

while($row = mysqli_fetch_array($query)){
 echo $row['id'].'<br>';
}

//释放资源
mysqli_free_result($query);

//关闭连接
mysqli_close($con);
?>