Help institute website l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 15

HELP Institute Website PowerPoint PPT Presentation

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Help institute website l.jpg

HELP Institute Website

Automation of Updates

Delphine Boulanger

Kok Pooi Kit

Willie Tan


Content l.jpg

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


Current website l.jpg

Automation of Website Updates

Current Website

Composed of

- 1 principal Website

- 7 other Websites

(one for each HELP department)

Built essentially in HTML


Current website4 l.jpg

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


Objective l.jpg

Automation of Website Updates

Objective

Automate Website Updates by 30 June 2003

New architecture:


Step 1 design of database l.jpg

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]


Step 1 design of database7 l.jpg

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


Step 1 design of database8 l.jpg

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


Step 2 php website l.jpg

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>


Step 2 php website10 l.jpg

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);


Step 2 php website11 l.jpg

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


Step 2 php website12 l.jpg

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


Step 3 filling database l.jpg

Automation of Website Updates

Step 3: Filling Database

  • Java application in conception phase.

  • Easier to respect

    • order of attributes

    • integrity constraints

    • triggers working


Conclusion l.jpg

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


Readings l.jpg

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


  • Login