mysqli fetch field direct - 语法
mysqli_fetch_field_direct(result,fieldIndex);
它用于将输出集中的下一列作为对象返回。
| Sr.No | 参数 & Description |
|---|---|
| 1 |
result 它指定mysqli_query()、mysqli_store_result()或mysqli_use_result()返回的输出集标识符 |
| 2 |
fieldIndex 它指定字段索引,并且应该介于0和-1之间 |
mysqli fetch field direct - 返回值
它返回一个包含字段定义信息的对象,如果失败,则返回FALSE
mysqli fetch field direct - 示例
<?php
$connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT Lastname FROM Persons";
if (connection_mysql,sql</span><span class="pun">)){</span><span class="pln">
fieldinfo=mysqli_fetch_field_direct($result,1);
</span><span class="kwd">print</span><span class="pln"> $fieldinfo</span><span class="pun">-></span><span class="pln">name</span><span class="pun">;</span><span class="pln">
</span><span class="kwd">print</span><span class="pln"> $fieldinfo</span><span class="pun">-></span><span class="pln">table</span><span class="pun">;</span><span class="pln">
</span><span class="kwd">print</span><span class="pln"> $fieldinfo</span><span class="pun">-></span><span class="pln">max_length</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);
?>