ifx_num_rows

(PHP 4, PHP <=5.2.0)

ifx_num_rows — クエリから既に取得された行の数を数える

説明

int ifx_num_rows ( resource $result_id )

ifx_query() または ifx_do() クエリの後、result_id を有するクエリに関してこれまで取得された行の数を返します。

パラメータ

result_id: result_id は、 ifx_query() または ifx_prepare() (select 型のクエリのみ!) により返された有効な結果 ID です。

返り値

取得した行の数、あるいはエラー時に FALSE を返します。

参考

ifx_num_fields() - クエリのカラム数を返す

add a note User Contributed Notes ifx_num_rows

evandrosimenes at hotmail dot com 13-Jan-2009 01:10


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)

icespawn11882 at hotmail dot com 21-Apr-2005 12:56


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