辅导 HTML, CSS, PHP, MySQL 编程
辅导R语言程序|讲解Database
：
1. The site has the following areas:
a. Home
b. Catalogue of products
c. Membership (Sign up, login, and logout)
d. Trolley with checkout
e. Admin area to be accessible only to an administrator
1 ：
（，，）
，
2 Different access levels for different user types:
a. Public user: has not signed up or logged in to the website.
b. General Member: requires a log in that is created upon sign up. This is the default level for a newly signed up user.
c. Administrator: logs in as an administrator.
1 ：
2 ：，。。
3 ：。
3. Membership Section contains login/logout and sign up:
If not a member yet, the user needs to sign up first. Once the user is logged in, they
must be kept logged in until they log out.
Following a successful login, more options such as “My Trolley” or “Admin” are
displayed as relevant to their user type. An admin option is not displayed for a
general member, for example.
：
。 ，，。
，。
4. All pages must contain the following sections:
a. Header section: This is to contain a relevant title of each page. For example, if the
page is ‘Catalogue page’, the title of the page is to be ‘Catalogue’.
b. Navigation section: Available links are displayed according to access level.
c. Main content section: This is to contain the relevant information for each page.
d. Footer section: Your name and student number.
1 ==》
2 ，
3
4 YILIN WEN 453481
Check Point in Week 10 Tutorial
You must present your progress to your tutor in your assigned week 10 tutorial (week
commencing Monday 8th May) after completing the following:
??New members can sign up;
??Existing members can sign in and out;
??The header, footer and navigation sections are functioning (do not need to be
completed); and
??The tables in the database have been created.
2017.05.12 ：
，，
database
Further information is as follows:
Home page
access level: all
Home page of the site
：
Catalogue page
access level: all
Information about the products for the site goes here.
*Note : You may have combined home and catalogue. This is acceptable.
：
Membership – Signup
access level: all
Users must join the site if they wish to proceed to purchase
??A Form containing the following input elements and each element should be
validated when the user enters something in each field:
(Every field should have the appropriate label)
o [Required field] Username –To be valid, the user must enter a value that
contains at least one letter and is not an existing username;
o [Required field] Password – To be valid, the user must enter a value that
contains at least 5 characters, which must not include any spaces (all other
characters are acceptable);
o [Required field] Re-type Password– To be valid, the user must enter a value
that is exactly the same entry as the first password entry;
o [Required field] Name – First and Last name;
o [Required field] Date of birth- Users are given 3 drop down lists (year,
month, and day field) to enter this (it must be a valid date – February
should have 28 or 29) – the options in the drop down lists must make it
possible to enter no date:
§ The month field should be shown when the year is selected.
§ The day field should be shown when the month is selected
§ The year range should be: 1900 – 2010
o [Optional field] Email – users can put in an email address, it must be valid;
o [Required field] ‘Gender’ field using radio buttons;
o [Required field] ‘Country’ field using select area (In the Country field,
you should include ‘USA’ and ‘Australia’, maximum 5 countries):
§ When the country is selected, the page should show:
o ‘State’ field using select area
(You do not need to put all states but at least three
states for each country)
§ If the country is not selected, you should not show the `State’
field
§ When the state is selected, the page should show:
o ‘City’ field using select area
(You do not need to put all cites but at least three
cities for each state)
§ If the country or state is not selected, you should not show the
`City` field
o ‘Submit’ button; and
o ‘Reset’ button.
??When the submit button is clicked,
o If all fields are valid,
§ The webpage lets the user know that the form is submitted.
§ The submitted form data needs to be saved into the table
‘customer’. The detailed table ‘customer’ can be found in the
‘Details of Tables Required’ section. (The default access level
should be 2)
o If any field is invalid,
§ The page should show all appropriate error messages (e.g. password
requires longer than 5 characters).
§ The entered data should remain in the field.
：
：
：
1 （）：，
2 （）：，
3 （re-type password）（）：
4 （name）==》 （）
5 （date of birth）（）（，， 22829）：
1）
2）
3） ：1900-2010
6 email （），
7 （gender）（）/（radio buttons）
8 （country） （）（select area），USAAustralia，
，：
（state）
?，
?，：
（city）（select area）
，
9. submit
10. reset
：
1），：
，
myphpadmin‘ customer’。
2），：
（： ）
Membership Sign-In section
access level: member
??The form contains the following input elements and each element should be
validated when the user enters something in each field:
：
：
，：
‘Submit’ button
‘Reset’ button
‘Sign-up’ button
Trolley with Checkout
access level: member
This page must contain the items selected from the catalogue by the user. The list in
the trolley can be selected to proceed to the check out. The user will be brought back
to the home page when check out is completed.
??When the form is submitted (when the submit [Check out] button is clicked)
o Another form with basic information such as delivery address should
now be submitted, showing an error message if there is any empty
field in this form.
o The webpage should let the user know that the form has been
submitted.
o The submitted form data should be saved into the table ‘trolley’ in
database. The detailed table ‘trolley’ can be found in the ‘Details of
Table Required’ section.
：
。。，。
（【check out】）：
，delivery address ， error message
“trolley”。
Admin Area
access level: administrator
Administrators have the highest access level.
An administrator can change the stock information, i.e. number of stocks, price of stocks,
and change the access levels of members.
The administrator’s password must be encoded. (For marking purpose, please provide an
administrator username and password in “readme.txt”.)
：
：
（readme.txt，）
Details of programming style
??All semantic structure of the website should be controlled by “HTML”. You should use
HTML 5. You should pay particular attention to the elements that you use - make sure
that you use the most appropriate element for the kind of text you are marking up;
??All layout and other details of the appearance of the website should be controlled by
valid CSS (Cascading Style Sheets) rules. You should place CSS rules in an external style
sheet (no inline or internal style);
??All behavior of the website (the response to mouse clicking or keyboard reaction) should
be controlled by valid JavaScript (jQuery);
??If you use the jQuery plugins developed by others, you specify which plugins you used in
the readme.txt file. (You will get only half the possible mark for the related section);
??For this assignment, you should use PHP for server-side scripting. Uses built-in PHP
functions where possible;
??You should use the MySQL database on alacritas server. The detailed table structure can
be found from “Details of Table Required” section;
??If you use your computer or your own server to develop the assignment, please test your
work on the alacritas server using a browser available in the lab before your submission;
??All references (URI values) within the site are relative. Do NOT use absolute URL;
??Readme.txt is to contain an administrator’s credentials;
??The only tools to be used for the assignment are HTML, CSS, jQuery, PHP, and MySQL.
NO Bootstrap or other resources.
：
1）HTML，HTML5.
2）CSS CSS
3）（behavior of the website）（）javascript（jquery）
4）jquery，readme.txt
5）php。 php
6）alacritas serverMySQL database
7）reference（URI）（relative），
8）readme.txt（credentials）
9）HTML,CSS,JQUERY,PHPMYSQL Bootstrap。