Do My Homework / Homework Help Answers / PHP Programming Homework Help / PHP and MySQL homework in XAMPP application

PHP and MySQL homework in XAMPP application

Online tutoring services

Need help with this question or any other PHP Programming assignment help task? Click on the button below to to hire an expert cheap.

Create a MySQL database and tables, Query database using PHP (list, add, search for, delete records in a database),Implement best practices to secure user password, Implement form-based web authentication in the user log in process,Use prepared statements and user-defined sanitizing functions to prevent certain injection attacks,Provide client-side validation using JavaScript and server-side validation with PHP,Implement session management on chosen web pages,Design a dynamic web database application. Answer all the questions in the document below and also make comments to your coding to explain what you are doing in each line.

Get Help With a similar task to - PHP and MySQL homework in XAMPP application

Login to view and/or buy answers.. or post an answer
Additional Instructions:
: Web Database Development ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Homework Report ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1. Declaration of the Integrity Statement 2. Complete the Self-Assessment of Capstone Project Requirement Module Points Checklist Completion of the task Respond to the questions or answer Yes - if your project completes the task, No - if your project doesn’t complete the task, Partial – describe what part doesn’t work. Which development stack do you use for your capstone project? AMPPS, XAMPP, WAMPServer, or other. XAMPP Database design (primary key, indexes) 10 What are the SQL commands that you used to create your project database and create/grant a user for your database? Describe your database, how many tables your database has, and what data are stored in the database. What is the primary key in each table? Any indexes? Has a php file that creates the tables and insert initial data into the application table(s). Listing records 5 List the records in your application table in a table format. Searching for records 10 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. Kendra Villarson Kendra Villarson Adding records 5 Provide text fields or other HTML forms to allow user to add a record into the database. Deleting records 5 Allow user to choose a record to delete or search for a record to delete. User sign-up, password security 15 The form contains fields for username, email, password, and confirm_password. Username is checked against the database users table so duplicated username is not accepted. If new user input meets the requirements, password matches confirm_password, and username has not been used, new user is added to the users table. Password is salted and hashed before stored in the users table. User login, Web authentication 12 A login page has a text field for username and a password field for password. A user successfully logs in if the submitted username and password match the stored record in the users table. If the username or password doesn’t match the record, display an error message and provide a link to go back to the login page. Log out 3 Log out a user. Cookies and sessions 10 Session starts when a user logs in and session ends when a user logs out. Session management is provided to the main menu page and all function modules on the main menu page so that each function module can only work upon successful user login. 3. List your source files and give a short description to each file Data sanitization 10 All user submitted data must be sanitized before being used or stored into the database. Prepared statement and place holders must be used in the “Adding Records” module. JavaScript validation 8 JavaScript validation is provided to ensure all input values meet the criteria. Check whether password matches confirm_password using JavaScript. PHP validation 7 PHP validation is provided to ensure all user input values meet criteria. Check whether password matches confirm_password using PHP. Extra credits: Creative works 10 Describe any special design of your project.
BCS 350: Web Database Development CRN 24518 JLi Spring 2021 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Capstone Project Milestones ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Notes: To help you manage your capstone project, I broke down the capstone project into three milestone stages and defined a list of tasks to be completed. I also listed references that can help you in each task and suggested a deadline for each milestone. I highly suggest you follow this list to work on your project. You are not required to submit any milestone report. But the completion of each milestone helps you stay on the right schedule. If you encounter any issue, please seek help as early as possible. Milestone 1: by 04/10/2021 Milestone 2: by 04/20/2021 Milestone 3: by 04/30/2021 Names Tasks Completion of Tasks Yes - if the task is completed No - if the task is not completed Partial – describe what part is not completed Milestone 1: Create database/table(s) and populate table(s); Create the main menu page and complete four function modules; Sanitize user input. 1 Create your database using a command prompt. Grant a user the full access to this database (you can use jim/mypasswd). 2 Document the commands that creates the database and user. 3 Write a php file setupDB.php to create your database application table(s) and populate application table(s) with initial values (use “CREATE TABLE IF NOT EXISTS …”). If there is one application table in the database, it should have at least 5 fields. Primary key and/or other indexes must be specified. References: example8-14 Create a table from a command prompt example8-8 Add data from a command prompt example10-7 Create a table using PHP example10-10 Add records using PHP 4 Make a main menu web page that has links to List Records, Add Records, Search for Records, and Delete Records. Each link leads to Kendra Villarson Kendra Villarson Kendra Villarson Kendra Villarson Kendra Villarson Fill this out , to keep you on track Kendra Villarson corresponding web pages to list or manipulate the records in your database. 5 Listing records of database table(s). You can decide what information will be listed on the web page. The data must be displayed in a table format. 6 Adding a record into the database. Provide text fields or other HTML forms to allow user to add a record into the database. 7 Searching for records in the database. Use a drop-down menu 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 class example, if a user chooses “author” then the text field allows a user to enter the “author” information to look up. 8 Deleting a record 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. 9 All user input data should be sanitized to prevent injection attacks. Prepared statements with placeholders must be used for “adding records” task to sanitize the user input. References example10-6 Insert record and delete record example10-7 Create a table example10-8 Describe a table and output in a table format example10-9 Drop a table example10-10 Add records example10-11 List records in a table example10-12 Update records example10-13 Delete records example10-19 Prepared statements example10-20 Data sanitization with database connection Chap10 slide 26 Data sanitization without database connection Hints: The files for main menu and 4 function modules should be php files so that session control can be added later. Kendra Villarson Milestone 2: Complete user registration and log in. Implement web authentication and password security. 1 Create a table users to store the registered user’s information including username, email, and password. The username is the primary key. 2 Make a user registration page. The registration form should at least have fields for email, username, password, and confirm password. 3 After a user submits data, check if the username is available. If yes, add the user into the users table; otherwise, display an error message and provide a link back to the registration page so user can choose another username to complete the registration. 4 User input must be sanitized before stored into the users table. 5 The password stored in the users table must be salted and hashed. 6 Implement form-based web authentication for user log in. Make a user login page that has a form to allow user to log in with 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. If the user enters correct username and password, session starts and the user enters the main menu page. 7 Implement session control to the four function modules in the main menu so if the user didn’t log in, the four function modules wouldn’t work. 8 Add a log out link to the main menu page to log out a user. Session is deleted when a user logs out. References example12-3 Register new user to the users table example12-5 Log in a user and start session. example12-6 Retrieve session variables on other pages after user logs in. example12-8 Log out a user Milestone 3: Implementation of client-side validation and server-side validation 1 Implement client-side validation using JavaScript. Use the same criteria as the book example 16-2. Password and Confirm Password must match for the password to be accepted. Kendra Villarson 2 Implement server-side validation with PHP. Use the same criteria for JavaScript validation. References example16-3.php Hints: JavaScript validation goes to registration form file. PHP validation goes to registration process file. Finalize Project: Integrate all modules, test and debug your project. Kendra Villarson
BCS 350: Web Database Development CRN 24518 JLi Spring 2021 ------------------------------------------------------------------------------------------------------------------------------ Capstone Project Instructions ------------------------------------------------------------------------------------------------------------------------------ Objectives: • Create a MySQL database and tables • Query database using PHP (list, add, search for, delete records in a database) • Implement best practices to secure user password • Implement form-based web authentication in the user log in process • Use prepared statements and user-defined sanitizing functions to prevent certain injection attacks • Provide client-side validation using JavaScript and server-side validation with PHP • Implement session management on chosen web pages • Design a dynamic web database application. Tasks: 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 Kendra Villarson Kendra Villarson Kendra Villarson Kendra Villarson 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 confirm_password. • 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 submission is my own original work with your name as comments in each of your source files. Kendra Villarson • Make a short video to present how your project works. The video presents in the following order: 1) Sign up using invalid values (email: alice, username: alice, password: mypass, confirm_password: mypass2). 2) Sign up using valid values (email: alice@abc.com, username: alice123, password: Mypass123, and confirm_password: Mypass123). 3) Show all the contents of the users table. 4) Go to the login page and log in with username alice123 and password Mypass123. The user should be directed to the main menu after login. 5) Demonstrate “Listing records” module. 6) Demonstrate “Adding records” module. Add a new record to the database. 7) Display the contents of your application table. 8) Demonstrate “Search for records” module. Search for the newly added record or other records. 9) Demonstrate “Delete records” module. Delete the newly added record. 10) Display the contents of your application table again. 11) Log out. 12) After log out, go to the main menu page by using its URL. Click on “Listing records” link if it is displayed. 13) Sign up using username alice123 again. 14) Feel free to demonstrate other features of your project. Extra credit: Demonstration of creative features or styles of your application. Hint: A project milestone system has been designed to guide you to complete a sequence of tasks that will lead to the successful completion of the capstone project. Please see the attached project milestones document. Submission: You must submit a zip file that contains the following files by May 6. No late submission will be accepted. Missing any part of the following documents will result in a major deduction of total credits. 1. All your source files 2. Project report 3. Project presentation video Grading Criteria: Your project will be graded based on the completeness and correctness of your work listed in the Self-Assessment of Capstone Project. Kendra Villarson Kendra Villarson Use this to make sure it works Kendra Villarson Kendra Villarson Kendra Villarson

