php and mysql

This project is to acquaint you with fundamental and essential functions when building dynamic web pages with
PHP and MySQL. You will make a web application that allows a user, upon successful login, to view, add, search
for, and delete records in a MySQL database. The application can register a new user, logs in a returning user, or
logs out a user. You will practice on web authentication, input validation, data sanitization, session management,
sign-up and sign-in process, connecting to web database, querying database, processing data, and displaying
results on web pages. You will make several web pages showing your knowledge and skills of building a
database-driven website. The completion of this project will greatly help you in your senior project course.
Your project should consist of the following function modules:
• Registration of a new user. A new user should at least provide email, username, password, and
confirm password during the sign-up process. Data validation must be provided (see below for
requirements). If any data is invalid, display an error message. If all data are valid, register the user.
Check if the username is available. Display an error message if the username is not available and provide
a link back to the registration page so user can choose another username to complete the registration.
• Login of an existing user with correct username and password. If the user enters incorrect username or
password, display an error message and provide a link back to the login page so user can reenter the
username and password.
• A main menu is provided to a user upon successful login. The main menu contains links for the
following tasks:
o Listing records of database table(s). You will design your own application database and decide what
information will be listed on the web page. The data must be displayed in a table format.
o Adding records into the database. Provide text fields or other HTML forms to allow user to add a
record into the database.
o Searching for records in the database. Use a drop-down list for user to choose a field to search and a
text field for user to enter the information of that field to search for, for example, in our book example,
if a user chooses “author” in the drop-down list, then the text field allows the user to enter the author
information to look up; if a user chooses “title” in the drop-down list, then the text field allows the
user to enter the title information to look up.
o Deleting records from the database. You have two ways to do this. The first approach is you can
modify book examples to list all records and provide “Delete Record” button for each record. Another
approach is you can allow user to search for a record and delete it if the record exists and the user
confirms to delete it.
o Log out of user.
o Once a task is finished, a link should be provided for the user to return to the main menu.
Your project should also meet the following requirements:
• Your database should have two types of tables, application table(s) and a users table. You are free to
decide your database and application tables (you can’t use the same publications database as the book
example). If your database has one application table, it must have at least 5 fields. Your application table
must have a primary key and/or other index for the fields that will be searched by the users.
• You must have a users table to store the registered user’s information including username, email, and
secured password. The username is the primary key. The password must be salted and hashed.
• Write a php file setupDB.php to create your database tables and populate application table(s) with
initial values.
• The form-based web authentication, not HTTP basic authentication, must be implemented in the user
login process.
• Session management must be provided after successful authentication of a user. A user who has not
successfully logged in should not be granted access to any function module in the main menu (not be able
to list, add, search for, or delete records). Prompt the user to log in in the case that a user accessed the
main menu page without login.
• All user input data must be sanitized to prevent injection attacks. Prepared statements with placeholders
must be used for “adding records” module to sanitize the user input.
• Input data for new user registration must be validated using both JavaScript and PHP with criteria similar
to the book example including the format of email must be valid; no input field is empty; usernames must
be at least 6 characters long; passwords must contain at least 8 characters; and passwords must contain at
least one of lowercase letters, uppercase letters, and numeric digits. The password must match
• The navigation and usability of your project should be reasonable and applicable. Some suggestions: add
a link to the user login on the user registration page and add a link to the user registration on the user
login page so user can switch between sign up and sign in; a main menu page is displayed after user logs
in; add a link back to the main menu after each function module is finished.
• Complete the capstone project report that includes the Self-Assessment of Capstone Project. List your
files and briefly describe the purpose of each file.
(Feel free to include screenshots to show your work, such as, your web pages before or after an action, the
structures of database tables, and data in the tables.)
• Include the integrity statement I certify that this sub

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Quality Custom Writers has assembled a team of highly skilled writers with diverse experience in the online writing circles. Our aim is to become a one stop shop for all your Academic/ online writing. Check out below our amazing service!


Essay Writing Services

At Quality Custom Writers, we prioritize on all aspects that creates a good grade such as impeccable grammar, proper structure, zero-plagiarism, and conformance to guidelines. The principal purpose of essay writing is to present the author's evaluation concerning a singular subject about which they have made. Since Professionalism is the mother of every success, try our team of experienced writers in helping you complete your essays and other assignments.


Admission Papers

You have been trying to join that prestigious institution you long yearned for, but the hurdle of an admission essay has become a stumbling block. We have your back, with our proven team that has gained invaluable experience over time, your chance of joining that institution is now! Just let us work on that essay.How do you write an admission essay? How do you begin the essay? For answers, try Quality Custom Writers Now!


Editing and Proofreading

Regardless of whether you're pleased with your composing abilities, it's never an impractical notion to have a second eye go through your work. The best editing services leaves no mistake untouched. We recognize the stuff needed to polish up a writing; as a component of our editing and proofreading, we'll change and refine your write up to guarantee it's amazing, and blunder free. Our group of expert editors will examine your work, giving an impeccable touch of English while ensuring your punctuation and sentence structures are top-notch.


Technical papers

We pride ourselves in having a team of clinical writers. The stringent and rigorous vetting process ensures that only the best persons for job. We hire qualified PhD and MA writers only. We equally offer our team of writers bonuses and incentives to motivate their working spirit in terms of delivering original, unique, and informative content. They are our resources drawn from diverse fields. Therefore your technical paper is in the right hands. Every paper is assessed and only the writers with the technical know-how in that field get to work on it.


College Essay Writing

If all along you have been looking for a trustworthy college essay service provider that provides superb academic papers at reasonable prices, then be glad that you search has ended with us. We are your best choice! Get high-quality college essay writing from our magnificent team of knowledgeable and dedicated writers right now!


Quality Assignment/Homework Help

We give the students premium quality assignments, without alarming them with plagiarism and referencing issues. We ensure that the assignments stick to the rules given by the tutors. We are specific about the deadlines you give us. We assure you that you will get your papers well in advance, knowing that you will review and return it if there are any changes, which should be incorporated.

× How can I help you?