How to fetch title of an item from a database and send it to the header template in CodeIgniter
Try this
- Model is changed
- Controller is changed.
In Model
function get_card($card){ $query = $this->db->query("SELECT * FROM table_name WHERE creditcards = '$card' "); $result = $query->result_array(); $count = count($result); # New if(empty($count)){ # New return FALSE; } elseif($count > 1){ # New return 0; } else{ return $result; }}
In Controller
public function show($card){ $result = $this->Listing_model->get_card($card); # Changed if($result == FALSE){ # New echo "No Data Found"; } elseif($result == 0){ # New echo "Multiple Data Found"; } else{ $data["page_title"] = $result[0]['field_name']; # Changed $this->load->view('includes/header',$data); # Changed $this->load->view('listings/listing_card',$data); $this->load->view('includes/footer'); }}
In View
<?php echo (!empty($page_title)) ? $page_title : ''; ?> # Changed
Create a base controller. The default location for this is application/core/MY_Controller.php =>
this can be changed via the config.By using $this->site_data
you can add variables in your base class and use them in every controlle/view
class MY_Controller extends CI_Controller{ function __construct() { parent::__construct(); $this->load->database(); $this->load->model('your model'); $result = $this->Listing_model->get_card($card); $this->site_data['query']=$result; $this->site_data_header["page_title"] = $result['get the property you want'];//this is possible, as get_card returns 1 result }}class YourClass extends MY_Controller{ function __construct() { parent::__construct(); } public function show($card = NULL) { //you don't need to split the variables //for header and the rest $this->load->view('includes/header',$this->site_data_header); $this->load->view('listings/listing_card',$this->site_data); $this->load->view('includes/footer'); }}
And I think your get_where is wrong:
$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);
your limit is 0
function get_card($card = FALSE){ $query = $this->db->get_where('creditcards', array('slug' => $card), 1,0);//limit 1 offset 0 return $query->result();}
access the data in your view
<title><?php echo (!isset($page_title) ? '' : $page_title) ?></title>
A simple example:
Controller
$query = $this->Listing_model->get_card($card);$query = $query->row();$header["page_title"] = $query->title;
View
<title><?php echo (!isset($page_title) ? '' : $page_title) ?></title>