Convert array to string MySQL query

Question

I have an array which I want to use in a query:

Array ( [0] => stdClass Object ( [followee] => 267,269,270,271,272,273,275,276,277,278,279 ) )

I'm not sure why it returns the message:

Object of class stdClass could not be converted to string.

Controller:

$data['activity'] = $this->home_model->activity($followID);

Model:

function activity($followID)
{
    $query_str = 'SELECT DISTINCT name
                    FROM place
                    WHERE userid IN ("'. implode('","', $followID) .'")';

$query = $this->db->query($query_str);

Did you check the dump? var_dump( $this->home_model->activity($followID) ); — Peon
– Peon, Commented Jul 5, 2012 at 6:50

xdazz · Accepted Answer · 2012-07-05 06:36:32Z

2

Try $your_array[0]->followee.

answered Jul 5, 2012 at 6:36

xdazz

161k38 gold badges255 silver badges278 bronze badges

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

6 Comments

Ciprian Over a year ago

Message: implode() [function.implode]: Invalid arguments passed WHERE userid IN ("'. implode('","', $followID[0]->followee) .'")';

Ciprian Over a year ago

function activity($followID[0]->followee) - Parse error: syntax error, unexpected '[', expecting ')'

xdazz Over a year ago

Which variable is Array ( [0] => stdClass Object ( [followee] => 267,269,270,271,272,273,275,276,277,278,279 ) ) ?

xdazz Over a year ago

And this array means $your_array, not $followID.

Ciprian Over a year ago

$followIDis Array ( [0] => stdClass Object ( [followee] => 267,269,270,271,272,273,275,276,277,278,279 ) )

|

Peon · Accepted Answer · 2012-07-05 07:04:12Z

0

Well, you have an object in you variable and you don't want to convert that.

The right way, to access the variable would be creating a function inside your class like this:

public function getFollowee() {
  return $this -> followee;
}

And the way to access it:

function activity() {
  $query_str = 'SELECT DISTINCT name FROM place WHERE userid IN ( ' . $stdClass -> getFollowee() . ')';
  $query = $this -> db -> query( $query_str );
}

answered Jul 5, 2012 at 7:04

Peon

8,0417 gold badges63 silver badges104 bronze badges

Collectives™ on Stack Overflow

Convert array to string MySQL query

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related