Forum PHP.pl

[SQL] pobierz, plaintext 
UPDATE tabela SET kolumna=1 WHERE pk IN (1,2,34,...)
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$c1=new Criteria();
$c1->add(TabelaPeer::PK,$ids,Criteria::IN);
$c2=new Criteria();
$c2->add(TabelaPeer::KOLUMNA,1);
 BasePeer::doUpdate($c1,$c2,Propel::getConnection());
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$con = Propel::getConnection();
$stmt = $con->prepare('UPDATE tabela SET kolumna=1 WHERE pk IN (:id) ');
            $stmt->bindValue(':id', '1,2,3,4,5', PDO::PARAM_STR);
            $stmt->execute();
?>
[PHP] pobierz, plaintext 

Cytat(XvZOK @ 10.03.2009, 19:10:10 )

[SQL] pobierz, plaintext 
UPDATE tabela SET kolumna=1 WHERE pk IN (1,2,34,...)
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$c1=new Criteria();
$c1->add(TabelaPeer::PK,$ids,Criteria::IN);
$c2=new Criteria();
$c2->add(TabelaPeer::KOLUMNA,1);
 BasePeer::doUpdate($c1,$c2,Propel::getConnection());
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$c1=new Criteria();
$c1->add(TabelaPeer::PK,$ids,Criteria::IN);
$c1->add(TabelaPeer::KOLUMNA,1);
TabelaPeer::doUpdate($c1);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$con = Propel::getConnection();
     
    $c1 = new Criteria();
    $c1->add(PhotoPeer::PHOTO_ID, $photo_id);
     
    // update set
    $c2 = new Criteria();
    $c2->add(PhotoPeer::COUNTER, COUNTER+1);
     
    BasePeer::doUpdate($c1, $c2, $con);
?>
[PHP] pobierz, plaintext