StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POget data from database using AJAX in codeigniter
primarykey
Id
19345226
data
AcceptedAnswerId
0
AnswerCount
4
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-10-13T12:27:54.603
FavoriteCount
0
LastActivityDate
2017-01-27T08:06:30.380
LastEditDate
2013-10-14T10:37:28.123
LastEditorUserId
2118839
OwnerUserId
2118839
ParentId
0
PostTypeId
1
Score
0
ViewCount
13278
LastEditorDisplayName
text
Body
I'm trying to get data from my database to my view using ajax in codeigniter, but I can't get it working. I think something is going wrong with passing the grade_id to my model function. AJAX: <pre><code><script type="text/javascript"> $(document).ready(function(){ $('#grades').change(function(){ $("#classes > option").remove(); var grade_id = $('#grades').val(); $.ajax({ type: "POST", url: "<?php echo base_url(); ?>index.php/login/get_classes/"+grade_id, data: {gradeid:grade_id}, success: function(classes) { $.each(classes,function(id,name) { var opt = $('<option />'); opt.val(id); opt.text(name); $('#classes').append(opt); }); } }); }); }); </script> </code></pre> CONTROLLER: <pre><code> function get_classes($gradeid) { $this->load->model('school_info_model'); header('Content-type: application/json'); if ($query = $this->school_info_model->get_all_classes($gradeid)) { echo json_encode($query); } else { redirect('login/loginform'); } } </code></pre> MODEL: <pre><code>function get_all_classes($gradeid) { $this->db->where('grade_id', $gradeid); $query = $this->db->get('classes'); if($query->result()){ $result = $query->result(); foreach($result as $row) { $options[$row->id] = $row->name; } return $options; } } </code></pre> EDIT: I updated my code it is working now except for 2 things, I keep getting an error. ERROR: <blockquote> A PHP Error was encountered Severity: Warning Message: Invalid argument supplied for foreach() Filename: helpers/form_helper.php Line Number: 331 </blockquote> And When I load the page for the first time the input field for classes is empty because it only activates the AJAX if the value of grades changes. 
Tags
<ajax><codeigniter>
Title
get data from database using AJAX in codeigniter
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser2118839
UserOwnerUserId
1. USuser2118839
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. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COWhat error does it return?
 singulars
 PostPostId
 POget data from database using AJAX in codeigniter
 UserUserId
 USWebNovice

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.