how to let php code out excel file ?
502742Oct 24 2006 — edited Dec 31 2006for example below shows:
<?php
$conn = oci_connect("apps","apps","prod") or die("Connect failure");
$sql = "select h.order_number,to_char(h.ordered_date,'YYYY-MM-DD HH24:MI')
from oe_order_headers_all h
where h.org_id = 82
and to_char(h.ordered_date,'YYYYMMDD') = '20061025'";
$result = oci_parse($conn,$sql);
oci_execute($result);
?>
<table border=1>
<tr>
<td>ordernum</td>
<td>orderdate</td>
</tr>
<?php
while ($rows = oci_fetch_array($result,OCI_BOTH)) {
echo "<tr>";
echo "<td>$rows[0]</td>";
echo "<td>$rows[1]</td>";
}
?>
</table>
</html>
how to make above example outputs in excel form?
who can help me?
thanks!