"; echo "
Oracle PHP Test - The Table Before Inserting \n " ; echo "
" ; echo "
\n"; echo "
\n"; for ($i = 1; $i <= $ncols; $i++) { $column_name = OCIColumnName($parsed, $i); echo "
$column_name
"; } echo "
\n"; for ($i = 0; $i < $nrows; $i++ ) { echo "
\n"; for ($j = 1; $j<= $ncols; $j++) { $column_name = OCIColumnName($parsed, $j); echo "
" . $results[$column_name][$i] . "
"; } echo "
\n"; } echo "
Number of Rows: $nrows
"; $cmdstr1 = "insert into PO values(" . $_POST['oid'] . "," . $_POST['eid'] . ", " . $_POST['sid'] . ")"; $parsed1 = ociparse($db_conn, $cmdstr1); ociexecute($parsed1); $ocerr = ocicommit($db_conn); if (!$ocerr){ $error = ocierror($db_conn); echo "Commit failed - Cannot insert " . $error['message']; } $cmdstr1 = "select * from PO" ; $parsed1 = ociparse($db_conn, $cmdstr1); ociexecute($parsed1); $nrows1 = ocifetchstatement($parsed1, $results1); $ncols1 = OCINumCols($parsed1); echo "
Oracle PHP Test
"; echo "
Oracle PHP Test - The Table After Inserting \n " ; echo "
" ; echo "
\n"; echo "
\n"; for ($i = 1; $i <= $ncols1; $i++) { $column_name = OCIColumnName($parsed1, $i); echo "
$column_name
"; } echo "
\n"; for ($i = 0; $i < $nrows1; $i++ ) { echo "
\n"; for ($j = 1; $j<= $ncols1; $j++) { $column_name = OCIColumnName($parsed1, $j); echo "
" . $results1[$column_name][$i] . "
"; } echo "
\n"; } echo "
Number of Rows: $nrows1
"; echo "
If you see data, then it works!
\n"; ?>