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

Imekamilika Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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.

PHP MySQL JavaScript

Kitambulisho cha Mradi: #24573507

Kuhusu mradi

24 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

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 Zaidi

$50 USD kwa siku 1
(Maoni 120)
6.7

24 wafanyakazi huru wanazabuni wastani wa $180 kwa kazi hii

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 Zaidi

$140 USD kwa siku 7
(Maoni 203)
8.3
sid0

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

$100 USD kwa siku 1
(Maoni 258)
7.3
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 Zaidi

$250 USD kwa siku 7
(Maoni 79)
6.4
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 kwa siku 4
(Maoni 32)
6.7
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 Zaidi

$140 USD kwa siku 3
(Maoni 21)
6.1
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 Zaidi

$250 USD kwa siku 3
(Maoni 13)
5.4
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 kwa siku 3
(Maoni 13)
5.6
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 kwa siku 7
(Maoni 45)
5.5
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 Zaidi

$100 USD kwa siku 1
(Maoni 20)
5.1
custdeal2019

Hi there, Ready to start now, will develop the survey form with 16 questions (displaying 4 segments after progress bar) Done similar kind of project ready to do this one also Thanks

$100 USD kwa siku 2
(Maoni 11)
4.6
dinesh10contact

Dear client, I 'm expert in "CSS, HTML, PHP, Website Design, WordPress,laravel,codigniter," and I have working for 8+ years in this field. I 'm very interest to your project. I have checked your project description Zaidi

$250 USD kwa siku 7
(Maoni 14)
4.3
ecksdeegege

Hello. Thanks for submitting a project. You’re looking for a expert. As I am an talent web full-stack deleloper with PHP, JAVASCRIPT, CSS, CakePHP for 9years. This is exactly what I specialise in. Talk about a per Zaidi

$130 USD kwa siku 7
(Maoni 13)
4.1
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 Zaidi

$140 USD kwa siku 7
(Maoni 2)
3.3
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 Zaidi

$150 USD kwa siku 3
(Maoni 7)
3.4
Sutho73

Hello My top priorities are creating the apps with high-quality code without bugs. I have been developing web-apps and tool for 4 years, I have over 10 completed projects. [Programming Experience] • PHP: 4 years. • J Zaidi

$100 USD kwa siku 1
(Maoni 5)
3.0
Johndobr

Hello, I can help you with the survey page. I’ve done surveys projects in the past so I really know what I’m doing. It’s an interesting project that I can do with ease. If you want my assistance, contact me. Kin Zaidi

$111 USD kwa siku 1
(Maoni 4)
2.4
neuripa

Hello, I think I can complete your project. I am a junior web developer, I have at least one year of experience working on web programming in personal and freelancer projects basically. I have knowledge of PHP, MySQL, Zaidi

$160 USD kwa siku 7
(Maoni 2)
0.8
robertcopenhagen

Hello, I'm glad to have the occasion to bid for this project. I will introduce myself, I have a 4 year experience in web development as a Full Stack web developer. I'm a hard working person who wants to provide a qual Zaidi

$200 USD kwa siku 3
(Maoni 1)
0.6
honeyballz

Hi Dear client! I have read your requirement and I am very interested in your project. Seems to be an interesting work and good opportunity to show my skills to work with you in future as well. I'm a professional dev Zaidi

$140 USD kwa siku 7
(Maoni 0)
0.0