无涯教程-PHP - mysqli fetch field direct函数

58 阅读1分钟

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 (result</span><spanclass="pun">=</span><spanclass="pln">mysqliquery</span><spanclass="pun">(</span><spanclass="pln">result</span><span class="pun">=</span><span class="pln">mysqli_query</span><span class="pun">(</span><span class="pln">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">-&gt;</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">-&gt;</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">-&gt;</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); ?>

参考链接

www.learnfk.com/php/mysqli-…