mysqli fetch fields - 语法
mysqli_fetch_fields(result);
它用于返回对象数组。
| Sr.No | 参数 & Description |
|---|---|
| 1 |
result 它指定mysqli_query()、mysqli_store_result()或mysqli_use_result()返回的输出集标识符 |
mysqli fetch fields - 返回值
它返回一个对象数组，其中包含输出集中的列，如果失败，则返回FALSE
mysqli fetch fields - 示例
<?php
$connection_mysql=mysqli_connect("localhost","user","passwprd","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT name FROM emp";
if (connection_mysql,sql</span><span class="pun">)){</span><span class="pln">
fieldinfo=mysqli_fetch_fields($result);
</span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">$fieldinfo </span><span class="kwd">as</span><span class="pln"> $val</span><span class="pun">){</span><span class="pln">
printf</span><span class="pun">(</span><span class="str">"Name: %s\n"</span><span class="pun">,</span><span class="pln">$val</span><span class="pun">-></span><span class="pln">name</span><span class="pun">);</span><span class="pln">
printf</span><span class="pun">(</span><span class="str">"Table: %s\n"</span><span class="pun">,</span><span class="pln">$val</span><span class="pun">-></span><span class="pln">table</span><span class="pun">);</span><span class="pln">
printf</span><span class="pun">(</span><span class="str">"max. Len: %d\n"</span><span class="pun">,</span><span class="pln">$val</span><span class="pun">-></span><span class="pln">max_length</span><span class="pun">);</span><span class="pln">
</span><span class="pun">}</span><span class="pln">
mysqli_free_result</span><span class="pun">(</span><span class="pln">$result</span><span class="pun">);</span><span class="pln">
}
mysqli_close($connection_mysql);
?>
