Completed

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

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)

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:
( 8 reviews ) Toronto, Canada

Project ID: #21304506

Awarded to:

aftabyounas

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
(140 Reviews)
6.5

55 freelancers are bidding on average $157 for this job

A2Design

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
(150 Reviews)
8.8
imagicaworld

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
(185 Reviews)
7.3
voizacinc

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
(113 Reviews)
7.4
webexpert0102

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
(542 Reviews)
7.6
Brightinfotech3

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
(229 Reviews)
7.2
techwelfare

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
(206 Reviews)
7.3
markninja

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
(133 Reviews)
7.3
vranjan

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
(204 Reviews)
7.0
seefattechnologi

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
(79 Reviews)
6.6
developersperhr

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
(78 Reviews)
6.3
Websitemaestro

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)
6.4
Anna0506

Hi dear It's nice to meet you! I read your job post carefully and got your need. As I am a skilled web developer from Ukraine, I have much experience with php, html, css, mysql and js/query debugging. I am sure I can h More

$140 CAD in 7 days
(77 Reviews)
6.4
blackwhite123

Hello, I am pleasure with your job for Php script and my sql. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but f More

$140 CAD in 7 days
(16 Reviews)
5.9
santoshm143

Hi, I am interested in your project and can surely assist you in this project very well I'm an experienced, Professional, Highly skilled, detail-oriented Web developer having more than 5 years of experience and guaran More

$250 CAD in 7 days
(30 Reviews)
5.6
DianaBorisov

How are you? Thank you for giving me a chance to bid on your project. I am a serious bidder here and can deliver as you have mentioned. I have got rich experience in Laravel, Codeigniter, Yii2, Symfony, Angular, Vue, More

$140 CAD in 7 days
(38 Reviews)
5.8
sergeym610

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
(12 Reviews)
5.3
deepakatinfin

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
(26 Reviews)
5.4
amitbanerjee2812

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)
5.5
workandlive123

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
(63 Reviews)
5.7
ankitbagre2000

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
(39 Reviews)
5.1