BasePeer::doUpdate($select_criteria, $update_criteria, $connection);

$con = Propel::getConnection();
 
// select from...
$c1 = new Criteria();
$c1->add(CommentPeer::POST_ID, $post_id);
 
// update set
$c2 = new Criteria();
$c2->add(CommentPeer::RATING, 5);
 
BasePeer::doUpdate($c1, $c2, $con);

$con = Propel::getConnection();
 
// select from...
$c1 = new Criteria();
$c1->add(self::POST_ID, $post_id);
 
// update set
$c2 = new Criteria();
$c2->add(self::RATING, 5);
 
BasePeer::doUpdate($c1, $c2, $con);

Comments on this snippet

#1 Olivier Verdier on 2006-07-03 at 08:33

Excellent! That method comes in very handy! Just a remark: I think that the $connection parameter is optional, as in nearly all the other propel methods. So you can simply call:

#2 Olivier Verdier on 2006-07-03 at 08:35

My code disappeared from the previous comment... 8-(

#3 Olivier Verdier on 2006-07-03 at 08:36

What the F***! The code disappeared twice! Here is the code without syntax colouring then: BasePeer::doUpdate($c1, $c2)

#4 Piotr Belina on 2006-07-12 at 01:45

DO you have idea how to do update like this usign Criteria?

UPDATE table SET col = col + 1

#5 Sigurd Palladin on 2006-08-10 at 12:57

2Piotr Belina: $c2->add(self::RATING, "rating = rating + 1", Criteria::CUSTOM); note that this is true for Criteria v1.0 More info can be found on http://propel.phpdb.org/trac/wiki/Development/Criteria

#6 sampq on 2007-12-05 at 06:05

If you have several databases be careful to specify the name of the database for the connection and the criterias.

Like this:

$con = Propel::getConnection(self::DATABASE_NAME); ... $c1 = new Criteria(self::DATABASE_NAME); ... $c2 = new Criteria(self::DATABASE_NAME); ...

Otherwise propel will use the default database and you will get an error if you don't use this one (this is because the code use a BasePeer static method and not a CommentPeer one).

#7 Julien Moreau on 2008-03-03 at 05:04

You should also have a look to this: http://propel.phpdb.org/trac/wiki/Users/Documentation/1.2/BasicCRUD#UPDATE