Welcome Guest, Not a member yet? Register   Sign In
Help Me... Search with dropdown menu or radio button
#1

[eluser]myrna[/eluser]
I'm making a search function.

Model

Code:
<?php
    class PencarianModel extends Model
    {    
        function PencarianModel()
        {
            parent::Model();
        }    
        
        function SearchResult($perPage,$uri,$judul)
        {
            $this->db->select('*');
            $this->db->from('tbl_master_properti');
            if(!empty($judul)) {
                $this->db->like('judul',$judul);
            }
            $this->db->order_by('id_master_properti','asc');
            $getData = $this->db->get('', $perPage, $uri);
            
            if($getData->num_rows() > 0)
                return $getData->result_array();
            else
                return null;
        }
    }
?>


controller
Code:
<?php
    class Search extends Controller
    {    
        function Search()
        {
            parent::Controller();    
        }
        
        function index()
        {
            if(isset($_POST['submit']))
            {
                $data['judul'] = $this->input->post('judul');
                $this->session->set_userdata('sess_judul', $data['judul']);
            } else {
                $data['judul'] = $this->session->userdata('sess_judul');
            }
            
            $this->db->like('judul', $data['judul']);
            $this->db->from('tbl_master_properti');
            
            $pagination['base_url']=base_url().'index.php/ulang37/index/page/';
            $pagination['total_rows']     = $this->db->count_all_results();
            $pagination['full_tag_open'] = "<p><div class=\"pagination\">";
            $pagination['full_tag_close'] = "</div></p>";
            $pagination['cur_tag_open'] = "<span class=\"current\">";
            $pagination['cur_tag_close'] = "</span>";
            $pagination['num_tag_open'] = "<span class=\"disabled\">";
            $pagination['num_tag_close'] = "</span>";
            $pagination['per_page']     = "100";
            $pagination['uri_segment'] = 4;
            $pagination['num_links']     = 4;
            
            $this->pagination->initialize($pagination);
            
            $data['ListBerita'] = $this->pencarianmodel->SearchResult($pagination['per_page'],$this->uri->segment(4,0),$data['judul']);
            $data['current'] = 'search';
            $data['content'] = 'pencarian';
            $this->load->vars($data);
            $this->load->view('container', $data);
            }
    }
?&gt;

view

Code:
<div class="clear"></div>
<div id="content_box" class="grid_24 box">
&lt;form id="form_pencarian" name="form_pencarian" method="post" action="&lt;?=base_url();?&gt;/search/"&gt;
  &lt;input name="judul" type="text" id="judul" size="30" maxlength="255" class="inputbox" value="&lt;?=$judul;?&gt;"/&gt;&nbsp;&nbsp;
  &lt;input name="submit" type="submit" id="submit" value="Cari" class="button"/&gt;
&lt;/form&gt;
<hr />
&lt;?php
    
    if(count($ListBerita) > 0) {
        foreach($ListBerita as $row)
        {
            echo "<div class=\"letter\">";
            echo "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
                <tbody>";
            echo "<tr>
                        <td width=32 align=\"center\" valign=\"middle\">&nbsp;</td>
                        <td width=500>
                        <span>". $row['pengarang'] ."</span><br/>
                        <a >".$row['id_kategori']."</a>
                        <div> ".$row['judul']."</div>
                        </td>
                </tr>";
            echo "</tbody></table>";    
            echo "</div>";
        }
        echo $this->pagination->create_links();
    } else {
        echo "<div><strong>No result.</strong></div>";
    }
?&gt;
</div>
<div class="clear"></div>
&lt;/body&gt;
&lt;/html&gt;

If I want to add a dropdown menu or radio buttons on my program. what should I add to my program?
Code:
$criteria = array();
$query = "";

$i = 0;
if (!empty($judul))
$criteria[$i++] = "judul LIKE $judul";

if (!empty($editor))
$criteria[$i++] = "editor LIKE $editor";

if (!empty($pengarang))
$criteria[$i++] = "pengarang LIKE $pengarang";

$query = $criteria[0];
for ($i = 1; $i < size($criteria) - 1; $i++)
{
$query .= " AND " + $criteria[$i];
}

echo $query;


If I want to add the code above. what must I change on the model, view and controllernya?

Thanks for your help.


Messages In This Thread
Help Me... Search with dropdown menu or radio button - by El Forum - 06-16-2010, 01:22 AM
Help Me... Search with dropdown menu or radio button - by El Forum - 06-16-2010, 06:06 AM
Help Me... Search with dropdown menu or radio button - by El Forum - 06-16-2010, 07:26 AM
Help Me... Search with dropdown menu or radio button - by El Forum - 06-16-2010, 07:56 AM



Theme © iAndrew 2016 - Forum software by © MyBB