drll42469 2017-07-18 09:51
浏览 36
已采纳

PHP访问mysqli_fetch_assoc值

I have been trying to store the results of a MySQL query in a PHP array, however I have been struggling to access the values after they have been stored.

I used this to store the query:

while($row = mysqli_fetch_assoc($result)) {
    array_push($array, $row);
}

Which when showing the array with var_dump gives an output similar to this, just with more values:

array(147) { [0]=> array(1) { ["TABLE_NAME"]=> string(8) "_3085515" } }

I want to be able to access the value with the _NUMBER, but I can't figure out how to do this?

  • 写回答

2条回答 默认 最新

  • duange2971 2017-07-18 09:57
    关注

    1st : Declare the variable as a array

       $array = array();
        while($row = mysqli_fetch_assoc($result)) {
           array_push($array, $row);
        }
    

    2nd : Access the value like this

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

报告相同问题?

悬赏问题

  • ¥50 求解vmware的网络模式问题
  • ¥24 EFS加密后,在同一台电脑解密出错,证书界面找不到对应指纹的证书,未备份证书,求在原电脑解密的方法,可行即采纳
  • ¥15 springboot 3.0 实现Security 6.x版本集成
  • ¥15 PHP-8.1 镜像无法用dockerfile里的CMD命令启动 只能进入容器启动,如何解决?(操作系统-ubuntu)
  • ¥30 请帮我解决一下下面六个代码
  • ¥15 关于资源监视工具的e-care有知道的嘛
  • ¥35 MIMO天线稀疏阵列排布问题
  • ¥60 用visual studio编写程序,利用间接平差求解水准网
  • ¥15 Llama如何调用shell或者Python
  • ¥20 谁能帮我挨个解读这个php语言编的代码什么意思?