Ajax pass id using POST with php (Error Undefined variable: id)

Question

Im new In AJAx. My problem is I have ajax Function to pass variable ID in php when the page is load the error is Undefined variable: id but when I look in firebug post id is past successfully . Here is my ajax.

$('.btn_edit').click(function(e){
    e.preventDefault();
     var $this = $(this);
    var id_id = $(this).attr('id');
    alert(id_id);
         $.ajax({
     type: "POST",
         url: "edit_query.php",
             data:{id: id_id},
          success: function() {
        alert("Success Input");

and this is my php page to pass.

    $id = $_POST['id'];
    $sql = mysql_query("select * from user where uid = ".$id."");
    $table = mysql_fetch_assoc($sql); 

    ?>

Write : success: function(data) { alert(data);} ; and in php: echo $id; — Sahil Mittal
– Sahil Mittal, Commented Nov 29, 2013 at 6:51
@Sudhir Yes I see it and the output is correct even I try to alert the sucessful data. — Marc
– Marc, Commented Nov 29, 2013 at 6:59

Harish Singh · Accepted Answer · 2013-11-29 07:18:21Z

1

$sql = mysql_query("select * from user where uid = ".$id."");

should be

$sql = mysql_query("select * from user where uid = $id ");

and

var id_id = $(this).attr('id');
alert(id_id);
$.ajax({
 type: "POST",
     url: "edit_query.php",
     data:"id="+id_id,
     success: function() {
        alert("Success Input");
     }

edited Nov 29, 2013 at 7:18

answered Nov 29, 2013 at 6:56

Harish Singh

3,3195 gold badges27 silver badges40 bronze badges

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

2 Comments

Marc Over a year ago

I think your Example is all same.

Harish Singh Over a year ago

send your data as data:"id="+id_id

Amit Soni · Accepted Answer · 2013-11-29 06:54:30Z

0

try this

$.post( "edit_query.php", { id: id_id })
  .done(function( data ) {
    alert( data );
  });

edited Nov 29, 2013 at 6:54

answered Nov 29, 2013 at 6:49

Amit Soni

1,4271 gold badge9 silver badges18 bronze badges

9 Comments

Marc Over a year ago

I try this I running but I try to echo $_POST['id'] there is value but in console it is empty. How can it be empty whilw when u echo it there is value. error is Notice: Undefined index: id in C:\xampp\htdocs\administrator\edit_query.php on line 8

Marc Over a year ago

@AmitSoni actually the edit_query.php is the the code which is this

Marc Over a year ago

$id = $_POST['id']; $sql = mysql_query("select * from user where uid = ".$id.""); $table = mysql_fetch_assoc($sql);

Marc Over a year ago

only this $id = $_POST['id'];

Amit Soni Over a year ago

try print_r($_POST); and see what you are getting

|

hanzo2001 · Accepted Answer · 2013-11-29 09:51:42Z

0

try this

edit_query.php

<?php
$id = $_POST['id'];
$sql = mysql_query('SELECT * FROM user WHERE uid = '.$id);
$row = mysql_fetch_assoc();
header('Content-Type: application/json');
echo json_encode($row);
exit;

your.js

$(function(){
  var onClick, successHandler;
  onClick = function (e) {
    e.preventDefault();
    $.post('edit_query.php',{id:$(this).attr('id')},successHandler,'json');
  };
  successHandler = function (json) {alert(json.uid);};
  $('.btn_edit').click(onClick);
});

answered Nov 29, 2013 at 9:51

hanzo2001

1,4081 gold badge13 silver badges24 bronze badges

Collectives™ on Stack Overflow

Ajax pass id using POST with php (Error Undefined variable: id)

3 Answers 3

2 Comments

9 Comments

edit_query.php

your.js

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

9 Comments

edit_query.php

your.js

Comments

Your Answer

Sign up or log in

Post as a guest

Related