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 Socket Windows Oracle VR MongoDB 运营 Python MemCache 商业硬件电子设计 nginx 娱乐摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 [PHP] inet_pton/inet_ntop IP地址转换函数 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 PHPMailer设置utf8 PHPMailer字符集CharSet 如何在Composer中为GitLab实例设置访问令牌 array_multisort() 多字段排序 laravel框架查看sql语句方式 [原创]诡异的php-fpm超时问题 PHP获取指定函数定义在哪个文件中及行号利用php soap实现web service php设置cookie为httponly防止xss攻击 PHP5 扩展SOAP 调用 webservice PHP-FPM进程数的设定 PHP7添加redis扩展利用PHP SOAP实现WEB SERVICE PHPstorm 里面Terminal 不能使用 esc键吗退出编辑模式吗纯php实现DES以及TripleDES加密算法 PHP - mysql_real_escape_string()与mysql_escape_string() 的区别 ADORecordSet对象

略微加速

PHP官方手册 - 互联网笔记

ifx_num_rows

说明

参数

返回值

参见

User Contributed Notes 2 notes