Pass image id to php mysql query via jquery

Question

I need to pass image id to mysql query.

For that, i have done these coding. But it results in Undefined index x: I referenced many stackoverflow answers. But nothing is working.

echo "<img src=http://localhost/ss/img/".$p['path']." id=".$p['album_id']." class='img-responsive' alt='' data-toggle='modal' data-target='.bs-example-modal-lg1'>";

if(isset($_GET['x'])) { echo $_GET['x']'; } 

<script>
$(document).ready(function() {
            $(".g2 img").click(function() {
                var albumID = $(this).attr('id');
                alert(albumID);  //working fine, getting id
                $.ajax({
                    type: 'GET',
                    url: 'index.php',
                    //data: x: "albumID",           
                    data: x: albumID,
                    success: function(data)
                    {
                       alert("success!");
                    }
                });
            });
        });
</script>

What is the wrong which i'm doing? Please help me.

you have a mistake with { echo $_GET['x']'; } with the quotation — Manjar
– Manjar, Commented Oct 14, 2014 at 6:50
After removing also, it shows Notice: Undefined index: x, Is there any other method to pass clicked image id to php — Mark
– Mark, Commented Oct 14, 2014 at 7:00

Aman Rawat · Accepted Answer · 2014-10-14 06:52:53Z

5

if(isset($_GET['x'])) { echo $_GET['x']'; }

replace with

if(isset($_GET['x'])) { echo $_GET['x']; }

extra ' was there

if the issue is still there check your url that should be somthing like this

 index.php?x=sometext

answered Oct 14, 2014 at 6:52

Aman Rawat

2,6251 gold badge27 silver badges40 bronze badges

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

2 Comments

Mark Over a year ago

After removing also, it shows Notice: Undefined index: x, Is there any other method to pass clicked image id to php

Mark Over a year ago

yes, i can pass clicked image id to url as index.php?x=13

Ankit · Accepted Answer · 2014-10-14 07:47:25Z

0

http://localhost/ss/img/".$p['path']." id=".$p['album_id']." class='img-responsive' alt='' data-toggle='modal' data-target='.bs-example-modal-lg1'>";

if(isset($_GET['x'])) { 
    echo $_GET['x']; 
} 
?>
<script>
$(document).ready(function() {
            $(".g2").click(function() {
                var albumID = $('.img-responsive').attr('id');
                alert(albumID);  //working fine, getting id
                $.ajax({
                    type: 'GET',
                    url: 'index.php',
                    //data: x: "albumID",           
                    data: {x: albumID},
                    success: function(data)
                    {
                       alert("success!");
                    }
                });
            });
        });
</script>

edited Oct 14, 2014 at 7:47

answered Oct 14, 2014 at 7:33

Ankit

11 bronze badge

1 Comment

Ankit Over a year ago

what the issue you face,can you explain it?

Ronser · Accepted Answer · 2014-10-14 08:18:39Z

0

need not use it like that just make a ajax call and place the data in whatever div you want

using document.getElementById("yourDiv").innerHTML=data;

try

$('body').on('change','.g2 img',function() {    //works for ajax loaded contents
    var albumID = $(this).attr('id');

    var formid  =   new FormData();

    formid.append('albumID ',albumID );

    $.ajax({            

                    url         :   'index.php',
                    dataType    :   'text',
                    cache       :   false,
                    contentType :   false,
                    processData :   false,
                    data        :   formid,        
                    type        :   'post',
                    success     :   function(data){     
                                alert(result);                     

                                //document.getElementById("div1").innerHTML=data;

                    }
            });
 }

just try using

url: 'index.php?x='+albumID,

change your href you have mentioned to

<a href="/test.php?abid=<?php echo $id;?>"> this should work

dynamic sql query??

use something like $str = "insert into table values('".value1."', '".value2."', '".value3."')"

edited Oct 14, 2014 at 8:18

answered Oct 14, 2014 at 6:58

Ronser

1,8756 gold badges20 silver badges38 bronze badges

1 Comment

Mark Over a year ago

Yes, i'm getting ids, but i need to pass dynamically in mysql query.

Collectives™ on Stack Overflow

Pass image id to php mysql query via jquery

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related