• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
getJSON not working correctly with codeigniter

#1
[eluser]Unknown[/eluser]

I am trying to implement AJAX call method into my website using codeigniter, the reason why i want to use AJAX so i can get live updates from the database
The click button works and displays all of the JSON data but the issue is when i try and display a specific array it does not recognize it, it seems to be iterating through every single character.

Things i have done to try and work it out

i have alerted the datatype and found out it was a string

i have managed to get ajax to work in regular PHP rather then codeigniter so their is nothing wrong with the database

I have also tried to use jQuery.parseJSON so i can force it to be json but then the script did not run

I used JSONlint and apprently its a valid JSON

Consolelog

Code:
[
[
    {
        "id": "1",
        "postcode": "NW6",
        "imgurl": "hello.jpeg",
        "from_user": "henny",
        "created_at": "2013-03-18 23:03:00"
    },
    {
        "id": "2",
        "postcode": "NW2",
        "imgurl": "test.jpeg",
        "from_user": "belly",
        "created_at": "2013-03-15 23:03:00"
    }
]
]

Controller

Code:
public function insertJSON()
{
    $this->load->model("values");
    $queryresults = $this->values->getDb();

    $arrays = array($queryresults);

    echo json_encode($arrays);  
}

View

Code:
[removed]

  $('#getdata').click(function (data) {

      $.ajax({

          url: '<?php echo base_url().'index.php/welcome/insertJSON';?>',
          type: 'POST',
          cache: 'false',
          datatype: 'json'

      }).done(function (data) {

         alert(data);

      });

  });

[removed]
json_encode

Code:
[
[
    {
        "id": "1",
        "postcode": "NW6",
        "imgurl": "hello.jpeg",
        "from_user": "henny",
        "created_at": "2013-03-18 23:03:00"
    },
    {
        "id": "2",
        "postcode": "NW2",
        "imgurl": "test.jpeg",
        "from_user": "belly",
        "created_at": "2013-03-15 23:03:00"
    }
]
]

Any help would be appreciated


Messages In This Thread
getJSON not working correctly with codeigniter - by El Forum - 03-18-2013, 06:33 PM
getJSON not working correctly with codeigniter - by El Forum - 03-18-2013, 09:04 PM
getJSON not working correctly with codeigniter - by El Forum - 03-18-2013, 09:13 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.