无涯教程-PHP - mysqli field seek函数

52 阅读1分钟

mysqli field seek - 语法

mysqli_field_seek(result,fieldNumber);

此函数将列光标设置为给定的列偏移量。

Sr.No 参数 & Description
1

result

它标识输出集

2

fieldNumber

它指定列号

mysqli field seek - 返回值

成功时返回TRUE,失败时返回FALSE

mysqli field seek - 示例

<?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 name FROM emp";

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"> mysqli_field_seek</span><span class="pun">(</span><span class="pln">result,0); fieldinfo</span><spanclass="pun">=</span><spanclass="pln">mysqlifetchfield</span><spanclass="pun">(</span><spanclass="pln">fieldinfo</span><span class="pun">=</span><span class="pln">mysqli_fetch_field</span><span class="pun">(</span><span class="pln">result);

  </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/php-mys…