Latest web development tutorials

×

×

×

×

PHP Tutorial

PHP Tutorial PHP Introduction PHP installation PHP grammar PHP variable PHP echo/print PHP type of data PHP constant PHP The string PHP Operator PHP If...Else PHP Switch PHP Array PHP Array sorting PHP Super global variables PHP While cycle PHP For cycle PHP function PHP Magic variable PHP Namespaces PHP Object - Oriented

PHP Form

PHP Form PHP Form validation PHP Form - Required field PHP Form - Verify the message and URL PHP Full form instance PHP $_GET variable PHP $_POST variable

PHP Advanced Tutorial

PHP Multidimensional arrays PHP date PHP contain PHP file PHP File Upload PHP Cookie PHP Session PHP E-mail PHP Safety E-mail PHP Error PHP Exception PHP filter PHP Advanced Filter PHP JSON

PHP 7 New features

PHP 7 New features

PHP database

PHP MySQL Introduction PHP MySQL connection PHP MySQL Create a database PHP MySQL Create a data table PHP MySQL Insert data PHP MySQL Insert multiple pieces of data PHP MySQL Prepared statements PHP MySQL Read data PHP MySQL WHERE PHP MySQL ORDER BY PHP MySQL UPDATE PHP MySQL DELETE PHP ODBC

PHP XML

XML Expat Parser XML DOM XML SimpleXML

PHP & AJAX

AJAX Introduction AJAX PHP AJAX database AJAX XML AJAX Real-time search AJAX RSS Reader AJAX vote

PHP Reference Manual

PHP Array PHP Calendar PHP cURL PHP Date PHP Directory PHP Error PHP Filesystem PHP Filter PHP FTP PHP HTTP PHP Libxml PHP Mail PHP Math PHP Misc PHP MySQLi PHP PDO PHP SimpleXML PHP String PHP XML PHP Zip PHP Timezones PHP Image Processing PHP RESTful

PHP mysqli_field_count () function

Previous: PHP mysqli_fetch_row () function

Next: PHP mysqli_field_seek () function

PHP MySQLi Reference Manual

Suppose we have a "websites" table with five fields 20 rows. Returns the number of columns in recent query:

<?php 
// 假定数据库用户名：root，密码：123456，数据库：w3big 
$con=mysqli_connect("localhost","root","123456","w3big"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "连接 MySQL 失败: " . mysqli_connect_error(); 
} 

mysqli_query($con,"SELECT * FROM websites");

// 获取列数
echo mysqli_field_count($con);


mysqli_close($con);
?>

Definition and Usage

mysqli_field_count () function returns the number of columns in a recent query.

grammar

mysqli_field_count( connection ) ;

参数	描述
connection	必需。规定要使用的 MySQL 连接。

technical details

return value:	It returns an integer that represents the number of columns in the result set.
PHP version:	5+

PHP MySQLi Reference Manual

PHP MySQLi Reference Manual

Previous: PHP mysqli_fetch_row () function

Next: PHP mysqli_field_seek () function