• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • ifx_num_rows()

    (PHP 4, PHP 5 < 5.2.1)

    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_idafter a ifx_query() or ifx_do() query.

    参数

    $result_id

    $result_idis a valid resultid returned by ifx_query() or ifx_prepare()(select type queries only!).

    返回值

    Returns the number of fetched rows or FALSE on errors.

    参见

    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)
    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

    上篇:ifx_num_fields()

    下篇:ifx_pconnect()