StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15468103
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2013-03-18T00:41:41.413
FavoriteCount
0
LastActivityDate
2013-03-18T00:49:59.527
LastEditDate
2013-03-18T00:49:59.527
LastEditorUserId
741156
OwnerUserId
741156
ParentId
15467947
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
So. if you want to echo out a JSON obj that can be pick it up using ajax, then u need to make sure that the output mime-type of your page can serve JSON data. also notice that u cannt echo anything else with the json data that u want out of ur function. as i can see in your code u echo json then load a view ! u need to split that into 2 separate pages Fix: <pre><code>public function _JSON() { $this->load->model("values"); $queryresults = $this->values->getDb(); $arr = array(); foreach($queryresults as $row) { $arr[] = $row->postcode; } return $arr; } public function json_body(){ $this->load->view('answer',array('data'=>$this->_JSON())); } public function getJSON(){ $this->output ->set_content_type('application/json') ->set_output(json_encode($this->_JSON())); } ///note that $this->_JSON() now return ur $arr so u can use it in many methods. </code></pre> now to load page u can go to <code>/json_body</code> 'rename it as u want' and js should be <pre><code><script> $.post('<?=base_url('welcome/getJSON')?>', function(data) { alert(data); }); </script>  </code></pre> NOTE: function getJson get use the power of CI Output class to set the mime-type of page and make sure this array is the only output. this is not a must but its just best practice. if u want u can relapce all 3 lines with simple <code>echo json_encode($this->_JSON());</code> and it will work too !
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POTrouble getting getJSON to work with codeigniter
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USZalaboza
UserOwnerUserId
1. USZalaboza
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.