CODEWITHSUNDEEP
phpsymfonydoctrine-orm
Gabriel ThaKid
Gabriel ThaKid

Reputation: 887

Is it possible to find columns using multiple values in Doctrine and Symfony2?

image I have the following database structure 

class voters
{
    protected $voterid;
    protected $imageid;
    protected $action;
}

// $voterid = is the current voter
// $imageid = is the id of the voted image
// $action = is upvote/downvote,delete

what happens if I want to look for several items at once, to check if a column exists, something like 

$dummy = findOneBy('voterid'=>1,'imageid'=>2,action=>"upvote");

if($dummy)
{
   //column exists!
}

Is this possible?

Upvotes: 13

Views: 24459

Answers (2)

Victor Bocharsky
Victor Bocharsky

Reputation: 12306

You must pass all values as array like this:

$dummy = $this->getDoctrine()->getRepository("AcmeDemoBundle:User")->findOneBy(array(
    'voterid'=>1,
    'imageid'=>2,
    'action'=>'upvote',
));

if($dummy)
{
   //column exists!
}

Where key of array is a column name, value is a value in this column.

NOTE: AcmeDemoBundle:User - is your entity

Upvotes: 5

Laurent W.
Laurent W.

Reputation: 3783

See Databases and Doctrine

If you want to retrieve a product, regarding some properties, you just have to use the method findOneBy with as parameters an array :

$product = $repository->findOneBy(array('name' => 'foo', 'price' => 19.99));

Upvotes: 29

Related Questions