User's Manual

Using Oracle LOBs to Store and Load Employee Images
7-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft
14.
Edit anyco.php. In insert_new_emp(), add a call between the
db_execute_statement() and construct_employees() calls to insert the
thumbnail picture:
$r = db_execute_statement($conn, $statement, $err, $bindargs);
if ($r) {
$r = db_insert_thumbnail($conn, $bindargs['NEWEID'],
$_FILES['empphoto']['tmp_name'], $e);
construct_employees();
}
15. In a browser, enter the following application URL:
http://localhost/~<username>/chap7/anyco.php
16. In the Departments page, click Show Employees to navigate to the Employees
page:
17. In the Employees page, to insert a new employee click Insert new employee:
18. The Insert New Employee form allows you to choose a thumbnail image on your
system to be uploaded to the database. Enter your own values in the fields or use
the values as shown. Click Browse: