No SQL data returned through jQuery ajax post

Question

I am having some issues returning data from on page, using jQuery, PHP and MySQL. I would like to show the query results on the index.php page. The results are fetched from the database using getResults.php.

When I manually run the getResults.php?id=123 file, all works fine. In this case i'm seeing the results I would like to. However, when I want to post the 'id' 123 in a submit form on index.php, I don't see any results returned by jQuery / getResults.php. Only thing that changed is the URL: index.php?id=123. However, I'm not seeing any results or an error message...

Any one an idea?

getResults.php file

$search = mysql_real_escape_string( isset ($_POST['id']));

if ($search) {
$friend = mysql_query(  " SELECT * FROM reviews WHERE fbuserid = '$search' ORDER BY datumtijd DESC" );

if ( $friend )  {   
    while ($row = mysql_fetch_array ($friend) ) {
            echo "Show some results...";
    }
} else {
    echo "No matches found";
}
} else {
echo "Query not succesfull";
}

index.php file

<script type="text/javascript" charset="utf-8">

        $(document).ready(function() {

        $("#submit").click(function) {
            event.preventDefault();
            $.ajax({
                url:"getResults.php",
                type:"GET",
                data: "id="+this.value,
                success: function(data) {
                    $("#results").html(data);
                }
            });
        }
        return false;
    });

    </script>    

    <div>
        <form>
            <input type="text" name="id">
            <input type="submit" value="submit" id="submit">
        </form>
    </div>        
    <div id="results"></div>

EDIT: Thanks, all for your input. Nevertheless, I'm still not there... As you might notice, I'm not quite experienced with jQuery and PHP. See changes in scripts above. In short: - I added the false statement if ($query) is not succesfull; - Changed the $.post method into $.ajax; - Changed the GET into POST in the PHP file;

Any other suggestions?

No it isn't, Little Bobby Tables can sill wander in and trash your database. — Quentin
– Quentin, Commented Feb 13, 2011 at 18:40
Forgot to add mysql_escape_string(). I'm not sure if this is sufficient. I guess not...I didn't know about bobby-tables.com. I'm not too familiar with sql injections, so I will dive into this later on. — franksprings
– franksprings, Commented Feb 13, 2011 at 19:25

Quentin · Accepted Answer · 2011-02-13 18:39:36Z

1

You are POSTing data but your script is looking for it in GET.

Edit in response to massive rewrite of the code in the question:

The first argument of $.ajax should be the URL.
You are missing the { from your settings object.
You are using a = instead of : for your type parameter.
You aren't doing anything to stop the normal submission of the form, so the form gets submitted and a new page loaded before the HTTP request sent by the Ajax returns.

edited Feb 13, 2011 at 18:39

answered Feb 13, 2011 at 17:02

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

2 Comments

franksprings Over a year ago

David, thanks for your input. I added your suggestion. However, I'm not sure if this is cause that I don't see any results returned. Do you have additional suggestions?

franksprings Over a year ago

Thanks. I added some JS. Among which event.preventDefault() to the stop the normal submission. Still struggling though. Keep u posted.

mellamokb · Accepted Answer · 2012-07-25 15:31:41Z

1

In the first line:

$search = mysql_real_escape_string( isset ($_POST['id']));

Try changing $_POST to $_GET:

$search = mysql_real_escape_string( isset ($_GET['id']));
                                           ^^^^^

edited Jul 25, 2012 at 15:31

mellamokb

56.8k12 gold badges111 silver badges138 bronze badges

answered Feb 24, 2012 at 7:32

Pranit Mhatre

111 bronze badge

Comments

Akhilesh Sharma · Accepted Answer · 2011-02-13 17:12:46Z

0

Its much better to use the jQuery ajax method to implement the ajax functionality in the script. As it is more generalized rather than specific to one METHOD. Below is the sample code to use the ajax method.

$(document).ready(function()
{
$("#submit").click(function)
{
$.ajax(
type="GET",
url:"getResults.php",
data: "id="+this.value,
success: function(msg)
{
$("#results").html(msg);
}
);
}
});

To check out more examples please refer to the JQUERY API Reference.

J

answered Feb 13, 2011 at 17:12

Akhilesh Sharma

1,6282 gold badges18 silver badges29 bronze badges

Comments

TeAmEr · Accepted Answer · 2011-02-13 18:14:04Z

0

in if ($query) { is $query !== false ???

answered Feb 13, 2011 at 18:14

TeAmEr

4,77313 gold badges67 silver badges108 bronze badges

Collectives™ on Stack Overflow

No SQL data returned through jQuery ajax post

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related