PHP7查询数据转换为数组

将数据转换为带名称

<?php
// 设置返回json格式数据
header('content-type:application/json;charset=utf8');

//连接数据库
$link = mysqli_connect("IP", "username", "password") or die("Unable to connect to the MySQL!");

mysqli_query($link,"SET NAMES 'UTF8'");

mysqli_select_db($link,"datename") or die("Unable to connect to the MySQL!");

// 获取分页参数
$page = 0 ;
$pageSize = 10;


// 查询数据到数组中
$result = mysqli_query($link,"SELECT sku FROM xinpinxinxi limit " . $page . ", ". $pageSize ."");

$results = array();
while ($row = mysqli_fetch_assoc($result)) {
$results[] = $row['sku'];
}

// 将数组转成json格式
echo json_encode($results);

// 关闭连接
mysqli_free_result($link,$result);

mysqli_close($link);
?>

结果示例：

[{"sku":"100877412"},{"sku":"100877412"},{"sku":"100962531"},{"sku":"101120910"},{"sku":"101159511"},{"sku":"101173917"},{"sku":"101159511"},{"sku":"101173917"},{"sku":"101173915"},{"sku":"101173918"}]

将数据转换成不带名称样式

<?php
// 设置返回json格式数据
header('content-type:application/json;charset=utf8');

//连接数据库
$link = mysqli_connect("IP", "username", "password") or die("Unable to connect to the MySQL!");

mysqli_query($link,"SET NAMES 'UTF8'");

mysqli_select_db($link,"datename") or die("Unable to connect to the MySQL!");

// 获取分页参数
$page = 0 ;
$pageSize = 10;


// 查询数据到数组中
$result = mysqli_query($link,"SELECT sku FROM xinpinxinxi limit " . $page . ", ". $pageSize ."");

$results = array();
while ($row = mysqli_fetch_assoc($result)) {
$results[] = $row;
}

// 将数组转成json格式
echo json_encode($results);

// 关闭连接
mysqli_free_result($link,$result);

mysqli_close($link);
?>

结果示例

["100877412","100877412","100962531","101120910","101159511","101173917","101159511","101173917","101173915","101173918"]