ifx_htmltbl_result

(PHP 4, PHP 5 < 5.2.1)

ifx_htmltbl_result — 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_id query into a HTML table.

参数

result_id

result_id is 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);
?>

相关文章
php cubrid mysql 兼容性函数 perform a query without fetching the results into memoryphp dbx 函数 fetches rows from a query result that had the dbx result unbuffered flag setphp dbx 函数 send a query and fetch all results if any php firebird/interbase 函数 return the number of rows that were affected by the previous queryphp informix 函数 get number of rows affected by a queryphp informix 函数 set the default blob mode for all select queriesphp informix 函数 releases resources for the queryphp informix 函数 get the contents of sqlca.sqlerrd 0..5 after a queryphp informix 函数 formats all rows of a query into a html tablephp informix 函数 returns the number of columns in the queryphp informix 函数 count the rows already fetched from a queryphp informix 函数 send informix queryphp ingres 函数 get the number of rows affected or returned by a queryphp odbc 函数 print result as html tablephp postgresql 函数 fetches all rows in a particular result column as an arrayphp sqlite 函数 fetches all rows from a result set as an array of arraysphp sqlite 函数 execute a query that does not prefetch and buffer all dataphp sqlsrv 函数 returns the number of rows modified by the last insert update or delete query executedphp sybase 函数 gets number of affected rows in last queryphp swoole table count the rows in the table or count all the elements in the table if $mode = 1.
关注编程学问公众号