Soy un estudiante que está practicando Codeigniter. Este es el guión que he formado.
$(documento).listo(función () { $('#hiddenDO').each(function () { $('#displayoffice').val($("#hiddenDO option:selected").val()); $.ajax({ type: "GET", url: '<?= site_url('client/displayoffice') ?>', data: {"msg":msg}, dataType:"json", success: function (data) { console.log(data); } }); return false; });}
Controlador
public function displayoffice() { $data = $this->input->post(); $result['hiddenDO'] = $data; echo json_encode(array($result)); exit(0); }y mi modelo
función filtrarOficina() {
$data = '3'; //In this part I want to call the value to filter $query=$this->db->query("SELECT bi_emplname, bi_empfname, bi_emppic FROM `tblemployee` INNER JOIN `tbl_office` ON ji_off_id=off_id INNER JOIN `tbl201_basicinfo` ON bi_id=ji_bi_id WHERE ji_off_id='$data'"); return $query->result_array(); }