Php script and my sql
$30-250 CAD
Paid on delivery
Use only MySQL commands.
1. UsePHPtoreusecommonelementsinyourwebsite
PHP provides us with techniques to modularize and reuse our web application code. You need to refactor your web pages so that common static HTML elements such a menu, header and footer are written in common text files which are then included into your web pages. Name the include file(s) with a .inc
2. CreateaQuizAttemptstable
Create a table attempts in your MySQL database. The information in each attempt record should include the following fields with appropriate data types:
Attempt id (auto-generated primary key)
Date and time of the attempt (generated by PHP) First name
Last name
Employee number
The number of the attempt (1 -3)
Score for the attempt
When a user submits a quiz attempt to the website, if an attempts table does not already exist in your database it should be programmatically created by your code.
3. Markingthequizattheserverandaddingvalidatedrecordtotheattempts table
Adapt the quiz form ([login to view URL]) you developed in Parts 1A and 21Bto add quiz attempt records to the table. This form should submit the data to a php script called markquiz.php.
In Part 1B of the assignment you created some JavaScript to mark quizzes in the client browser. This has an obvious security flaw: a user could always spoof their result and send it to the server. Delete or disable the client-side marking script and reproduce this logic in a PHP script on the server. Make sure you do appropriate type-checking of the responses before marking them.
While you will have done client-side validation in Parts 1A & 1B, in order to preserve the integrity of the server data you should also implement server-side data format checking.
In addition to type-checking the quiz responses, check the integrity of the data input by the users. All input data should be sanitized. No required fields should be empty.
4. Quizsupervisorqueries.
Create a web page with a link on the menu that allows a supervisor to make the following queries of the attempts table:
List all attempts.
List all attempts for a particular Employee (given an Employee id OR name).
List all Employees (id, first and last name) who got 100% on their first attempt.
List all Employees (id, first and last name) got less than 50% on their third attempt.
Delete all attempts for a particular employee (given an employee id).
Change the score for a quiz attempt (given an employee id).
Create
to implemented access to the supervisor page and its queries.
a php script called [login to view URL] (and other appropriately named pages if necessary)
Project ID: #21304506
About the project
Awarded to:
I am sure that I can finish your project perfectly with high quality code and short time. Please send me message so that we can discuss more. Thank you
37 freelancers are bidding on average $169 for this job
Hello, Thank you for sharing the information. I truly understand your need . As per your need, I will cover all these points step by step and will give you the daily updates accordingly. I assure you will get quality More
Hello there I understand got it your idea you need Move my current Shopify store to a Wordpress platform and I have more than 5 years of development experience and a great team, we can complete your project with clea More
Thanks for visit me I'm a Professional Web Developer with 12+ years of experience. My goal is to 120% fulfill the expectations of our clients - the extra 20% being the anticipation of problems or adding ideas that our More
Hello. After carefully read in this project details, I'm very interested in this project and I am absolutely sure that I can do the project very well in the shortest possible time. I'm a full-stack expert having sever More
Hi, Greeting for the Day. I am a website designer and I can assist you with both logo and website designing. I have skills with UI/UX deisgning using photoshop, creating responsive effects,Parallax scrolling, Adobe dre More
Hi! I have checked your provided link and details very carefully and I am fully confident that I can develop your project up-to your requirements because I have 7+ year of experience in the web development. I can start More
Dear Client. ****************** First of all, it's my pleasure to bid on your project. I am very interested in your proposal. Because I have rich experience in this field. If you choose me, you'll never be disappointed More
Hi I am Luu, PHP, Laravel, Codeignitor, HTML5, CSS specialist with 5+ Years of experience of doing web development and team team management for different domains. I have developed several eCommerce and cloud based saas More
I have good experience of php,html,css,js etc. I can make any websites as you desire. I will try my best that you wont feel any regrets choosing me.
hey consider it done. website building is an complex jobs for you but it is super easy for us. you need not to pa-y at all for this work. let us know how we can start with. thanks sayantan
Hi, I've 6+ years of experience in graphic and website designing, with php, java-script, photoshop, word-press, database(mysql) and e-commerce development etc with a bachelor degree of Computer Science Engineering. Pl More