ifx_num_rows
(PHP 4, PHP <=5.2.0)
ifx_num_rows — Count the rows already fetched from a query
Description
int ifx_num_rows
( resource
$result_id
)
Gives the number of rows fetched so far for a query with
result_id after a
ifx_query() or ifx_do()
query.
Parameters
-
result_id -
result_idis a valid resultid returned by ifx_query() or ifx_prepare() (select type queries only!).
Return Values
Returns the number of fetched rows or FALSE on errors.
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Расширения для работы с базами данных отдельных производителей
- Informix
- ifx_affected_rows
- ifx_blobinfile_mode
- ifx_byteasvarchar
- ifx_close
- ifx_connect
- ifx_copy_blob
- ifx_create_blob
- ifx_create_char
- ifx_do
- ifx_error
- ifx_errormsg
- ifx_fetch_row
- ifx_fieldproperties
- ifx_fieldtypes
- ifx_free_blob
- ifx_free_char
- ifx_free_result
- ifx_get_blob
- ifx_get_char
- ifx_getsqlca
- ifx_htmltbl_result
- ifx_nullformat
- ifx_num_fields
- ifx_num_rows
- ifx_pconnect
- ifx_prepare
- ifx_query
- ifx_textasvarchar
- ifx_update_blob
- ifx_update_char
- ifxus_close_slob
- ifxus_create_slob
- ifxus_free_slob
- ifxus_open_slob
- ifxus_read_slob
- ifxus_seek_slob
- ifxus_tell_slob
- ifxus_write_slob
Коментарии
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
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)