复制内容到剪贴板
代码:
<?php
//新建
$user = new User();
$user->setName('symfony');
$user->setAge(3);
$user->save();
//查询
$user = UserPeer::retrieveByPk(1);
echo $user->getName() . ' ' . $user->getAge() . '<br /> ';
$users = UserPeer::retrieveByPks(array(1, 2, 3, 4));
foreach ($users as $user) {
echo $user->getName() . ' ' . $user->getAge() . '<br /> ';
}
// 更新
$user = UserPeer::retrieveByPk(1);
$user->setName('new Name');
$user->save();
// 删除
UserPeer::doDelete(1);
$user = UserPeer::retrieveByPk(1);
$user->delete();
?> 复制内容到剪贴板
代码:
<?php
// 查询 name = 'symfony' 的记录
$c = new Criteria();
$c->add(UserPeer::NAME, 'symfony');
$users = UserPeer::doSelect($c);
//只查询一条记录
$user = UserPeer::doSelectOne($c);
//...也支持 group by、limit、table join 等等特性
?> 使用 Criteria::CUSTOM 可使 Criteria 实现自
定义条件查询
复制内容到剪贴板
代码:
SELECT *
FROM users
WHERE CONCAT(first_name, ' ', last_name) = '$username';复制内容到剪贴板
代码:
<?php
$c = new Criteria();
$c->add(UserPeer::FIRST_NAME,
"CONCAT(" . UserPeer::FIRST_NAME . ", ' ', " . UserPeer::LAST_NAME . ") = '" . $username . "'",
Criteria::CUSTOM);
$users = UserPeer::doSelect($c);
?> 
