[eluser]C_Line[/eluser]
i wan to register province and city
like this
//////////////////////////////////////////////////////////////////////////////////////
Code:
<!--controller-->
function daftar()
{
$this->load->view('header');
$this->load->view('frame_kiri');
$this->load->model('Query_barang','',TRUE);
$data['prop'] = $this->Query_barang->reg_prop();
$data['kota'] = $this->Query_barang->reg_kota();
$this->load->view('registrasi',$data);
}
<!--model-->
function reg_prop()
{
$prop = $this->db->query("select distinct(Propinsi) from tarif_kirim order by Propinsi ASC")->result();
return $prop;
}
function reg_kota()
{
$propi = $this->input->post('propinsi');
$kota = $this->db->query("select kota from tarif_kirim where Propinsi='$propi'")->result();
return $kot;
}
<!--view-->
<select name="propinsi" id="propinsi">
<?php
foreach($prop as $kue)
{
?>
<option value="<?php echo $kue->Propinsi; ?>"><?php echo $kue->Propinsi; ?></option>
<?php
}
?>
</select>
Kota
<select name="kota_user">
<?php
foreach($kota as $kues)
{
echo "<option value='". $kues->kota . "'>" . $kues->kota . "</option>";
}
?>
</select>
[removed]
function come()
{
var el = document.getElementById('propinsi').value; // <- try to get value
document . write(el);
}
[removed]
//////////////////////////////////////////////////////////////////////////////////////
but it can't load, i dun wan use button
when i select propinsi, kota_user automatically load database and display it
help me,, thx