PDF(美国高级主任)- 2.4 mb
PDF (A4)- 2.4 mb
MySQL结果集包含元数据。元数据描述在结果集中找到的列。MySQL发送的所有元数据都可以通过mysqli
接口。扩展对接收到的信息不执行任何更改或可以忽略不计。MySQL服务器版本不一致。
元数据是通过mysqli_result
接口。
3.27访问结果集元数据
<?php MYSQLI_REPORT_ERROR (MYSQLI_REPORT_STRICT);$mysqli = new mysqli("example.com", "user", "password", "database");$result = $mysqli->查询(“SELECT 1 AS _one, 'Hello' AS _two FROM DUAL”);var_dump(结果- > fetch_fields ());
上面的例子将输出:
数组(2){[0]= >对象(stdClass) # 3(13){[“name”]= >字符串(4)"_one" ["orgname"]=> string(0)"" ["table"]=> string(0)"" ["orgtable"]=> string(0)"" ["def"]=> string(0)"" ["db"]=> string(0)"" ["catalog"]=> string(3)“def”(“max_length”)= > int(1)[“长度”]= > int(1)[“charsetnr”]= > int(63)[“旗帜”]= > int(32897)(“类型”)= > int(8)(“小数”)= > int(0)}[1] = >对象(stdClass) # 4(13){[“name”]= >字符串(4)"_two" ["orgname"]=> string(0)"" ["table"]=> string(0) "" ["orgtable"]=> string(0) "" ["def"]=> string(0) "" ["db"]=> string(0) "" ["catalog"]=> string(3) "def" ["max_length"]=> int(5) ["length"]=> int(5) ["charsetnr"]=> int(8) ["flags"]=> int(1) ["type"]=> int(253) ["decimals"]=> int(31) } }
准备好的语句
使用准备语句创建的结果集的元数据以相同的方式访问。一个合适的mysqli_result
句柄由mysqli_stmt: result_metadata
.
例3.28准备语句元数据
<?php MYSQLI_REPORT_ERROR (MYSQLI_REPORT_STRICT);$mysqli = new mysqli("example.com", "user", "password", "database");$stmt = $mysqli->准备("SELECT 1 AS _one, 'Hello' AS _two FROM DUAL");支撑- > execute ();$result = $stmt->result_metadata();var_dump(结果- > fetch_fields ());
另请参阅
mysqli:查询 |
mysqli_result: fetch_fields |