note 7358 deleted from function.ocifetchinto by philip
| From: | philip@php.net | Date: | Wed, 22 Jan 2003 07:20:29 +0000 |
| Subject: | note 7358 deleted from function.ocifetchinto by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-42556@lists.php.net to get a copy of this message | ||
I got a lot of help from this site. Therefore, I would like to contribute
my source with php to PHP Developers.
Here is the source to use OCIFetchinto function:
<?
$page_querry = "select
CAA_NUM,CAA_USER,CAA_SUBJECT,CAA_HIT,CAA_ACPDATE,CAA_RPYDATE,CAA_DEPTNAME from CA_ACCEPT where
CAA_MNO <= $total_count and CAA_MNO >$total_count-10 order by CAA_MNO desc";
$page_stmt = OCIParse($conn,$page_querry);
OCIExecute($page_stmt);
for($i= ;OCIFetchinto$page_stmt,&$row,OCI_ASSOC); $i++){
echo("<tr>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#435A82'>$row[CAA_NUM]</font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'>$row[CAA_USER]</font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'><a href = 'view.php3?code=$row[CAA_NUM]&
hit=$row[CAA_HIT]' target=_blank>$row[CAA_SUBJECT]</a></font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'>$row[CAA_HIT]</font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'>$row[CAA_ACPDATE]</font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'>$row[CAA_RPYDATE]</font></td>
<td align=center valign=top bgcolor='#D3DDEE' ><font
color='#00235c'>$row[CAA_DEPTNAME]</font></td>
</tr>
");
}
?>