Select Zend Db with array

Question

What's the correct syntax to select multiple rows through an array using Zend ? So basically fetch all the data that has name $a OR $b etc..depending on number of array elements. I can't figure it out.......

public function selectRow($array) 
{
    $data = $this->table->select()
                        ->where('name = ?', $array);
    return $this->table->fetchAll($data);
}

Rikesh · Accepted Answer · 2013-03-01 05:51:18Z

1

You have to use IN clause for that. So try,

$data = $this->table->select()
                    ->where('name IN (?)', $array);

answered Mar 1, 2013 at 5:51

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

Comments

Nandakumar V · Accepted Answer · 2013-03-01 05:49:05Z

1

you can use orWhere() in the Zend_Db_Select. Check the manual Zend_Db_Select::where().

public function selectRow($array) 
{
    $data = $this->table->select()
                        ->where('name = ?', $array)
                        ->orWhere('address = ?', $anotherarray);
    return $this->table->fetchAll($data);
}

it would be better to use IN and NOT IN when the where condition contains array of values

answered Mar 1, 2013 at 5:49

Nandakumar V

4,7255 gold badges33 silver badges50 bronze badges

Collectives™ on Stack Overflow

Select Zend Db with array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related