maxdb_field_count

maxdb::field_count

(PECL maxdb >= 1.0)

maxdb_field_count -- maxdb::field_countReturns the number of columns for the most recent query

说明

过程化风格

maxdb_field_count ( resource $link ) : int

面向对象风格

maxdb::field_count ( void ) : int

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 maxdb_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.

返回值

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

范例

Example #1 面向对象风格

<?php
$maxdb 
= new maxdb("localhost""MONA""RED""DEMODB");

maxdb_report (MAXDB_REPORT_OFF);
$maxdb->query("DROP TABLE friends");
maxdb_report (MAXDB_REPORT_ERROR);

$maxdb->query"CREATE TABLE friends (id int, name varchar(20))");

$maxdb->query"INSERT INTO friends VALUES (1,'Hartmut')");
$maxdb->query"INSERT INTO friends VALUES (2, 'Ulf')");

if (
$maxdb->field_count()) {
   
/* this was a select/show or describe query */
   
$result $maxdb->store_result();

   
/* process resultset */
   
$row $result->fetch_row();

   
/* free resultset */
   
$result->close();
}

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

Example #2 过程化风格

<?php
$link 
maxdb_connect("localhost""MONA""RED""DEMODB");

maxdb_report (MAXDB_REPORT_OFF);
maxdb_query($link,"DROP TABLE friends");
maxdb_report (MAXDB_REPORT_ERROR);

maxdb_query($link"CREATE TABLE friends (id int, name varchar(20))");

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

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

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

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

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

The above example produces no output.

相关文章
php eventutil returns the most recent socket error numberphp firebird/interbase 函数 return the number of parameters in a prepared queryphp informix 函数 returns the number of columns in the queryphp imap 函数 this function returns the uid for the given message sequence numberphp maxdb 函数 returns the error code for the most recent function callphp maxdb 函数 returns the lengths of the columns of the current row in the result setphp maxdb 函数 returns the number of columns for the most recent queryphp maxdb 函数 retrieves information about the most recently executed queryphp maxdb 函数 returns the auto generated id used in the last queryphp maxdb 函数 returns rpl query typephp maxdb 函数 returns the total number of rows changed deleted or inserted by the last executed statementphp maxdb 函数 returns the error code for the most recent statement callphp maxdb 函数 returns the number of parameter for the given statementphp maxdb 函数 returns the number of warnings from the last query for the given linkphp mssql 函数 returns the number of records affected by the queryphp sqlite 函数 returns the number of rows that were changed by the most recent sql statementphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp mysqli returns the number of columns for the most recent queryphp mysqlnduhconnection returns the number of columns for the most recent queryphp sqlite3 returns the number of database rows that were changed or inserted or deleted by the most recent sql statement
关注编程学问公众号