Error with JSON + Jquery Ajax + PHP + MYSQL

Question

I have the followin PHP file (a function of it):

public function get_hotels(){
   $hoteles = new HotelModel();
   $query = "SELECT * FROM hotel";
   $hoteles = $hoteles->execute_query($query);
   echo json_encode($hoteles);
}

And this is my jQuery script:

$.ajax({
   type: "POST",
   url: "index.php?controller=ExcursionTypes&action=get_hotels",
   dataType:"json",
   success: function(response){
    alert(typeof (response[0].hotel_name));
    //$("#pickups_fields").html(response[0].hotel_name);
   },
   error:function(response){
    alert("ERROR");
   }
});

Firebug throws me this JSON:

[{"id_hotel":"1","hotel_name":"Apt.Playa del Ingles", "hotel_phone":"928762629",
"hotel_corporation_id":"1","hotel_state_id":"1"},
{"id_hotel":"2","hotel_name":"LZ",
"hotel_phone":"928762629","hotel_corporation_id":"1", 
"hotel_state_id":"2"}]

I want to read both hotel_name fields and I can't.

I'm sure you're giving me the solution or a link to solve it.

Although I'm looking for it too.

Michał Rybak · Accepted Answer · 2013-10-18 10:14:49Z

1

Javascript is case sensitive, so you should write dataType, not datatype.

JSON that you get as a response is correct and response[0].hotel_name would work, but because you mistyped dataType, the response is not parsed as a JSON and therefore you can't access it the way you did.

answered Oct 18, 2013 at 10:14

Michał Rybak

8,7063 gold badges44 silver badges55 bronze badges

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

1 Comment

Subiendo Over a year ago

I've change the datatype into dataType and it's still throwing me the string "ERROR" in the "error:" property

Chris Pickford · Accepted Answer · 2013-10-18 10:18:03Z

0

Try iterating over the objects in response, like this:

$.ajax({
    type: "POST",
    url: "index.php?controller=ExcursionTypes&action=get_hotels",
    dataType:"json",
    success: function(response){
        $.each(response, function(i, hotel) {
            alert(typeof (hotel.hotel_name));
            //$("#pickups_fields").html(hotel.hotel_name);
        });
    },
    error:function(response){
        alert("ERROR");
    }
});

answered Oct 18, 2013 at 10:18

Chris Pickford

9,0606 gold badges50 silver badges76 bronze badges

8 Comments

Chris Pickford Over a year ago

Didn't notice the dataType issue, so amended that. I still think this is the approach OP should take though.

Subiendo Over a year ago

I've change the datatype into dataType and it's still throwing me the string "ERROR" in the "error:" property

Chris Pickford Over a year ago

Try using $.getJSON() instead and see if that works.

Subiendo Over a year ago

it seems that the dataType:"json", line contains an error because when I comment it it shows me what I code in the success statement

Michał Rybak Over a year ago

that would mean that the response couldn't be parsed as JSON, which is strange, because the JSON you've posted is correct.

|

Poojan Dave · Accepted Answer · 2013-10-18 10:24:36Z

0

$.ajax({
    type: "POST",
    url: "index.php?controller=ExcursionTypes&action=get_hotels",
    dataType:"json",
    success: function(response){
        for(key in response) {
            alert(typeof (response.hotel_name[key]));
        });
    },
    error:function(response){
        alert("ERROR");
    }
});

answered Oct 18, 2013 at 10:24

Poojan Dave

1196 bronze badges

Collectives™ on Stack Overflow

Error with JSON + Jquery Ajax + PHP + MYSQL

3 Answers 3

1 Comment

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related