Website Purpose
Tourism Victoria would like you to create a dynamic website providing information about places to visit and things to do in in Melbourne or regional Victoria.
The target audience includes international tourists, inter-state visitors and Victorian residents.
Website Architecture
The tourism website is to be hosted on the RMIT Jupiter server.
This server has a Linux operating system; and Tourism Victoria need you to set the correct permissions on the directories to ensure files are secure and all functions work correctly
For the Assessment part 2 and 3 the records for the website will need to be stored in an SQL database. The database is to be hosted on the RMIT Jacob5 SQL server.
Data storage
Tourism Victoria would like the website to have at least 6 examples of things tourists can do in Victoria. The content should include both text and images
You will need to create at least one database table to store this information
They would like you to use the following database table structure
- id (primary key, auto-increment, integer 10)
- name (varchar 250)
- location (varchar 250)
- theme (var char 250)
- description (text)
- image (varchar 250)
All website images need to be stored in an images folder
The maximum size of all images is to be 500px
Where thumbnails are required – CSS must be used to re-size the images
Image names must be lowercase, and use one word to clearly describe the image
Website Functions
The completed website will need to provide a range of functions – search for records; display records; insert new records; update records; and delete records
These functions are to be created using PHP (object-oriented) and an SQL database. The website is to be built in 3 stages.
Stage 2 – insert a new record
In stage 2 Tourism Victoria would like a website that allows users to connect to a database and add new records. You will need to build an HTML form to collect user input, use SQL queries to insert form data into the database, and move selected images to the images folder.
Security is a concern – especially SQL injection and the insertion of invalid data. Only valid and “safe” data should be added to the database.
You will need to do the following
- Build an HTML form which matches the database table structure
- Connect to the database and log any errors to a file
- Validate and cleanse all form input
- Run SQL queries and log any errors to a file
- Provide users with messages about the success or failure of the insert process
Navigation
The navigation should contain options for all functions which will be in the finished website:
Home Insert Modify Contact Us
It should be placed at the top of the page and styled with CSS.
Design and accessibility
Tourism Victoria wants the website to have a main heading which reflects your chosen tourism theme.
They also need the website to be accessible to all users. All website pages must use semantically correct HTML for structure and link to an external CSS file. All functions must be easy to use, and all pages must have a consistent appearance.
Get expert help for Web Development Project Technical Requirements and many more. 24X7 help, plag free solution. Order online now!
