1 / 15

HELP Institute Website

HELP Institute Website Automation of Updates Delphine Boulanger Kok Pooi Kit Willie Tan 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

emily
Download Presentation

HELP Institute Website

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related