无涯教程-PHP - mysqli fetch lengths函数

mysqli fetch lengths - 语法

mysqli_fetch_lengths(result);

它用于返回输出中字段的长度

mysqli fetch lengths - 返回值

如果INTEGER表示每列的大小，则返回数组；如果失败，则返回FALSE

mysqli fetch lengths - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");
if (mysqli_connect_errno($connection_mysql</span><span class="pun">)){</span><span class="pln">
      echo </span><span class="str">"Failed to connect to MySQL: "</span><span class="pln"> </span><span class="pun">.</span><span class="pln"> mysqli_connect_error</span><span class="pun">();</span><span class="pln">
   </span><span class="pun">}</span><span class="pln">$sql="SELECT * FROM emp ";
if ($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">
      row=mysqli_fetch_row($result);
  </span><span class="kwd">foreach</span><span class="pln"> </span><span class="pun">(</span><span class="pln">mysqli_fetch_lengths</span><span class="pun">(</span><span class="pln">$result</span><span class="pun">)</span><span class="pln"> </span><span class="kwd">as</span><span class="pln"> $i</span><span class="pun">=&gt;</span><span class="pln">$val</span><span class="pun">){</span><span class="pln">
     printf</span><span class="pun">(</span><span class="str">"Field %2d has length: %2d\n"</span><span class="pun">,</span><span class="pln">$i</span><span class="pun">+</span><span class="lit">1</span><span class="pun">,</span><span class="pln">$val</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);
?>

参考链接

www.learnfk.com/php/php-mys…