https://www.cnblogs.com/vicfeel/p/7230578.html

https://blog.csdn.net/wxlhlh001/article/details/8560508?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522161597479716780274157448%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=161597479716780274157448&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_v1~rank_blog_v1-4-8560508.pc_v1_rank_blog_v1&utm_term=yii

《应用Yii1.1和PHP5进行敏捷Web开发》

超链接：

<a href="/demo/index.php?r=message/goodbye">Goodbye!</a>

model：

DAO数据访问对象：

  查询SQL语句，queryAll只能执行查询的sql

$sql = "delete from test where name ='张三' ";

$command = Yii::app()->db->createCommand($sql);

return $command->execute();

execute()：执行增删改操作

query() : 执行查询

查询生成器：

    查询：

        $criteria->select="id,name";

        $criteria->compare("id",$test_id);

$criteria-> order = 'id desc';

    1. 查询指定的数据

       $data = array();

        $criteria = new CDbCriteria();

        $criteria->select="id,name";

        $criteria->compare("id",$test_id);

        $foodprases = $this->findAll($criteria);

        foreach($foodprases as $foodprase){

            $data= array(

                'id' => $foodprase->id,

                'name' => $foodprase->name

            );

        }

    2. 从别的模型中获取数据：

       $models = ShicaiShiwu::model()->findAll($criteria_sy);