+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: [Help] with <select> auto reload (/showthread.php?tid=52976)
Pages:
1
2
[Help] with <select> auto reload - El Forum - 07-04-2012
[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
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]marjune[/eluser]
the code above are in the views?
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]C_Line[/eluser]
yea, this code in view
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]marjune[/eluser]
well the propper of doing this code youre talking about is....
Controller
Code:
function functionanem(){
$result['prop'] = $this->modelname->modelfinction("select distinct(Propinsi)
from tarif_kirim
order by Propinsi ASC");
$this->load->view('yourview',$result);
}view
Code:
<select name=“propinsi” id=“propinsi”>
<?php foreach($prop as $kue){ ?>
<option value=”<?php echo $kue->Propinsi; ?>”><?php echo $kue->Propinsi; ?></option>
<?php }?>
</select>[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]C_Line[/eluser]
yea, i'm too lazy to call function from model XD
but that didn't answer my question above T.T
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]dnc[/eluser]
[quote author="C_Line" date="1341461651"]yea, i'm too lazy to call function from model XD
but that didn't answer my question above T.T[/quote]
First off, you will get better replies if you wrap your code in code tags.
Code:
I am a codeSecondly, your database query should not be in your view. It should be in a model or at the very least a controller.
No one is going to argue with you, or try to help you if you are "too lazy" to at least try to code correctly.
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]C_Line[/eluser]
okay okay, i fix it
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]C_Line[/eluser]
i done revised
[Help] with <select> auto reload - El Forum - 07-04-2012
[eluser]marjune[/eluser]
yes because the second select box which is kota depends from the first select box..
you're probably need a jquery to do it.
[Help] with <select> auto reload - El Forum - 07-05-2012
[eluser]C_Line[/eluser]
can't use ajax ? i dun know about jquery