<?php class Model_Ajax extends Model { function __construct() { parent::Model(); $this->load->database(); $this->_city_table = "cities"; } function get_cities_in_state($state_id) { $this->db->where('state_id', $state_id); return $this->db->get($this->_city_table)->result(); } }
<?php if (! defined('BASEPATH')) exit('No direct script access'); class Ajax extends Controller { //php 5 constructor function __construct() { parent::Controller(); } //php 4 constructor function Ajax() { parent::Controller(); } function get_city() { // Load location model $this->load->model('model_ajax'); // Which state to load? $state_id = $this->input->post('state_id'); $data['cities'] = $this->model_ajjax->get_cities_in_state($state_id); $this->load->view('city_list', $data); } }
<select name="city"> <?php foreach($cities as $city) : ?> <option value="<?php echo $city->id; ?>"><?php echo $city->city_name; ?></option> <?php endforeach; ?> </select> </div>
<?php if (! defined('BASEPATH')) exit('No direct script access'); class Cities extends Controller { //php 5 constructor function __construct() { parent::Controller(); } //php 4 constructor function Cities() { parent::Controller(); } function index() { $this->load->helper('url'); $this->load->view('cities_view'); } }
<html> <head> <script language="javascript" src="http://code.jquery.com/jquery-1.4.4.js"></script> </head> <body> <select name="state" id="selectstate"> <option value="1">State 1</option> <option value="2">State 2</option> <option value="3">State 3</option> <option value="4">State 4</option> </select> <div id="citieswrapper"> </div> <script type="text/javascript"> $("#selectstate").bind("change",function() { $("#citieswrapper").load("ajax/get_city", {state_id: $(this).val()}); //alert('go'); } ); </script> </body> </html>
danhnguyen223
0 chủ đề
0 bài viết
<?php class Model_Ajax extends Model { function __construct() { parent::Model(); $this->load->database(); $this->_city_table = "cities"; } function get_cities_in_state($state_id) { $this->db->where('state_id', $state_id); return $this->db->get($this->_city_table)->result(); } }<?php if (! defined('BASEPATH')) exit('No direct script access'); class Ajax extends Controller { //php 5 constructor function __construct() { parent::Controller(); } //php 4 constructor function Ajax() { parent::Controller(); } function get_city() { // Load location model $this->load->model('model_ajax'); // Which state to load? $state_id = $this->input->post('state_id'); $data['cities'] = $this->model_ajjax->get_cities_in_state($state_id); $this->load->view('city_list', $data); } }<select name="city"> <?php foreach($cities as $city) : ?> <option value="<?php echo $city->id; ?>"><?php echo $city->city_name; ?></option> <?php endforeach; ?> </select> </div><?php if (! defined('BASEPATH')) exit('No direct script access'); class Cities extends Controller { //php 5 constructor function __construct() { parent::Controller(); } //php 4 constructor function Cities() { parent::Controller(); } function index() { $this->load->helper('url'); $this->load->view('cities_view'); } }<html> <head> <script language="javascript" src="http://code.jquery.com/jquery-1.4.4.js"></script> </head> <body> <select name="state" id="selectstate"> <option value="1">State 1</option> <option value="2">State 2</option> <option value="3">State 3</option> <option value="4">State 4</option> </select> <div id="citieswrapper"> </div> <script type="text/javascript"> $("#selectstate").bind("change",function() { $("#citieswrapper").load("ajax/get_city", {state_id: $(this).val()}); //alert('go'); } ); </script> </body> </html>