StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>It's easier if you use <a href="http://jquery.com/" rel="nofollow noreferrer">jQuery</a>.</p> <p>Here is an example.</p> <p>In the main view you would have some like this:</p> <pre><code><html> <head> <script type="text/javascript" src="jquery.js"></script> </head> <body> <script> $('#dropdown1').change(function(e) { $('#dropdown2').load('some_controller/some_function/'+this.value); }); </script> <select name="dropdown1" id="dropdown1"> <option value="1">option 1</option> <option value="2">option 2</option> </select> <select name="dropdown2" id="dropdown2"></select> </body> </code></pre> <p>You are saying in the script that whenever the dropdown change its value, you call (in Ajax) a controller function with the id in its arguments. Don't forget to include jQuery file.</p> <p>In the controller, you would have this:</p> <pre><code><?php class some_controller extends Controller { function some_function($id) { $this->load->model('some_model'); $data['options'] = $this->some_model->get_options($id); echo $this->load->view('view_dropdown2', $data, true); } } ?> </code></pre> <p>So, when this function is called, you call your model function with the dropdown id, and you echo the view with the options. You have to put the 3rd argument true, so that the view is returned as a var and not rendered.</p> <p>And in the view:</p> <pre><code><?php foreach($options->result() as $option): ?> <option value="<?php echo $option->id; ?>"><?php echo $option->title; ?></option> <?php endforeach; ?> </code></pre> <p>You are just creating the options tags because the select tag was already created in the main view.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload