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

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:


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

$55 USD in 1 day
(111 Reviews)

20 freelancers are bidding on average $89 for this job


Hi, Lets start Please check pmb for details.

$70 USD in 1 day
(139 Reviews)

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

$30 USD in 1 day
(227 Reviews)

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

$100 USD in 1 day
(70 Reviews)

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

$150 USD in 6 days
(61 Reviews)

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)

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

$54 USD in 1 day
(21 Reviews)

Hello Sir, Please check PMB

$80 USD in 1 day
(65 Reviews)

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)

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

$100 USD in 1 day
(15 Reviews)

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

$45 USD in 1 day
(9 Reviews)

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)

can do the job in not time.

$30 USD in 0 days
(6 Reviews)

mysql/php experienced

$250 USD in 3 days
(2 Reviews)

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)

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)

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)

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)

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)

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

$250 USD in 1 day
(0 Reviews)

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)