Getting the value of a row in CodeIgniter

Question

I am trying to get the value of a row in the database but not working out that well. I not sure if can work like this.

I am just trying to get the value but also make sure it from the group config and the key.

Model

function getTitle() {
  return $this->db->get('setting', array(
    ->where('group' => 'config'),
    ->where('key' => 'config_meta_title'),
    ->where('value'=> ) // Want to be able to return any thing in the value
  ))->row();
}

In the controller I would do this:

function index() {
  $data['title'] = $this->document->getTitle();
  $this->load->view('sample', $data);
}

possible duplicate of [Codeigniter $this->db->get(), how do I return values for a specific row?](http://stackoverflow.com/questions/8541291/codeigniter-this-db-get-how-do-i-return-values-for-a-specific-row) — Iago, Jun 15 '14 at 14:34
I only need to get the value how do I do so but still have group and key — , Jun 15 '14 at 14:34

Giacomo1968 · Accepted Answer · 2014-06-15T14:52:04.017

1

First, you have this line set to this:

$data['title'] $this->document->getTitle();

That should be an = assignment for $this->document->getTitle(); like this:

$data['title'] = $this->document->getTitle();

But then in your function you should actually return the setting value from your query with row()->setting:

function getTitle() {
  return $this->db->get('setting', array(
    ->where('group' => 'config'),
    ->where('key' => 'config_meta_title'),
    ->where('value'=> ) // Should return this row information but can not.
  ))->row()->setting;
}

But that said, I am unclear about this:

->where('value'=> ) // Should return this row information but can not.

A WHERE condition is not a SELECT. It is a condition connected to a SELECT that allows you to SELECT certain values WHERE a criteria is met. So that should be set to something, but not really sure what since your code doesn’t provide much details.

edited Jun 15 '14 at 14:52

answered Jun 15 '14 at 14:44

Giacomo1968

25,759
11
71
103

what do I put where the value is to be able to get what's in that only – Jun 15 '14 at 14:50
“what do I put where the value is to be able to get what's in that only” Whatever value you want to check against that is in your database. Do you know what this value is? – Giacomo1968 Jun 15 '14 at 14:52
if I do this ->select('value') and remove this "=>" should that return what's in that column. – Jun 15 '14 at 15:03

score 0 · Answer 2 · answered Jun 17 '14 at 05:30

Found Solution Working Now. For Getting Single Item From Database In Codeigniter

Loading In Library

function getTitle($value) {
   $this->CI->db->select($value);
   $this->CI->db->where("group","config");
   $this->CI->db->where("key","config_meta_title");
   $query = $this->CI->db->get('setting');
   return $query->row()->$value;
}

Or Loading In Model

function getTitle($value) {
   $this->db->select($value);
   $this->db->where("group","config");
   $this->db->where("key","config_meta_title");
   $query = $this->db->get('setting');
   return $query->row()->$value;
}

Getting the value of a row in CodeIgniter

2 Answers2