Change value from 0 to 1 in database after click on button (delete it)

Question

I have a table:

How do this? Click "Do" → status is payed. – user name 2 Dec 29 '17 at 17:52 — user name 2, Dec 29 '17 at 17:52

score 0 · Answer 1 · answered Dec 29 '17 at 18:04

0

Question is a bit vague but...

Create a listener for your "Do" buttons. Perhaps assign id's to the buttons that match the ID of the database record. Have a section of php that makes an sql update call on the proper table. When the button is clicked, update that records status.

It would be more help if you were to have a more specific question.

answered Dec 29 '17 at 18:04

Joshua Espana

84
7

please send code... – user name 2 Dec 29 '17 at 18:23
I am not going to write everything out for you. I learned the basics of form handling [here](https://www.w3schools.com/php/php_forms.asp). If you plan your problem out, the soulution is very simple. – Joshua Espana Dec 29 '17 at 18:31

score 0 · Accepted Answer · answered Dec 29 '17 at 18:09

0

Checkout this answer

Clicking a button is client side whereas updating database is Server side. So use an ajax call as described in above answer to call some php function which will then update the database.

answered Dec 29 '17 at 18:09

neV_

53
6

please send code... – user name 2 Dec 29 '17 at 18:23
@НиколайШейгиц the code is given in the link. Set a listener to your button. In that listener make the ajax call to some php file as post request if you want to send in parameters. And in PHP, update the record in database. – neV_ Dec 29 '17 at 18:27
Can you write the code for me..? I try the code... but it not work for my – user name 2 Dec 29 '17 at 19:07

Change value from 0 to 1 in database after click on button (delete it)

2 Answers2