IT. Expert System.

PHP

Get the number of fields in a result


mysqli_result::$field_count

mysqli_num_fields

(PHP 5)

mysqli_result::$field_count -- mysqli_num_fieldsGet the number of fields in a result

Description

Object oriented style

Procedural style

int mysqli_num_fields ( mysqli_result $result )

Returns the number of fields from specified result set.

Parameters

result

Procedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().

Return Values

The number of fields from a result set.

Examples

Example #1 Object oriented style

<?php
$mysqli 
= new mysqli("localhost""my_user""my_password""world");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n"mysqli_connect_error());
    exit();
}

if (
$result $mysqli->query("SELECT * FROM City ORDER BY ID LIMIT 1")) {

    
/* determine number of fields in result set */
    
$field_cnt $result->field_count;

    
printf("Result set has %d fields.\n"$field_cnt);

    
/* close result set */
    
$result->close();
}

/* close connection */
$mysqli->close();
?>

Example #2 Procedural style

<?php
$link 
mysqli_connect("localhost""my_user""my_password""world");

/* check connection */
if (mysqli_connect_errno()) {
    
printf("Connect failed: %s\n"mysqli_connect_error());
    exit();
}

if (
$result mysqli_query($link"SELECT * FROM City ORDER BY ID LIMIT 1")) {

    
/* determine number of fields in result set */
    
$field_cnt mysqli_num_fields($result);

    
printf("Result set has %d fields.\n"$field_cnt);

    
/* close result set */
    
mysqli_free_result($result);
}

/* close connection */
mysqli_close($link);
?>

The above examples will output:

 Result set has 5 fields. 

See Also



Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 1802 / . Delta: 0.01610 с