Search with Pagignation |
Hi,
I am trying to make a search with pagignation . And i already make it . But pagignation its not working properly. For pagignation i follow this tutorial :https://ellislab.com/codeigniter/user-guide/libraries/pagination.html If i in second page (with pagignation ) and then try to back in 1st page (by clicking pagignation number) . Then its shows me all result again . Also url is showing /10 . I think url need to show this with my search query . So, in future anyone can use this url. I am new with codeigniter. And search lot in google . Please any help will highly appreciate. Best Regards
I've had the exact same problem! My implementation was that search terms are passed through the URL using GET parameters, and using $config['suffix'] I could pass these values through pagination. For the first link, you will need to use $config['first_url'] to pass the variables through as the first link is not affected by the suffix config.
See http://stackoverflow.com/questions/53846...parameters for more information.
Hello , advoor
Sorry ,, Still its not works .. In my case , i have always search_result/10 . Its never takes suffeix.. See my controller : public function search_result() { $config['per_page'] = 1; $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0; $keyword = $this->input->post('search'); // $num_rows = count($this->productos_model->get_search($config["per_page"], $page, $keyword)); $config['base_url'] = base_url() . 'search/search_result/'; $config['total_rows'] = $this->productos_model->get_search_num_rows($keyword); $config["uri_segment"] = 3; $this->pagination->initialize($config); $data["links"] = $this->pagination->create_links(); $data["results"] = $this->productos_model->get_search($config["per_page"], $page, $keyword); $this->load->view('template/template', $data); } Thanks for your time again..
01-30-2015, 08:10 AM
(This post was last modified: 01-30-2015, 08:11 AM by advoor. Edit Reason: extra ' in the code )
You must use the configuration options before you initialise the pagination: e.g. my config is
PHP Code: $config['suffix'] = '/filter?start_date='.$search_start_date.'&end_date='.$search_end_date; Hope that helps. (01-30-2015, 08:10 AM)advoor Wrote: You must use the configuration options before you initialise the pagination: e.g. my config is I have some config set up. As you saw my code . But how did you set up this two config option ['suffix'] and ['first_url'] in my url never get filter?start_date , or any thing . and ,its always shows me search_result/10 then search_result/20 I know something i did wrong.. But can't figure out. thanks (01-30-2015, 08:22 AM)code_help Wrote: I have some config set up. As you saw my code . But how did you set up this two config option ['suffix'] and ['first_url'] Did you put the config options just after PHP Code: $config["uri_segment"] = 3; The dates are just values passed through the URL : PHP Code: $search_start_date = $this->input->get('start_date');
Yes. I have this ($config["uri_segment"] = 3; )set in config option . and then i add your two new code ,, But nothing change.
I follow https://www.youtube.com/watch?x-yt-ts=14...14404#t=40 this tutorial . And now its working fine . But they did with database . So, all query is saved in database. Its fine but for large side , i think session is good idea. But still i don't get codeigniter session class and other stuff. Thanks again for your time.. If you know, any tutorial regarding this, please let me know . Have a nice day.
Hi there
I use DataTables for all my table usages in CodeIgniter, basically I dump my sql result to tables by using table helper class to VIEW then in view I simply make that table as instance of DaTaTables then you will see it all set. Table is auto paginated with global smart search for all column fields. For example, i have a query for all customers then lets say $customer_table as passing param to view and make sure you set ID in table tag , assume it is #customer_table. This is the magic on VIEW to turn it to DataTables $('#customer_table').DataTable(); That is it! ...If you want more customized layout on your table then read this https://datatables.net/ Hope this help
Thanks Dbui for sharing this link.
Just have two question before using this awesome plugin, : My search result is not table formatted so then is it worked? And my result will show in another page after submitted submit button. And i have 3 join sql for search result. Thanks again. |
Welcome Guest, Not a member yet? Register Sign In |