<?php
//连接数据库
$linkid=mysqli_init();
$db_charset='utf8';
mysqli_real_connect($linkid, 'localhost', 'root', '', false, 3306);
mysqli_select_db($linkid, 'my_db');
//设置数据库编码
$db_info = mysqli_get_server_info($linkid);
if($db_info > '4.1' && $db_charset)
{
mysqli_query($linkid, 'SET character_set_connection='.$db_charset.',character_set_results='.$db_charset.',character_set_client=binary');
}
if($db_info >= '5.0')
{
mysqli_query($linkid, "SET sql_mode=''");
}
//输出数据
$querystring="SELECT * FROM `my_info` WHERE classid=13 AND checkinfo=true ORDER BY orderid DESC LIMIT 0,5";
$result['a']=mysqli_query($linkid, $querystring);
$re['a']=mysqli_fetch_array($result['a'],MYSQLI_ASSOC);
print_r($re['a']);
//释放资源
mysqli_free_result($result['a']);
转载于:https://my.oschina.net/miaowang/blog/211806