Completado

php mysql code to insert and update survey data in an existing page

The project requires the inclusion of some mysql query code in a php files (1 page) which uses javascript to show and hide questions in a survey style experiment. The database connection is established in the file as well. I am happy to have this seperated out into an included file if that makes things more secure. The script is a survey with 16 questions (displaying 4 segments after specific timings. All that is already working in the script as required)

The following items must be coded in php:

a) on connecting to the dabase the first check should be if the IP address of the client computer is already in the database. If so another page should be called (no need to code it) after the database connection is closed and cache is cleared.

b) a new record is created (assuming the ip is not found in the database table "results"

c) the random order of the questions held in the staps[step] array should be posted to the database field qorder as a string (see database structure attached)

c) the answer score to each question is added to the new record (question 6 answer is stored in the database table "results", field "q6" (this is in a sub block radio buttons)) - no submit button may be added. action must be performed on click.

d) each question answered updates the database relevant field ( q1 updates "q1" and so on. the survey has 16 questions)

e) on completion of the survey the database connection is closed and the user is directed to another page (again the linked to page is not included in the proeject.

I am hoping this is very straight forward for a good javascript, php, mysql coder. I have included here the existing script, which works, and also the database structure as an sql statment. I expect sqli to be used unless someone gives me a good reason not to. You are the experts :)

Happy bidding.

Habilidades: PHP, MySQL, Javascript

Ver más: how to store form data in database using php, insert data from form to mysql database php, how to save data in database on button click in php, how to save data from html form to a database using php, edit form in php with example, php submit form to database and email, store data from html form to database, how to insert data into mysql db using form in php database, php mysql code bid, guide php mysql member login update, create appointment using php mysql code, php mysql form dropdown update, php mysql programming profile update edit, php mysql code multiple choice questions answers, php mysql code mobile verification sent sms, read data ticker php mysql code, gift certificate php mysql code, php mysql database insert edit delete, complete php mysql code, load specific web page php mysql code

Información del empleador:
( 62 comentarios ) Weybridge, United Kingdom

Nº del proyecto: #24573507

Adjudicado a:

talentedexpert57

Hello, I am interested in your current project. As a honest web developer, I have rich experience of web developing for 8 years over. Upon reviewed your description the project seems perfect match for my expertise, wit Más

$50 USD en 7 días
(4 comentarios)
2.7
leoe

Hi! I've checked the files attached, and it seems very basic, and "hardcoded" I can help you to finish the project in this way, or we can refactor all to be asynchronous, and not hardcoded (you can manage the questions Más

$50 USD en 1 día
(116 comentarios)
6.7

39 freelancers están ofertando el promedio de $172 para este trabajo

latatestTech

With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, I hope you are doing well! I have gone through your requirement and I would like to ask few questions which would assist me to know more Más

$140 USD en 7 días
(174 comentarios)
8.0
isyncevolution

iSyncEvolution awarded to "Preferred Freelancer". iSyncEvolution promise 100% work delivery & 100% work satisfaction. iSyncEvolution having 12 Yrs. Exp. Integration Web Development , Web / Graphic Design , Android & Más

$750 USD en 30 días
(69 comentarios)
7.4
sid0

Hi sir, it will take 1 day for us to do this job..............................................................

$100 USD en 1 día
(250 comentarios)
7.2
Programmer59

Hello Sir, I am professional php developer with having more than 5 year's experience in this field. I read your project description and I am interested in it I need some more information related to your project Can we Más

$250 USD en 7 días
(69 comentarios)
6.3
Waqaskhan591

Hello, I have read your project description and I want to tell you that I am a Professional PHP, MySQL and JavaScript developer and I can insert and update survey data in an existing page for you exactly as per your Más

$250 USD en 2 días
(21 comentarios)
5.2
ImmortalStas

Hi, are you looking for Real Web Expert? Then WELCOME to the right place! High-quality and Fast-delivery is promised! As a highly skilled full stack developer, I have rich experience in Web development. I am very conf Más

$300 USD en 3 días
(11 comentarios)
5.4
kazimking

Hello Sir, hope you are fine, I am interested in your work "survey code of Morag's Experiment" I have 5 year experience in Web Development Service I am able to this job quickly.

$200 USD en 7 días
(45 comentarios)
5.5
glenndietrich

I have reviewed your project details and I am an experienced php/mysql programmer. I can create the code to provide the functionality you are looking for. I can start right away and deliver in a timely manner.

$75 USD en 3 días
(10 comentarios)
5.3
GuangJie

Hi,client Thanks for your good job posting I have carefully read your job description and the 6 items are clear to me Please interview me to discuss more in detail Kindly regards

$250 USD en 4 días
(16 comentarios)
5.3
liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Más

$250 USD en 3 días
(12 comentarios)
5.0
DmitryShashko090

Here is an expert with PHP and MySql. Thank you for your job post. After reading your job description, i felt that i am an enough candidate to take this job on. Please contact me to get the result done in a professiona Más

$200 USD en 2 días
(11 comentarios)
5.0
ivitob79

HI I have just gone through all your requirements. As a developer experienced PHP, MySQL, Javascript, I can complete the task properly and quickly. Please hire me and discuss more detail. Best Regards.

$140 USD en 1 día
(10 comentarios)
4.2
elvialc

Hi, I am a web developer with 5 years of experience. In specially, I specialize in the node.js and php(Laravel) and have worked on several similar projects you want. I can deliver quality results to tight deadlines and Más

$200 USD en 7 días
(3 comentarios)
4.3
DRG1990

Hello I am a web expert with 10 years of experience in PHP, MySQL, Javascript, HTML, CSS. Also, I have rich experience in these fields. So I am interested in and I am confident in your project. If you give me a chance Más

$140 USD en 3 días
(5 comentarios)
4.3
ivofacundo

I'm interested in this project and I can add the script that you need for updating the database without problems! I can help you with your project as soon as you want! My skills: Backend: PHP + MySQL +3 years: (Vani Más

$100 USD en 1 día
(17 comentarios)
3.9
artemzlobin900

Hello. I have just read your project. I am really interested in your project now. Because my skills are suitable for your project. I am an expert in PHP and MySQL. I like the "Fastest" and "Perfect". I always complete Más

$150 USD en 3 días
(6 comentarios)
3.2
wisepartner

Hi,dear. I am very interested in your project - 'php mysql code to insert and update survey data in an existing page'. I've already done this kind of project before. I'm a professional programmer with 12 years of exper Más

$155 USD en 1 día
(5 comentarios)
2.9
jorgeeolayap1

Hi,I read your 5 requirement carefully and I am ready to start immediately and I am sure that I can complete your project perfectly. I am a full-stack developer who has rich experience in web development, especially in Más

$100 USD en 7 días
(6 comentarios)
3.2
vineetmarketing

Hello We are a team of Web Developer and Graphic Designer. we also have experience in Desktop and Mobile Application development. I have reviewed your project description I understand your need, I would really like t Más

$140 USD en 7 días
(2 comentarios)
3.2
nemanjadj20

Hello? I have worked on LAMP STACK projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you are seeki Más

$155 USD en 1 día
(2 comentarios)
3.2