MYSQLI_BOTH 默认情况分析

# MYSQLI_BOTH 默认情况

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_array(); # 或者 mysqli_fetch_array($res)

var_dump($data);

# 输出结果

array (size=2)

0 => string 'family' (length=6)

'Tables_in_test' => string 'family' (length=6)

# MYSQLI_ASSOC 获取关联数组

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_array(MYSQLI_ASSOC); # 或者 mysqli_fetch_array($res, MYSQLI_ASSOC)

var_dump($data);

# 输出结果

array (size=1)

'Tables_in_test' => string 'family' (length=6)

# MYSQLI_NUM 获取关联数组

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_array(MYSQLI_NUM); # 或者 mysqli_fetch_array($res, MYSQLI_NUM)

var_dump($data);

# 输出结果

array (size=1)

0 => string 'family' (length=6)

mysqli_fetch_assoc()

该函数与mysqli_fetch_array第二个参数传递MYSQLI_ASSOC的结果是一样的

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_assoc(); # 或者 mysqli_fetch_assoc($res)

# 输出结果

array (size=1)

'Tables_in_test' => string 'family' (length=6)

mysqli_fetch_all

同mysqli_fetch_array一样，只不过他的默认获取是数字索引数组

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_all(); # 或者 mysqli_fetch_all($res)

# 输出结果

array (size=2)

0 =>

array (size=1)

0 => string 'family' (length=6)

1 =>

array (size=1)

0 => string 'person' (length=6)

mysqli_fetch_row

获取一条数据

$sql = "SHOW TABLES";

$res = $connect->query($sql);

$data = $res->fetch_row(); # 或者 mysqli_fetch_row($res)

# 输出结果

array (size=1)

0 => string 'family' (length=6)

关闭连接

mysqli_close($connect);

// 或者

$connect->close();