Sending variable with ajax

Question

I'm having some troubles trying to send an id through ajax script, I'm trying to create an address book, when you select a contact it load all his information in another page and the ajax script load this page inside the main. Everything is working except to send the ID of the contact. There's a bit of the code :

 $.ajax({
         url: "select.php",
         dataType: "html",
         data: {id: id},
         success: function(Result) {
         $('#result').html(Result);
         }
        });

PHP

$id = $_POST['id'];
echo $id;
$sql = "SELECT * FROM ca11 WHERE contact_id= $id";

does anyone have an idea ?

you haven't provided the type of request in the ajax if its post — Kevin
– Kevin, Commented May 31, 2017 at 12:34
be careful with the query though, don't directly inject variables into query statements, prepare them instead — Kevin
– Kevin, Commented May 31, 2017 at 12:35
Little Bobby says your script is at risk for SQL Injection Attacks.. Even escaping the string is not safe! — Jay Blanchard
– Jay Blanchard, Commented May 31, 2017 at 12:35

Ashok · Accepted Answer · 2017-05-31 15:30:58Z

1

you need to add which type of request you are making, as your question, you can call post request as below

$.ajax({
  type: "POST",
  url: "select.php",
  dataType: "html",
  data: {id: id},
  success: function(Result) {
         $('#result').html(Result);
     }
});

For more information you can refer this link http://api.jquery.com/jQuery.post/

edited May 31, 2017 at 15:30

answered May 31, 2017 at 12:47

Ashok

1842 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Sending variable with ajax

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related