return String from database with CodeIgniter

Question

This is my Model :

function getAvenuName($id) {
        $this->db->distinct();
        $this->db->select('admin.username');
        $this->db->from('personal_closest');
        $this->db->join('admin', 'admin.id = personal_closest.avenu_id', 'left');
        $this->db->where('personal_closest.avenu_id', $id);
        $query = $this->db->get();
        return $query->result();        
    }

This is my Controller :

foreach ($listofcloset['postByUser'] as $key => $value) { 
            $listofcloset['postByUser'][$key]['calculatetime']   =  $this->calculatetime(strtotime($value['postdatetime']));
            $listofcloset['postByUser'][$key]['countcomments']   =  $this->countcomments($value['id']); 
            $listofcloset['postByUser'][$key]['comments']        =  $this->comments->sltpostcomments($value['personal_closest_id']); 
            $listofcloset['postByUser'][$key]['countCloset']     =  $this->closet->countCloset($value['id']);            
            $listofcloset['postByUser'][$key]['givencool']       =  $this->checkCoolIsGiven($this->session->userdata('user_id'),$value['user_id'],$value['personal_closest_id']);
            $listofcloset['postByUser'][$key]['givencloset']     =  count($this->closet->selectIdbycloset($this->session->userdata('user_id'),$value['user_id'],$value['personal_closest_id']));
            if (empty($listofcloset['postByUser'][$key]['username'])){
                $listofcloset['postByUser'][$key]['username'] = $this->personal_closest->getAvenuName($value['avenu_id']);
            }
        }

When i go to take the username i've a problem with array to string conversion. I'm trying to found a solution to take just the String instaed the array.

That's the result:

[username] => Array
            (
                [0] => stdClass Object
                    (
                        [username] => USER1
                    )

            )

try replacing $query->result() with $query->result_array() — FuzzyTree
– FuzzyTree, Commented Apr 27, 2015 at 14:44

Jeremy Jackson · Accepted Answer · 2015-04-27 15:55:01Z

5

This should get it :)

function getAvenuName($id) {
    $this->db->distinct();
    $this->db->select('admin.username');
    $this->db->from('personal_closest');
    $this->db->join('admin', 'admin.id = personal_closest.avenu_id', 'left');
    $this->db->where('personal_closest.avenu_id', $id);
    $query = $this->db->get();
    $result = $query->row();
    return $result->username;  
}

edited Apr 27, 2015 at 15:55

answered Apr 27, 2015 at 15:51

Jeremy Jackson

2,25718 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy Jackson Over a year ago

I changed result to $result to avoid confusion for anyone else that may need this. And you're very welcome. I'm glad I could help you!

user3232286 · Accepted Answer · 2015-04-27 14:47:44Z

0

Use following code you will get direct array

function getAvenuName($id) {
    $this->db->distinct();
    $this->db->select('admin.username');
    $this->db->from('personal_closest');
    $this->db->join('admin', 'admin.id = personal_closest.avenu_id', 'left');
    $this->db->where('personal_closest.avenu_id', $id);
    $query = $this->db->get();
    return $query->row_array();        
}

answered Apr 27, 2015 at 14:47

user3232286

1 Comment

davidev Over a year ago

This is good but print me always an array and i need a String [username] => Array ( [username] => Mywardrobe ) Infact in the View i got this error: Severity: Notice Message: Array to string conversion

Collectives™ on Stack Overflow

return String from database with CodeIgniter

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related