lundi 18 mai 2015

filtering table results using ajax

I'm working on a php online shop website using codeigniter framework and i want to be able to filter my table results using checkboxes with ajax

view:

<input type="checkbox" name="brand" value="acer">  


<input type="checkbox" name="brand" value="lenovo">    

<input type="checkbox" name="pret" value="1000">   



 <table>
        <tbody>
        <?php foreach ($laptops_toate as $laptops_all) { ?>
            <tr>
                <td><img src="http://localhost:82/ci/images/emag/<?php echo $laptops_all->file ?>"></td>
                <td><p>Laptop <?php echo $laptops_all->brand ?> </p>
                </td>


            </tr>
        <?php } ?>
        </tbody>
    </table>  

Controller:

 public function laptops()
{

    $filter = array(
        'pret' => $this->input->get('pret'),
        'brand' =>$this->input->get('brand')
    );

    $data['laptops_toate'] = $this->emag_model->laptops_toate_grid($filter);

    $this->renders('emag/laptops', $data);
}  

model:

 public function laptops_toate_grid($filter = null){
    $this->db->select('*')
             ->from('laptop_notebook');
   // $query = $this->db->get('laptop_notebook')->result();
   // return $query;
    if($filter['brand']){
        $this->db->where('brand', $filter['brand']);
    }
    if($filter['pret']){
        $this->db->where('pret', $filter['pret']);
    }
    $query = $this->db->get()->result();

    return $query;

}

The problem is now at the ajax code, i don't know how to send the data filter to the server in order to receive the success function.




Aucun commentaire:

Enregistrer un commentaire