Php script and my sql

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).


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)

Skills: PHP, HTML, JavaScript, Website Design, MySQL

See more: php script send attached files, php script send email specific email address, send attached file mail php script, php script send sms india, php script send sms, use php script wordpress, store joomla variables use external php script, free php script webshop sql, php script files ftp send files ftp, php script login times disable, free php script sql multiplayer game, php script sql poker ajax, sql backup php zip sql send email script, php script sql server database backup, wap site php script sql download, php script sql, create a form store in sql db email for approval send result to user

About the Employer:
( 9 reviews ) Toronto, Canada

Project ID: #21304506

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

$70 CAD in 1 day
(195 Reviews)

38 freelancers are bidding on average $168 for this job


Hello! We are A2 Design, a Russian-Canadian web development company. Having the required skills, we will be glad to help you with your project. We have some questions for you to clear up before we start. Please m More

$350 CAD in 3 days
(152 Reviews)

Hi Thanks for sharing your project and we will be more than happy to help you. I am ready to start and I would like to discuss with you on this project. Please check my portfolio here: [login to view URL] More

$250 CAD in 10 days
(548 Reviews)

Dear Sir/ma'am, Greetings !! I have 14+ years of experience with my 15+ developers those are best in their domain. Please share me your queries with me, I assure you that i can give you full satisfaction of work. We More

$140 CAD in 7 days
(124 Reviews)

Hello.. I am an expert web developer having 8+ years of experience in PHP and CI. I can optimise and update website and able to perform customisation and development tasks with a PHP website in CodeIgnitor Environment More

$160 CAD in 7 days
(213 Reviews)

Hello, I will develop Php script and my sql. I'd really like to work with you on this one if possible! I do have a couple of questions, but first I'd like to make you an offer and some background so you can check my More

$140 CAD in 2 days
(173 Reviews)

Greetings !! Myself Aman Miglani have more than 10 year experience in web development with PHP and php frameworks as well as designing.I read your job description and understand that you are looking good developer w More

$200 CAD in 7 days
(256 Reviews)

Hi After analysed your attachment, we would like to inform you that we have done many project like [login to view URL] can do this as per your requirements, we have 10 years experience as a PHP developer and many [login to view URL] getting More

$220 CAD in 10 days
(216 Reviews)

Hi, My work experience as shown in my profile have helped me develop mastery in Website design & development. I'm a full-stack developer with more than 10 years of work experience. Expert in BOTH Backend and Front- More

$250 CAD in 7 days
(216 Reviews)

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

$200 CAD in 7 days
(87 Reviews)

do you have a problem with your HTML and css code and doesn't know how fix it or you want change or add something to your HTML page then your in the right place with this service you will get: fix Any Html / Html5 Bug More

$140 CAD in 7 days
(85 Reviews)

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

$190 CAD in 7 days
(78 Reviews)

Sami Y. could you please inbox me more detail about this project ==== Ready for an Immediate start ==== Based on your mentioned set of requirements…. I I am an expert web designer/developer and have extensive experien More

$155 CAD in 4 days
(56 Reviews)

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

$140 CAD in 7 days
(18 Reviews)

Hey there, Thank you for the detailed description. According to which you need a PHP expert to work on your PHP script and SQL commands. - I have excellent key skills with Apache, MySql, PHP, XML, JSON, JQuery, Boot More

$90 CAD in 7 days
(27 Reviews)

Hello, I'm Ankit I'm interesting your project very well I'm good in Website Design,PSD TO HTML HTHML, CSS , JAVASCRIT, JQUERY, AJAX, PHP, Wordpress,Codeigniter,laravel and mysql ,Phonegap expert. I’m quite well ex More

$140 CAD in 7 days
(59 Reviews)

Hello, I’d really like to work with you on this job! I would love to interact with your questions on how can I prove to be best choice for you, but first I’d like to make you an offer and some background so you can che More

$158 CAD in 7 days
(1 Review)

I am an experienced full stack developer developing in core Php and Codeigniter framework. I am dedicated, honest and can surprise you with my outstanding turnaround time. I have developed many projects in Codeigniter More

$200 CAD in 15 days
(19 Reviews)

Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Here is few recent work for website development : crm.n More

$140 CAD in 7 days
(31 Reviews)

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

$140 CAD in 7 days
(72 Reviews)

Hi There, We are Erudition Informatics Private Limited, a development agency with an experienced team of Developers and designers, catering clients in UK, Germany, Netherlands, US, Middle East, and India. Technologies More

$100 CAD in 20 days
(9 Reviews)