CODEWITHSUNDEEP
phpjqueryajax
skevthedev
skevthedev

Reputation: 465

JQuery AJAX Issue without error

So I am adding a list of stores to a web page via a jQuery AJAX request. This little utility is not dynamic, just database driven. I have decided to use jQuery/AJAX to transfer the data because when I try to embed PHP in our current PHP CMS, I get a bunch of conflicting errors.

The problem I am having is that I am getting a jQuery AJAX error when trying to make the request to the PHP script, and I am not sure why.

Here is my AJAX request

$(document).ready(function(){
    $.ajax({
        type:"POST",
        url:"getStores.php",
        dataType: "json",
        success:function(data){
            results(data);
        },
        error: function(data) {
            console.log(data.error);    
        }
    });
});

The cryptic console error i am getting is this

function (){if(c){var a=c.length;m(arguments),i?k=c.length:e&&e!==!0&&(j=a,n(e[0],e[1]))}return this}

Here is my PHP code if it will be helpful:

//database connection
$return_arr = array();
$sql = mysql_query("SELECT * FROM where_to_buy");
while($row = mysql_fetch_array($sql, MYSQL_ASSOC))
{  
    $row_array['store_name'] = $row['store_name'];
    $row_array['store_url'] = $row['store_url'];
    array_push($return_arr,$row_array);
}
echo json_encode($return_arr);

I think the problem might be because I wrapping my JSON in an array?

EDIT:: JSON output from php script as requested

[{"store_name":"Example 1","store_url":"http:\/\/www.example1.com"},{"store_name":"Example 2","store_url":"http:\/\/www.example2.com"}]

Thanks for any help!

Upvotes: 0

Views: 156

Answers (1)

Andbdrew
Andbdrew

Reputation: 11895

The reason you are getting that weird error message is that the error callback for the jQuery ajax function takes 3 arguments instead of 1, as described in the docs here: http://api.jquery.com/jQuery.ajax/

The first argument is a jQuery-special XMLHttpRequest object, which has a property called error that contains the function you are seeing logged to your console. The actual error that occurred during execution of your ajax call is the passed in to the error callback as the 3rd argument.

To see it, you should do something like:

$(document).ready(function(){
    $.ajax({
        type:"POST",
        url:"getStores.php",
        dataType: "json",
        success:function(data){
            results(data);
        },
        error: function(jqXHR, text, error) {
            console.log(error);    
        }
    });
});

That will get you closer to the real problem.

UPDATE:

Please show the output from your php script. It may be that it is not returning valid json. As noted in the php docs ( http://php.net/manual/en/function.json-encode.php ), [json_encode] only works with UTF-8 encoded data.

You might also check in to json_last_error ( http://php.net/manual/en/function.json-last-error.php ) to see if the encoding failed for some reason.

UPDATE 3:

It seems like your problem may be the path to the php script.

try it with:

$(document).ready(function(){
    $.ajax({
        type:"POST",
        url:"/getStores.php", // <-- notice the leading slash!!!
        //dataType: "json",
        success:function(data){
            //results(data);
            console.log(data);
        },
        error: function(jqXHR, text, error) {
            console.log(error);    
        }
    });
});

or, putting it all back together if the above logs the correct json output to the console...

$(document).ready(function(){
    $.ajax({
        type:"POST",
        url:"/getStores.php",
        dataType: "json",
        success:function(data){
            results(data);
        },
        error: function(jqXHR, text, error) {
            console.log(error);    
        }
    });
});

Upvotes: 2

Related Questions