Related Questions

Similar orders to PHP and MySQL homework in XAMPP application
197
Views
0
Answers
PHP QUIZ - Constitution Final
Hide Assignment Information Instructions Please note: It is just a given in our industry that your code has to run! If your code does not run, you will not receive any points. You will be creating a PHP-driven web site that is a practice quiz for people taking the civics portion of the United States Naturalization Test. There are 100 possible questions for this portion of the test; however, in practice applicants are given only 10 questions, chosen randomly. An applicant must answer 6 out of 10 questions correctly to pass the civics portion of the naturalization test. Your task is to use the 100 sample questions provided in the official Civics (History and Government) Questions for the Naturalization Test document. (Dr. Alfaro will provide a PHP code snippet with two arrays, one of questions and one of answers, which you may use.) Your application should display ten questions at random along with a text input box for each answer. The user should be able to input a short answer, and the script will compare the user's answers against the correct answers. Be sure to convert any special characters to HTML! When checking for correct answers, CASE SHOULD NOT MATTER. Also, your...
229
Views
0
Answers
PHP homework
I will give details later....
342
Views
0
Answers
I need to direct a PHP form to the correct directory

For right now I just to figure out how to find the path to the correct PHP database. I imagine it would take like 5 minutes for someone who knew what they were doing.

...
560
Views
0
Answers
I need help with php homework with codeigniter

The project is student brigade evidention with xampp / localhost database ( students firstname , lastname , email etc , doesnt have to be complicated , keep it simple )

requirements are 

-> application has login form ( email and password from database , registration is voluntary ) 

-> application has to be connected to database => working adding ,deleting ,editing ,viewing (this basic stuff)

-> there has to be page accesable with button where are at least 4 graphs from database using InnerJoin 

-> responsive design


First 4 requirements has to be done , doesnt need to be perfect , it just has to work 

you can use any type of boosttrap for design...


->bonus requirements are 

=> ajax search -> to be able to search in database

=> export to pdf 



...