dongqia3502 2016-06-27 08:49 采纳率: 100%
浏览 20
已采纳

将MySQL查询结果存储到PHP数组中[重复]

This question already has an answer here:

Looking at all the questions are using the depreciated mysql_fetch_assoc/array, hence I don't think that this is a duplicate question.

I have a MySQL table with 5 columns,

ID | NAME | AGE | GENDER | HEIGHT

If I want to store the values of NAME, AGE, GENDER in a PHP array,

$query=$mysqli->query("SELECT NAME,AGE,GENDER FROM TableName")
while($result = $query->fetch_assoc()
{
$array = [];
}

Will my array be stored in the format of $array=[[Name,Age,Gender],[Name,Age,Gender]]?

If not, what would be my approach in doing this?

</div>
  • 写回答

2条回答 默认 最新

  • dougupang0901 2016-06-27 08:50
    关注

    It's very simple. You just have to append the result variable in to main array. Like this,

    $array =array();
    while($result = $query->fetch_assoc()
    {
    $array[] = $result;
    }
    

    $result is an array (fetch_assoc it returns result-set in array) so just append that into main array to get the desired result.
    ($array=[[Name,Age,Gender],[Name,Age,Gender]])

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 数据库数据成问号了,前台查询正常,数据库查询是?号
  • ¥15 算法使用了tf-idf,用手肘图确定k值确定不了,第四轮廓系数又太小才有0.006088746097507285,如何解决?(相关搜索:数据处理)
  • ¥15 彩灯控制电路,会的加我QQ1482956179
  • ¥200 相机拍直接转存到电脑上 立拍立穿无线局域网传
  • ¥15 (关键词-电路设计)
  • ¥15 如何解决MIPS计算是否溢出
  • ¥15 vue中我代理了iframe,iframe却走的是路由,没有显示该显示的网站,这个该如何处理
  • ¥15 操作系统相关算法中while();的含义
  • ¥15 CNVcaller安装后无法找到文件
  • ¥15 visual studio2022中文乱码无法解决