Create a customer data management web app using HTML5, CSS, JavaScript, PHP, and MySQL database by referring to the attached problem statement.

Submit your files (a zip file)

Include your DB export AND screenshots!

Submission Requirements

1. Use the Validator to check your HTML code. https://validator.w3.org/
2. Add CSS to your submission such that it is well-designed and unique.
3. Your code should be debugged and working as described with no errors.
4. Be sure to comment your code.
5. Upload as ZIP file to D2L/BrightSpace

Outcomes should be unique and reflect your design choices.

 

ITEC 3280 Web Programming – Final ProjectIn this project, you will create a dynamic, data-driven customer data management web appusing HTML5, CSS, JavaScript, PHP, and MySQL database. The applica±on must incorporate bestprac±ces and standards for a Web-based informa±on system.Part I – MySQL Database (20pts)By usingphpMyAdminin the XAMPP, create a MySQL database (named ‘shoppingdb’) with thefollowing tables:1.LoginsTheloginstable contains two Felds:User ID (VARCHAR (50),user_id)Password (VARCHAR (50),password)Then add some Fc±±oususeridandpassword.2.CustomersThecustomerstable contains ten Felds:User ID (VARCHAR (50),user_id)²irst Name (VARCHAR (50),frst_name)Last Name (VARCHAR (50),last_name)Address (VARCHAR (100),address)City (VARCHAR (50),city)State (VARCHAR (50),state)Zip (VARCHAR (10),zip)Email (VARCHAR (100),email)Gender (CHAR (2),gender)Phone (VARCHAR (20),phone)Then add some Fc±±ous data (user_idinloginstable anduser_idincustomerstableshould be the same).Part II – Web Development (HTML and CSS) (20 pts)This web applica±on will consist of four web pages. Each page will need to meet the followingrequirements:1.Research and determine op±mized web page layout dimensions based upon current browserusage sta±s±cs. The layout dimensions should be used on each page.

Attachments:

• 1492962593-Assignment14.docx