<HTML ><HEAD ><TITLE >ovrimos_result_all</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Ovrimos SQL functions" HREF="ref.ovrimos.html"><LINK REL="PREVIOUS" TITLE="ovrimos_prepare" HREF="function.ovrimos-prepare.html"><LINK REL="NEXT" TITLE="ovrimos_result" HREF="function.ovrimos-result.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ovrimos-prepare.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.ovrimos-result.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.ovrimos-result-all" ></A >ovrimos_result_all</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN69882" ></A ><P > (PHP 4 >= 4.0.3)</P >ovrimos_result_all -- Prints the whole result set as an HTML table </DIV ><DIV CLASS="refsect1" ><A NAME="AEN69885" ></A ><H2 >Description</H2 >bool <B CLASS="methodname" >ovrimos_result_all</B > ( int result_id [, string format])<BR ></BR ><P > <B CLASS="function" >ovrimos_result_all()</B > is used to print an HTML table containing the whole result set. </P ><P > <B CLASS="function" >ovrimos_result_all()</B > prints the whole result set as an HTML table. Returns <TT CLASS="constant" ><B >TRUE</B ></TT > or <TT CLASS="constant" ><B >FALSE</B ></TT >. </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN69903" ></A ><P ><B >Example 1. Prepare a statement, execute, and view the result</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" ><?php $conn = ovrimos_connect ("db_host", "8001", "admin", "password"); if ($conn != 0) { echo "Connection ok!"; $res = ovrimos_prepare ($conn, "select table_id, table_name from sys.tables where table_id = 7"); if ($res != 0) { echo "Prepare ok!"; if (ovrimos_execute ($res, array(3))) { echo "Execute ok!\n"; ovrimos_result_all ($res); } else { echo "Execute not ok!"; } ovrimos_free_result ($res); } else { echo "Prepare not ok!\n"; } ovrimos_close($conn); } ?></PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > This will execute an SQL statement and print the result in an HTML table. </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN69907" ></A ><P ><B >Example 2. Ovrimos_result_all with meta-information</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" ><?php $conn = ovrimos_connect ("db_host", "8001", "admin", "password"); if ($conn != 0) { echo "Connection ok!"; $res = ovrimos_exec ($conn, "select table_id, table_name from sys.tables where table_id = 1") if ($res != 0) { echo "Statement ok! cursor=".ovrimos_cursor ($res)."\n"; $colnb = ovrimos_num_fields ($res); echo "Output columns=".$colnb."\n"; for ($i=1; $i <= $colnb; $i++) { $name = ovrimos_field_name ($res, $i); $type = ovrimos_field_type ($res, $i); $len = ovrimos_field_len ($res, $i); echo "Column ".$i." name=".$name." type=".$type." len=".$len."\n"; } ovrimos_result_all ($res); ovrimos_free_result ($res); } ovrimos_close($conn); } ?></PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN69911" ></A ><P ><B >Example 3. ovrimos_result_all example</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="php" ><?php $conn = ovrimos_connect ("db_host", "8001", "admin", "password"); if ($conn != 0) { echo "Connection ok!"; $res = ovrimos_exec ($conn, "update test set i=5"); if ($res != 0) { echo "Statement ok!"; echo ovrimos_num_rows ($res)." rows affected\n"; ovrimos_free_result ($res); } ovrimos_close($conn); } ?></PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.ovrimos-prepare.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ovrimos-result.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ovrimos_prepare</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.ovrimos.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ovrimos_result</TD ></TR ></TABLE ></DIV ></BODY ></HTML >