Hello here is the instructions. the site will be a e-commerce store. Thank you

For the front end user interface, you shall use JavaScript, cascade style sheet, and HTML, and other tools or components if there is any, for example JQuery, Bootstrap. For the middle tier, you will use PHP. For the back end data processes, use MySQL database as the server. For web server, use Apache. Your project shall be able to be deployed to XAMPP 1.8.3 (although the newer version is not 1.8.3 but 1.8.3 uses MySql database rather MariaDB) and can run without any compatible problem. Go to internet to download XAMPP 1.8.3. XAMPP can be used on both Mac and Windows. It contains Apache web server, and MySql Database server. Make sure it is portable and make sure all the links you use are relative links and not link to cloud or your computer folder. It may be connected to some sites though. For example, if you are using some sites images.

The project requires team-work of at most two people, and work independently is allowed. No more than two people can be in a team. A final written report is required.

This report shall contain (follow the order)

1. A title page. Title page must contain the name of the project and name of the team, and the team members of the team.

2. Contribution sheet: it is a page that describes the contribution of each team members (what has been done by whom) on this project. If it is a solo, then you don’t have to include this page. If work as a team, then you MUST include this page.

3. A project summary page that includes project mission statement (the purpose of the project) Step 1 check point

4. The table of content.

5. The UX wireframes. Your original sketch design. Copy and paste your Step 2 check point stuff.

6. User manual. How to use your web site.

7. All the programs source files

8. Database schema and a script file (.sql file) of your database so your instructor can construct your database tables. Don’t forget to create a user who can access your database in this script file.

9. Thorough test run of your web site. Copy and paste all your test run screen shots, as detail as possible, to this report.

Remember to comment your program files as detail as possible. As for database portion, describe the tables used and the purpose of each field on each table. Submit a hard copy is optional. A soft copy of course is required. Put your web site under a folder of your teamName or yourNname. For example, if your name is John Smith then put all your program files and subfolders into JohnSmithProject folder. Name the default web page of your site index.html.

You shall present your web site to the class for about 5 to 8 minutes. Use both power point slides and web site demonstration in your presentation. In your power point slides lists the technologies used (css, html, php, JavaScript, MySql database, etc). in your power point slides include the web site architecture which describe how pages are related and interact with one another. Also list your web site features. You need to sign up a time slot for your presentation.

Note, for copy right concern, you should develop your own web site. Do not copy web site from the internet. Do not use web site that was designed by you at your work (for it is copy-righted also). Failure to observe the copy-right issue may fail your grade. Please direct any comment to your instructor. Your instructor and your classmates may ask you questions, so make sure that you know what you are doing.

NOTE Most of the web site contains web pages for users as well as web pages for administrator. In order to receive excellent grade, you must implement both the web site for user and also for management (CMS).

NOTE do not use absolute URL path when forwarding unless connect to web pages of other web sites.

Grading Criteria

 Submit all required documents and program files according to the specification

 Quality of documents and program files

 Components of your project shall include skills you learned from this class: HTML5, CSS, Javascript, MySql database, PHP scripts.

 Overall appearance of your web site.

 Successful of developing of the web site (working web site; partial credit will be given to partially worked web site)

 Class presentation

 Complexity of your web site: business logic, number of pages, features of the web site, etc..

Requirements

Use PHP as server side script language

Use MySql as backend database

Use HTML, CSS, and Javascript

Documents of your project

Comment on your code

Submission

Step1:

What to submit: A document includes the name of your web site, team name, team member name(s), and name of team leader. Brief describe how your team meets (one-people team don’t have to describe).

Where to submit: Canvas

When to submit: 3/31/2018

Step2:

What to submit

1. The draft layout of your web sites (site map).

2. How many front pages, and their relationship. What technologies will be used (JavaScript, CSS, xml, or just pure HTML, etc.)

3. Use wireframes to describe your web pages.

Although you can use any editing tool like Paint, Word to draw your web pages, here are some useful links and software you may download in order to create UX wire frames easily.

a. Difference between UI and wireframe

https://www.quora.com/What-is-the-difference-betwe…

b. free wireframe tools

https://www.mockplus.com/blog/post/free-quick-wire…

https://www.creativebloq.com/wireframes/top-wirefr…

c. Mockflow

https://www.mockflow.com/pricing/

d. Frame box

http://framebox.org/

e. Pencil Project (free wireframe tool)

http://pencil.evolus.vn/Default.html

f. Pencil project youtube demo among many others

Where to submit: Canvas

When to submit: 4/7/2018

Step3

1. How many server side scripts (you can estimate). For each php script state the name, purpose, functionality, and which page(s) it related to. If connects to database? If yes, the details of the connection

2. Database layout: Database tables and their attributes

Where to submit: Canvas

When to submit: 4/14/2018

Step4:

Present your project and submit the power point slides (present on 4/19/2018 or 4/26/2018) A signup sheet will be given.

Submit all Final modified HTML, CSS, Javascript, and the source code of your PHP scripts, database sql file and other related files

Describe how to deploy these components.

The final project report and all the source files

Where to submit: Canvas

When to submit: 5/3/2018 before midnight

Final NOTEs (READ CAREFULLY)

1. Make sure when I deploy your submission to XAMPP, I can run your web site without any problem.

2. Name your web site yourNamePHP, if your name is John Smith then your web site is called johnsmithPHP.

3. Your database shall be called johnsmithdatabase, (once again, replace johnsmith with your name). The main purpose so that it won’t conflict with others

4. For PDO, you shall create a PDO like the following

$dsn = ‘mysql:host=localhost;dbname=johnsmithdatabase’;

$db = new PDO ($dsn, "johnsmith", "johnsmithpass");

Once again, replace johnsmith with your real name

5. You also need to export (dump) your MySql database, johnsmithdatabase, to johnsmith.sql so that I can regenerate your database on instructor’s computer. (once again replace johnsmith with your real name)

6. After you got johnsmith.sql, remember to edit the johnsmith.sql file and include the following (purpose is to create the user who you used to connect to your database in your web site. DON’T use root as user in your PHP database script, you will fail your project if you do so)

— create user to query product database —

GRANT SELECT, INSERT, DELETE, UPDATE

ON johnsmithdatabase.*

TO johnsmith@localhost

IDENTIFIED BY ' johnsmithpass';

Once again, replace johnsmith with yourfirstnamelastname !!!!