The examples are specific to our database class. If you want to connect to another database, change 'cs482' to the correct service name. You can try out the code by click on 'click here'. To get the source code, download the file and save it to the file name as indicated by the link.
| Program | Purpose | See it works | Download | Assumption |
| Processing Rows | Login to Oracle and Display a pre-selected table | click here | password.php and the accompany action.php | A table named Students with four attributes ID, NAME, ADDRESS, STATUS exists |
| Rows and Columns | Login to Oracle and Display a selected table | click here | password1.php and the accompany action1.php | The table name should be correct |
| Query | Login to Oracle and Display the Result of a Query | click here | password2.php and the accompany action2.php | The query is correct |
| Insert (Ugly program) | Login to Oracle and Insert a tuple into a table | click here | password3.php and the accompany action3.php | Table Students with four attributes ID, NAME, ADDRESS, STATUS exists |
| Insert (Using PHP function) | Login to Oracle and Insert a tuple into a table | click here | password4.php and the accompany action4.php | Table Students with four attributes ID, NAME, ADDRESS, STATUS exists |
Note: The column 'assumption' states that the program assumes that the table indicated in the column exists or the query is correct. If the query is not correct or the tables are not present then you will not see the sentence "If you see data, then it works!" at the end of the page. One should check for error!
You can enter your Oracle's username, Oracle's password, and 'cs482' as the service to see your database.
If you use PHP, you can put the project at your homepage.
A more complicated example is the OracleEditor.php by Tim Strehle which I found on the PHP website.