Welcome Guest, Not a member yet? Register   Sign In
passing name instead of id
#18

Your controller has this line:
PHP Code:
$config["total_rows"] = $this->Model_movie_genre->movies_by_genre($genre_type); 

The model function:
PHP Code:
public function movies_by_genre($genre_type)
{
    $query $this->db->query("SELECT * FROM movies_info WHERE movie_genre=? ORDER BY movie_id DESC", array('movie_genre'=>$genre_type));
    return $query->result_array();

This function always returns an array (an empty array if there are no results). Which is wrong, because $config['total_rows'] must be a numeric value (0 or greater) to make the pagination work.

Create a new function in the model:
PHP Code:
public function movie_count($genre_type)
{
  return $this->db->where('movie_genre'$genre_type)->count_all_results('movies_info');


In the controller:
PHP Code:
$config["total_rows"] = $this->Model_movie_genre->movie_count($genre_type); 
Reply


Messages In This Thread
passing name instead of id - by manigopal - 10-23-2019, 08:39 PM
RE: passing name instead of id - by Wouter60 - 10-24-2019, 05:05 AM
RE: passing name instead of id - by manigopal - 10-24-2019, 05:31 AM
RE: passing name instead of id - by Wouter60 - 10-24-2019, 06:26 AM
RE: passing name instead of id - by manigopal - 10-25-2019, 10:26 AM
RE: passing name instead of id - by manigopal - 10-25-2019, 07:58 PM
Added Pagination - by manigopal - 10-25-2019, 11:59 PM
RE: passing name instead of id - by Wouter60 - 10-26-2019, 01:30 AM
RE: passing name instead of id - by manigopal - 10-26-2019, 01:44 AM
RE: passing name instead of id - by Wouter60 - 10-26-2019, 01:58 AM
RE: passing name instead of id - by manigopal - 10-26-2019, 02:01 AM
RE: passing name instead of id - by Wouter60 - 10-26-2019, 02:30 AM
RE: passing name instead of id - by manigopal - 10-26-2019, 07:18 AM
RE: passing name instead of id - by Wouter60 - 10-26-2019, 08:48 AM
RE: passing name instead of id - by manigopal - 10-26-2019, 09:02 AM
RE: passing name instead of id - by manigopal - 10-26-2019, 10:24 PM
RE: passing name instead of id - by manigopal - 10-27-2019, 01:07 AM
RE: passing name instead of id - by Wouter60 - 10-27-2019, 04:48 AM
RE: passing name instead of id - by manigopal - 10-27-2019, 07:16 AM
RE: passing name instead of id - by Wouter60 - 10-27-2019, 07:44 AM
RE: passing name instead of id - by manigopal - 10-27-2019, 08:04 AM
RE: passing name instead of id - by manigopal - 10-28-2019, 03:27 AM
RE: passing name instead of id - by Wouter60 - 10-28-2019, 10:50 AM
RE: passing name instead of id - by manigopal - 10-28-2019, 10:21 PM
RE: passing name instead of id - by wdeda - 12-28-2019, 05:31 PM



Theme © iAndrew 2016 - Forum software by © MyBB