I need a simple control panel designed with SQL database. We will install database on our server and connect the database to our website. The database consists of data fields populated from a web page form on our website. Visitors completing this form will complete the data fields then click a submit button which will then store the data entered by the end-user into the SQL database. Again, we will connect this web page form to the database.
Database will include the following tables:
* First Name
* Last Name
* Email Address
* Zip Code
* File upload (word document file)
Our web page form includes a 'file upload' feature that enables the site visitor to upload a Word document. The database must be able to save files uploaded via the on-line web page form. Again, we will connect the web page form to the database and handle all back-end hardcoding.
You will be responsible for designing a basic control panel screen used to display the data stores within the database, mock design included on page 2 of attached .zip file (Word document). The control panel screen will include (2) two drop-down menu options and automatically save the data if changed by end-user.
The control panel organizes data stored in the database by US State. When end-user selects a US STATE the system will fetch only those database 'tables' with the US State selected and display the data on the main control panel page (See page 2 for mock design).
There will also be a text box (notes) feature enabling the end-user to input notes and save them. Please see word document for further explanation.
The main objective of this project is to design a SQL database (PHP) with the above tables and control panel web page that pulls data from the tables and displays them on this page. Feel free to ask questions you have regarding this project.
Update regarding the word document files:
The word document files to be uploaded can be stored in a web folder with a link to the database. We envision being able to click link from the CPANEL and open the document using Microsoft Word