1. HELP Institute Website Automation of Updates Delphine Boulanger Kok Pooi Kit Willie Tan

2. Automation of Website Updates Content • Current Website • Objective • Step 1: Design of Website Database • Step 2: Build of PHP Website • Step 3: Filling Database • Conclusion

3. Automation of Website Updates Current Website Composed of - 1 principal Website - 7 other Websites (one for each HELP department) Built essentially in HTML

4. Automation of Website Updates Current Website Needs a lot of frequently updates for - current students - news Now, updates are manual Risks of being not accurately updated

5. Automation of Website Updates Objective Automate Website Updates by 30 June 2003 New architecture:

6. Automation of Website Updates Step 1: Design of Database Simple draw at the beginning: WWW_DEP[dep,name] WWW_CURRENT[dep ,title,date-cur,type,type-doc, adr_content] WWW_NEWS[dep ,title,date-news,sum,content] WWW_CONTACT[dep,name,post,did,tel,ext,fax, e-mail,location,home]

7. Automation of Website Updates Step 1: Design of Database Integrity Constraints: Department ‘dep’ foreign key in all table (unique relation) Type of Document CHECK value into a predefine list

8. Automation of Website Updates Step 1: Design of Database Triggers: Erase Old versions no need to keep old version of a same document ‘Page Last Updated’ One page refers to several tables  need more recent date among these tables

9. Automation of Website Updates Step 2: PHP Website PHP: Scripting language execute on the server side. Especially suited for Web development, it can be embedded into HTML: <html> <head></head> <body> <?php echo "Hi, I'm a PHP script!"; ?> </body> </html>

10. Automation of Website Updates Step 2: PHP Website • PHP allows to: • Connect a database with specifics functions, $conn = OCILogon(“myName”, “myPassword”) • Execute some SQL language queries, $query=“SELECT * FROM table ” ; $stmt = OCIParse($conn, $query); $exec_result = OCIExecute($stmt);

11. Automation of Website Updates Step 2: PHP Website • Store results into an array, $nrows = OCIFetchStatment($stmt, $results); $nrows  number of rows selected $results  array contend all results • and Show the result in HTML format

12. Automation of Website Updates Step 2: PHP Website Build a PHP Website  mix between • SQL queries extract information of database • ‘Like C’ language programming to process information

13. Automation of Website Updates Step 3: Filling Database • Java application in conception phase. • Easier to respect • order of attributes • integrity constraints • triggers working

14. Automation of Website Updates Conclusion Some difficulties to obtain connections  project could be late. This internship teach more than technical knowledge: ways and customs of Malaysia

15. Automation of Website Updates Readings Documentation Thies C. Arntzen Using PHP with Oracle9, November 2001. Thies C. Arntzen Making efficient use of Oracle8i through Apache and PHP 4, 2000. Websites http://www.php.net/manual/ http://www-db.stanford.edu/~ullman/fcdb/ oracle.html http://oradb1.jinr.ru/oracle/srvr/server/ doc/SCN73/toc.htm