Latest snippets tagged mysql propel symfony php
http://snippets.prendreuncafe.com/snippets/tagged/mysql+propel+symfony+php/order_by/date
2007-01-15T12:05:04Z
Symfony
noreply@symfony-project.com
[Symfony] Traiter les OR sql avec Propel
2007-01-15T12:05:04Z
40
Voici comment gérer les "ou" SQL dans Propel :
[code]
$criteria = new Criteria();
$criteria->add(TotoPeer::NAME, 'Gérard Bouchard');
$criterion = $criteria->getNewCriterion (
TotoPeer::ID, 5
)->addOr($criteria->getNewCriterion (
TotoPeer::ID, 10
));
$criteria->addAnd($criterion);
TotoPeer::doSelect($criteria);
[/code]
Ceci donnera quelque chose comme :
[code]
SELECT
*
FROM
toto
WHERE
toto.NAME = 'Gérard Bouchard'
AND
(
toto.ID = 5
OR
toto.ID = 10
);
[/code]