PHP的mysqli_fetch_all

最新推荐文章于 2023-03-16 20:47:36 发布

思维小刀

最新推荐文章于 2023-03-16 20:47:36 发布

阅读量925

点赞数 1

分类专栏： PHP

本文链接：https://blog.csdn.net/fujian9544/article/details/101650211

版权

PHP 专栏收录该内容

280 篇文章 2 订阅

订阅专栏

MYSQLI_NUM键值为数字：丢失了原来的味道了，key全是数字了，丢失了原味道。

MYSQLI_ASSOC键值为字母：还有原来的味道啊，好！！！！拍手，哈哈哈哈~~

<?php
define("host","localhost");
define("user","root");
define("pwd","root");
define("db","mydb");
define("port",3306);

$conn=new mysqli(host,user,pwd,db,port);
$sql="select * from user";
$res=$conn->query($sql);
$res1=mysqli_fetch_all($res,MYSQLI_NUM);
$res=$conn->query($sql);
$res2=mysqli_fetch_all($res,MYSQLI_ASSOC);

MYSQLI_NUM的

array(2) {
  [0]=&gt;
  array(3) {
    [0]=&gt;
    string(1) "1"
    [1]=&gt;
    string(3) "sun"
    [2]=&gt;
    string(3) "sun"
  }
  [1]=&gt;
  array(3) {
    [0]=&gt;
    string(1) "2"
    [1]=&gt;
    string(2) "li"
    [2]=&gt;
    string(2) "li"
  }
}

MYSQLI_ASSOC的

array(2) {
  [0]=&gt;
  array(3) {
    ["id"]=&gt;
    string(1) "1"
    ["name"]=&gt;
    string(3) "sun"
    ["sex"]=&gt;
    string(3) "sun"
  }
  [1]=&gt;
  array(3) {
    ["id"]=&gt;
    string(1) "2"
    ["name"]=&gt;
    string(2) "li"
    ["sex"]=&gt;
    string(2) "li"
  }
}