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

    (PHP 4, PHP 5 < 5.2.1)

    Formats all rows of a query into a HTML table

    说明

    ifx_htmltbl_result(resource $result_id[,string $html_table_options]): int

    Formats and prints all rows of the$result_idquery into a HTML table.

    参数

    $result_id

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

    $html_table_options

    This optional argument is a string of <table> tag options.

    返回值

    Returns the number of fetched rows, or FALSE on errors.

    范例

    Example #1 Informix results as HTML table

    <?php
    $rid = ifx_prepare ("select * from emp where name like " . $name,
                         $connid, IFX_SCROLL);
    if (! $rid) {
        /* ... error ... */
    }
    $rowcount = ifx_affected_rows ($rid);
    if ($rowcount > 1000) {
        printf ("Too many rows in result set (%d)\n<br />", $rowcount);
        die ("Please restrict your query<br />\n");
    }
    if (! ifx_do($rid)) {
        /* ... error ... */
    }
    ifx_htmltbl_result ($rid, "border=\"2\"");
    ifx_free_result($rid);
    ?>
    

    上篇:ifx_getsqlca()

    下篇:ifx_nullformat()