"; 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 Students values(" . $_POST['id'] . ", '" . $_POST['name'] . "', '" . $_POST['address']. "', '" . $_POST['status'] . "')"; $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 students" ; $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"; ?>