Send data to mysql database from jquery

Question

I'm implementing some code that alerts users that my site is using cookies. If they consent I want to update my mysql database with the consent (eg 'yes' or 'no'). I got the current code from this site and it works great.

Currently it just prints the approval in the console(user approves) but I'm unsure how I should go about sending this data to php. I understand how to save to my database with php, it's just passing the data from jquery to php that I'm not sure how to go about. I do know a little ajax...

   <script type="text/javascript">
    $(document).bind("user_cookie_consent_changed", function(event, object) { 
      // true or false 
      console.log("User consent: " + $(object).attr('consent') ); 
    });
    </script>

This prints out

Waqar · Accepted Answer · 2018-08-29 21:09:15Z

1

I assume you are using core php. You need to create a function that will take data (coming from ajax) in form of YES or NO. Now Based on YES or NO you set condition in your function and update database. Now sending YES or NO from ajax.

var cookie = 'yes'; //User allows  
$.post('path to your function',{data:cookie},function(rdata){
   //anything returned from that function stored in rdata variable.
});

Now in your function you can get data by $_POST['data']

answered Aug 29, 2018 at 21:09

Waqar

8485 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Send data to mysql database from jquery

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related