ifx_num_rows

(PHP 4, PHP 5 < 5.2.1)

ifx_num_rows — Count the rows already fetched from a query

说明

ifx_num_rows ( resource $result_id ) : int

Gives the number of rows fetched so far for a query with result_id after a ifx_query() or ifx_do() query.

参数

result_id: result_id is a valid resultid returned by ifx_query() or ifx_prepare() (select type queries only!).

返回值

Returns the number of fetched rows or FALSE on errors.

参见

ifx_num_fields() - Returns the number of columns in the query

add a note

User Contributed Notes 2 notes

down

evandrosimenes at hotmail dot com ¶

10 years ago


if you use this function following:



<?php

$query = ifx_query("SELECT * FROM systables", $connection);

$rows  = ifx_num_rows($query);

?>



this way it doesn't work...



the correct is:



<?php

$query = ifx_query("SELECT * FROM systables", $connection);

$fetch = ifx_fetch_row($query);

$rows  = ifx_num_rows($query);

?>



this way it work...



the informix doesn't returns anything (only with ifx_num_rows) if you don't open the results of query (with ifx_fetch_row)

down

icespawn11882 at hotmail dot com ¶

14 years ago


This function give always 0 as result so I used ifx_affected_rows to count rows of a query's result...

An example of this function:

$conn_id = ifx_connect("db", "user", "password");
$res_id = ifx_query("select * from systables", $conn_id);
$res = ifx_affected_rows($res_id);
echo $res;

$res contains the number of rows in the result of the query after his execution.

Para Massimiliano

add a note

官方地址：https://www.php.net/manual/en/function.ifx-num-rows.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 PHP 8.1 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet PHP json解析（json_decode）页面工具 php中几种注释规范 mysql面试题 [原创]诡异的php-fpm超时问题纯php实现DES以及TripleDES加密算法两千行PHP学习笔记 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式 html转义/html编码/html解码

略微加速

PHP官方手册 - 互联网笔记

ifx_num_rows

说明

参数

返回值

参见

User Contributed Notes 2 notes