Send sql data from jQuery

Question

I'm trying to retrieve database information based on what row a user clicks in a table, then later use that data in another page to display other database information. I don't know the best way to achieve it. Should I use Ajax and $.post() or are there other better/simpler ways?

I can retrieve the data from the table by

 echo "<tr data-href=". $row["id"] . " class=\"tableclass\"><td>"

and then in jQuery

$(".tableclass").click(function () {
    data = $(this).data("href");
    alert(data);

The alert shows that I do get the database information (column ID). Now, I would like to post that information, preferably in a secure manner, to another PHP page where I can retrieve it and use it to get other information from the database.

How do I post it and then how should I retrieve it in the next php page?

You should add ' or " signs around the data-href's value.

sleepless_in_seattle
– sleepless_in_seattle

2015-03-17 16:06:20 +00:00
Commented Mar 17, 2015 at 16:06 — sleepless_in_seattle
– sleepless_in_seattle, Commented Mar 17, 2015 at 16:06
And to post the value, use jQuery's $.post.

sleepless_in_seattle
– sleepless_in_seattle

2015-03-17 16:06:49 +00:00
Commented Mar 17, 2015 at 16:06 — sleepless_in_seattle
– sleepless_in_seattle, Commented Mar 17, 2015 at 16:06

Kapil Lohakare · Accepted Answer · 2015-03-18 20:19:27Z

1

Both works in same manner. 1. $.post is just a call with $.ajax(), just with the type set. 2. $.ajax() defaults to a GET

$.post( "/ajax", {"data" : json }) //is nothing but



  $.ajax({ 
  type: "POST", 
  url: "/ajax", 
  data: {"data": json} 
});

If you want the data to be passed securely, use json or don't do thing if the request is not properly authenticated. Typically, when you make an AJAX request, cookies are also sent: along with the request so you should just be able to use the same authentication method that you use for your regular requests with your AJAX requests.

Nothing much to do that, you need to use $_POST to access all the values in php in file save.php

edited Mar 18, 2015 at 20:19

answered Mar 17, 2015 at 16:10

Kapil Lohakare

3502 silver badges8 bronze badges

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

3 Comments

sika Over a year ago

Thank you for your quick response! I've never used Ajax, so I will read up on it. How do I fetch the data in the next page after I have posted it like you wrote? Say that page is save.php

Kapil Lohakare Over a year ago

Use $_POST[] to access all the values in php in file save.php

Kapil Lohakare Over a year ago

Use following method in JS file: $.ajax({ type: "POST", url: "/save.php", data: {"data": json} });

Collectives™ on Stack Overflow

Send sql data from jQuery

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related