phalcon笔记

网上下载的pdf或者官方文档说明代码示例有些错误。

$di->set和$di->setShare()是单利模式 不需要再实例化了。每次请求都是同一个

forward:

是controller内部跳转

 

model中

public function initialize()
{
    $this->setSchema("test");
    $this->setSource("user");
    echo __METHOD__, '<br>';
}
//保存的时候内容不发生变化 不会触发
public function beforeSave()
{
    echo __METHOD__, '<br>';
}
//保存的时候内容不发生变化 不会触发
public function afterSave()
{
    echo __METHOD__, '<br>';
}
public function afterFetch()
{
    if ($this->age <= 0) {
        $this->age = 112221;
    }
}

User::find('id<80 and age>100');

User::find([
    'condition' => 'id>100',
    'limit' => 10,
    'offset' => 3,
    'order' => 'id desc'
]);

Array ( [id] => 2 [name] => test8085 [age] => 112221 )

model参数查询

$id = 2;

$result = User::find([
    'conditions' => 'id = ?2',//数字和下面bind对应
    'bind' => [2 => $id]
]);
print_r($result->toArray());

$result = User::find([
    'conditions' => 'id = :id:',
    'bind' => ['id' => $id]
]);
print_r($result->toArray());

通过hydration控制输出

$id = 2;

$result = User::find([
    'conditions' => 'id = ?2',//数字和下面bind对应
    'bind' => [2 => $id],
    'hydration' => Resultset::HYDRATE_ARRAYS//Resultset::HYDRATE_OBJECTS//Resultset::HYDRATE_RECORDS默认的
]);
foreach ($result as $obj) {
    var_dump($obj);
}

指定field

$id = 2;

$result = User::find([
    'conditions' => 'id = ?2',//数字和下面bind对应
    'bind' => [2 => $id],
    'columns' => 'age,name'
]);
foreach ($result as $obj) {
    var_dump($obj);
}

取最大最小 等聚合

$result = User::maximum(["column" => "id"]);
print_r($result);

$result = User::minimum(["column" => "id"]);
print_r($result);

$result = User::average(["column" => "id"]);
print_r($result);

更新操作

        $user = User::findFirst(2);
        $user->name = 2222;
        $user->age = 2222;
//        var_dump($user->save());//都行
        var_dump($user->update());//都行

user model

public function initialize() { $this->skipAttributesOnUpdate(['age']);//不更新age字段 $this->useDynamicUpdate(true);//加速性能,需要更新的字段更新 $this->setSchema("test"); $this->setSource("user"); echo __METHOD__, '<br>'; }

删除

phal orm没有提供批量删除，

di 管理事务

Dependency Injection

Transactions are reused no matter where the transaction object is retrieved. A new transaction is generated only when a commit() or rollback() is performed. You can use the service container to create the global transaction manager for the entire application:

<?php use Phalcon\Mvc\Model\Transaction\Manager; $container->setShared( 'transactions', function () { return new Manager(); } );

Then access it from a controller or view:

<?php use Phalcon\Mvc\Controller; use Phalcon\Mvc\Model\Transaction\Manager; /** * @property Manager $transactions */ class ProductsController extends Controller { public function saveAction() { $manager = $this->di->getTransactions(); $manager = $this->transactions; $transaction = $manager->get(); // ... } }

NOTE: While a transaction is active, the transaction manager will always return the same transaction across the application. {: .alert .alert-info }

session