CodeIgniter from Scratch: Search Results without Query Strings

More tutorial pleaseT.T this is a very good tutorial

suppose if I get an array as POST input, i am unable to loop through it and get all the array values and to store into query_array (i.e., store array within array).

The snippets below:
$query_array = array(
‘gender’ => $this->input->post(‘gender’),
‘minage’ => $this->input->post(‘minage’),
‘maxage’ => $this->input->post(‘maxage’),
‘Citizenship’ => $this->input->post(‘citizenship’), // checkboxes with name citizenship[]
);

This returns only last stored array value in Citizenship.

The output array:

Array ( [gender] => 1 [minage] => 18 [maxage] => 24 [Citizenship] => 2 )
makes the query string as:

&gender=1&minage=18&maxage=24&Citizenship=2
But, my requirement is to get all the values of ‘Citizenship’ array instead of last stored value.

The output required to make query string:

Array ( [gender] => 1 [minage] => 18 [maxage] => 24 [Citizenship] => 2 [Citizenship] => 4 [Citizenship] => 6 )

Any help appreciated.

Thanks

I have a problem,

Data which saved into database is different from the tutorial.
“&” is saved to be &

example :
“title=ACADEMY&category=Animation&length_comparison=gt&length=”
should be
“title=ACADEMY&category=Animation&length_comparison=gt&length=”

what shall I do?

Thank you and regards,
Sigit

More tutorial please ;) ;)

Worst tutorial I have seen on this website so far….. why database??

i keep getting these error

Fatal error: Call to undefined method CI_Input::load_query() in C:\wamp\www\cituto\ci_day17\application\controllers\films.php on line 19

I really need your help. I was introduced to codeigniter recently and find this tutorial really useful. but I’m now puzzled with the following error even if I’ve followed everything as taught in the video
I get the error when implementing the search facility
Fatal error: Call to undefined method CI_Input::load_query() in /var/www/html/dev/TM/codeigniter/application/controllers/tasks.php on line 27

I’m new to codeigniter too but from what i can see The CI_Input::load_query() error is due to there being no input library in the system folder to extend from. Although it’s in the official docs.

Just put the methods in your model and call $this->Form_model->load_query() instead

hii Burak ,

your tutorials show very details explanation and also easy to understand , amazing for me .

before that , i want to say thank you so much…

Question :
========
I had a problem on extending the input class (or libraries) , especially on save_query()

browser display warning:
=====================
Fatal error: Call to undefined method CI_Input::load_query() in C:\xampp\htdocs\ci\application\controllers\films.php on line 23

MY_Input.php (on, application/libraries/ )
===========
class MY_Input extends CI_Input{

function save_query($query_array)
{
//print_r($query_array);

$CI =& get_instance();

$CI->db->insert(‘ci_query’,
array(‘query_string’ => http_build_query($query_array)));

return $CI->db->insert_id();
}

}

films.php (on, application/controllers/ )
===========
function search()
{
$query_id = $this->input->save_query($query_array);
}

regards

deniel

Also I forgot to mention that instead of extending the input class , the functions are in the model and I am calling them using $this->name_model->load_query($query_id).

Ok this is my solution with sessions instead databases.

In the Films controller:
———————–

function display($query_id = ”, $sort_by = ‘title’, $sort_order = ‘asc’, $offset = 0) {

//The rest of the code
//$this->Film_model->load_query($query_id); // Old system with the database
$this->_load_session($query_id);

// Here more code…
}

The search function in the class controller:
————————–

function search() {
// Old code here…
$query_search = $this->_save_session($query_array);
redirect(“films/display/search”);
}

Save session method:
————————–
function _save_session($query_array) {
$this->session->set_userdata(‘search’, http_build_query($query_array));
}

Load session method:
————————–
function _load_session($search_query) {
if(!is_null($search_query) && $search_query == “search”) {

$search = $this->session->userdata(‘search’);

if(isset($search)) {
parse_str($search, $_GET);
}
}
}
——————————–
Maybe is not the best option but work well, and is another alternative to store the query string.

buen tutorial

can any one tell about the below query?
after inserting the values in to db i want to dispaly a message in the view as “inserted successfully”?
how it is possible in codeigniter.

hi all, ia m using codeigniter to insert form values into db, after inserting the form values,i need to show a success message in the same view..
any help will be appreciated.

I have a problem when running films/display ,someone to help me

l made MY_Input class in application/core/MY_Input.php
the error is shown like below:

A PHP Error was encountered

Severity: Notice

Message: Undefined offset: 0

Filename: core/MY_Input.php

Line Number: 12 (the error in this line if ($rows[0]){ )

A Database Error Occurred

Error Number: 1054

Unknown column ’0′ in ‘order clause’

SELECT `FID`, `title`, `category`, `length`, `rating`, `price` FROM (`film_list`) ORDER BY `0` asc LIMIT 20, 1

Filename: C:wampwwwcodeignitersystemdatabaseDB_driver.php

Line Number: 330

this my code source of MY_Input class
db->insert(‘ci_query’,array(‘query_string’ => http_build_query($query_array)));

return $CI->db->insert_id();

}

function load_query($query_id){

$CI =& get_instance();

$rows = $CI->db->get_where(‘ci_query’,array(‘id’=>$query_id))->result();

if ($rows[0]){

parse_str($rows[0]->query_string,$_GET);

} } }

this is my controller films

‘ID’,

‘title’ => ‘Title’,

‘category’ => ‘category’,

‘length’ => ‘length’,

‘rating’ => ‘rating’,

‘price’ => ‘price’

);

$this->input->load_query($query_id);

// $this->film_model->load_query($query_id); // Old system with the database

//$this->_load_session($query_id);

$query_array = array(

‘title’ => $this->input->get(‘title’),

‘category’ => $this->input->get(‘category’),

‘length_comparison’ => $this->input->get(‘length_comparison’),

‘length’ => $this->input->get(‘length’)

);

// print_r($query_array);return;

$this->load->model(‘film_model’);

$results = $this->film_model->search($query_array,$limit, $offset,$sort_by,$sort_order);

$data['films'] = $results['rows'];

$data['num_results'] = $results['num_rows'];

$this->load->library(‘pagination’);

$config = array();

$config['base_url'] = site_url(“films/display/$sort_by/$sort_order”);

$config['total_rows'] = $data['num_results'];

$config['per_page'] = $limit;

$config['num_links'] = 15;

$config['uri_segment'] = 5;

$this->pagination->initialize($config);

$data['pagination'] = $this->pagination->create_links();

$data['sort_by'] = $sort_by;

$data['sort_order'] = $sort_order;

$data['category_options'] = $this->film_model-> category_options();

$this->load->view(‘films’,$data);

}

function search(){

$query_array = array(

‘title’ => $this->input->post(‘title’),

‘category’ => $this->input->post(‘category’),

‘length_comparison’ => $this->input->post(‘length_comparison’),

‘length’ => $this->input->post(‘length’),

);

$query_id = $this->input->save_query($query_array);

redirect(“films/display/$query_id”);

}

}