IT. Expert System.

PHP

Returns the number of columns for the most recent query


mysqli::$field_count

mysqli_field_count

(PHP 5)

mysqli::$field_count -- mysqli_field_countReturns the number of columns for the most recent query

Description

Object oriented style

Procedural style

int 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 #1 $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

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

mysqli_query($link"DROP TABLE IF EXISTS friends");
mysqli_query($link"CREATE TABLE friends (id int, name varchar(20))");

mysqli_query($link"INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");

mysqli_real_query($link"SELECT * FROM friends");

if (
mysqli_field_count($link)) {
    
/* this was a select/show or describe query */
    
$result mysqli_store_result($link);

    
/* process resultset */
    
$row mysqli_fetch_row($result);

    
/* free resultset */
    
mysqli_free_result($result);
}

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


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: 1196 / . Delta: 0.04303 с