how to insert multiple rows data into oracle db using php

[boss1]

i m having problem with inserting data into oracle db using php.
i need to how to fetch fetch multiple row's data from a table in html form and insert into oracle db at a time.

may be looping is needed.
but i need some help to fetch all row's data through loop.

so can anybody help me?

[ronverdonk]

Straight from the STANDARD php documentation (my signature still holds): this sample fetches all rows from the table and shows it in a html table[php]<?php
$conn = oci_connect('hr', 'hr', 'orcl');
if (!$conn) {
$e = oci_error();
print htmlentities($e['message']);
exit;
}
$query = 'SELECT * FROM table';
$stid = oci_parse($conn, $query);
if (!$stid) {
$e = oci_error($conn);
print htmlentities($e['message']);
exit;
}
$r = oci_execute($stid, OCI_DEFAULT);
if (!$r) {
$e = oci_error($stid);
echo htmlentities($e['message']);
exit;
}
print '<table border="1">';

// THIS IS THE FETCH LOOP
while ($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) {
print '<tr>';
foreach ($row as $item) {
print '<td>'.($item?htmlentities($item):'&nbsp;').'</td>';
}
print '</tr>';
}
print '</table>';
oci_close($conn);
?> [/php]Ronald