In Progress

OnClick MySQL database update (updated)

I run a PHP/MySQL web database. I would like to include a tickbox on a dynamically generated page so that users can track whether the item represented on that page is within their collection. After a JavaScript onclick trigger, this should then:

1. update the database similar to below:

INSERT INTO collection (user_id, item_id)

VALUES ($_SESSION[id], $_GET[id])

... where $_SESSION[id] is the ID of the logged on user and $_GET[id] is the item that is being marked as part of the user's collection.

2. If the tickbox is already ticked and they wish to remove it from their collection it would instead do:

DELETE FROM collection WHERE user_id = $_SESSION[id] AND item_id = $_GET[id] LIMIT 1

3. The tickbox image should automatically update to ticked or unticked status according to whether it is in the user's collection after the onclick trigger.

IMPORTANT: This should be done without reloading the page (presumably by AJAX.)

Examples of similar functionality can be found at Amazon (you can add items to your wishlist in this way) or at www.icheckmovies.com.

Access to our web code will be made available to successful bidder via Plesk.

The rest of this page is already written - this is simply adding the above functionality. I will create a suitable MySQL table in advance.

Skills: AJAX, Javascript, MySQL, PHP

See more: javascript onclick php insert mysql, onclick ajax update mysql, onclick update database, javascript onclick update database, onclick mysql update, javascript update mysql onclick, onclick mysql, onclick update mysql, php onclick update database, javascript onclick mysql update, ajax onclick mysql, ajax onclick mysql update, ajax update database onclick, javascript onclick update mysql, onclick update database php, onclick update mysql ajax, ajax update mysql database, update mysql database ajax, javascript update mysql database, javascript onclick mysql insert, ajax onclick update database, php update database onclick, onclick update database ajax php, update mysql database javascript, php onclick update mysql

About the Employer:
( 1 review ) London, United Kingdom

Project ID: #1290058

Awarded to:

AlinGhinoiu

Hello ! Please check my offer through the private message board. Thank you !

$55 USD in 1 day
(111 Reviews)
6.9

20 freelancers are bidding on average $89 for this job

naumanrandhawa

Hi, Lets start Please check pmb for details.

$70 USD in 1 day
(139 Reviews)
7.1
shihan033010

Hi this is a very easy project. Please check pmb.

$30 USD in 1 day
(227 Reviews)
6.3
RedhopIT

Hi,I can handle this , I'm Ajax expert ;) Check PM for details

$100 USD in 1 day
(70 Reviews)
6.2
shmai

hello! I need to have small discussion session then ready to start. regards, shmai

$150 USD in 6 days
(61 Reviews)
6.2
phpxpert89

Hello Sir/Madam, I am a PHP developer and I know how to use Ajax to update queries in MySQL database via PHP. And I have also used Plesk Control Panel. I would like to do this project. Please reply me back for More

$30 USD in 1 day
(24 Reviews)
5.6
GuruDeveloper

I can do it in a day. Ready to start right now! Payment after completion.

$54 USD in 1 day
(21 Reviews)
5.5
MustafaSR

Hello Sir, Please check PMB

$80 USD in 1 day
(65 Reviews)
5.5
easycoders

Hi, Please check my reviews to have an idea of my expertise. IF interested PM. I can do this very easily and I can start right now.

$60 USD in 2 days
(38 Reviews)
5.4
lnj2008

hi,i'm an Ajax expert ,can do this quickly,pls,check pm

$100 USD in 1 day
(15 Reviews)
5.1
minbha

Hi I will do this and ready to start now. thanks

$45 USD in 1 day
(9 Reviews)
4.1
pundoravikas

Hello sir i am an ajax expert and a dedicated developer.i am ready to work for [url removed, login to view] task would be done easily and results wouls be satisfactory. With regards pundoravikas

$30 USD in 0 days
(6 Reviews)
3.9
moovmoov1

can do the job in not time.

$30 USD in 0 days
(6 Reviews)
3.5
techyash

mysql/php experienced

$250 USD in 3 days
(2 Reviews)
2.8
xtrakt

Hi! I'm a long-time web developer with more than 7 years of experience in PHP, Java, Javascript, MySQL, CSS, Delphi ... Please check the private message. Thank you.

$30 USD in 1 day
(5 Reviews)
1.6
manish2k4

Dear Hiring Manager: This letter is to express my interest in job posted by you. The opportunity presented in this listing is very appealing, and I believe that my strong technical experience and education will make More

$125 USD in 5 days
(0 Reviews)
0.0
pjayramkumar

i have 3 years of experience to data update insert and detete with simple and class wise in php with mysql I able to finish your Works ASAP and your requirement wise

$50 USD in 1 day
(0 Reviews)
0.0
nthedong

With 5 years working with PHP, Javascript, Jquery, HTML and HTML5, CSS. I am a good web developer. My projects: Built web application with PHP: [url removed, login to view] Built web application with PHP: [url removed, login to view] More

$200 USD in 7 days
(0 Reviews)
0.0
CristianMD

Extended experience with debugging, maintaining and upgrading complex and high profile websites. I request no payment upfront. I request the payment at the end of the project.

$50 USD in 1 day
(0 Reviews)
0.0
seven4work

I am good in AJAX. I am used to jQuery. I can make it done fast.

$250 USD in 1 day
(0 Reviews)
0.0
pmonaghan

Hi there, I am an experience web designer and I would be the right person for this. I have sent you a private mail with my solution.

$60 USD in 2 days
(0 Reviews)
0.0