mysqli::$field_count, mysqli_field_count

• mysqli::$field_count

  mysqli_field_count

  Returns the number of columns for the most recent query

Description

Object oriented styleint mysqli->field_count ;

Procedural styleint mysqli_field_count(mysqli link);

Returns the number of columns for the most recent query on the connection represented by the link parameter. This function can be useful when using the mysqli_store_result function to determine if the query should have produced a non-empty result set or not without knowing the nature of the query.

Parameters

link

Procedural style only: A link identifier returned by mysqli_connect or mysqli_init

Return Values

An integer representing the number of fields in a result set.

Examples

Example 20.113. $mysqli->field_count example

Object oriented style

<?php
$mysqli = new mysqli('localhost', 'my_user', 'my_password', 'test');
$mysqli->query( 'DROP TABLE IF EXISTS friends');
$mysqli->query( 'CREATE TABLE friends (id int, name varchar(20))');
$mysqli->query( 'INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')');
$mysqli->real_query('SELECT * FROM friends');
if ($mysqli->field_count) {
 /* this was a select/show or describe query */
 $result = $mysqli->store_result();
 /* process resultset */
 $row = $result->fetch_row();
 /* free resultset */
 $result->close();
}
/* close connection */
$mysqli->close();
?>

Procedural style

Retornar