ADOdb: Recordset to HTML

This is nice feature. It will help us printing recordset as HTML table by easy way. (next sentences from manual) This is a standalone function (rs2html = recordset to html) that is similar to PHP's odbc_result_all function, it prints a ADORecordSet, $adorecordset as a HTML table. $tableheader_attributes allow you to control the table cellpadding, cellspacing and border attributes. Lastly you can replace the database column names with your own column titles with the array $col_titles. This is designed more as a quick debugging mechanism, not a production table recordset viewer.

You will need to include the file tohtml.inc.php. Example:

<?php 
    include('tohtml.inc.php'); # load code common to ADOdb 
    include('adodb.inc.php'); # load code common to ADOdb 
    $conn = &ADONewConnection('mysql');   # create a connection 
    $conn->PConnect('localhost','userid','','agora');# connect to MySQL, agora db 
    $sql = 'select CustomerName, CustomerID from customers'; 
    $rs   = $conn->Execute($sql); 
    rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID')); 
?>