yii ar 增删改查 操作测试记要

yii ar 增删改查 操作测试记录

亲们， 我是yii小白 不要笑话我奥。今天白天写一个管理模块涉及到 yii ar 下的  curd 操作，做 update 操作时纠结了好久，今天晚上花点时间学习， 下面写下我的测试记录

代码如下：

<span style="color: #008080;"> 1</span>     <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">function</span><span style="color: #000000;"> actionIndex(){</span><span style="color: #008080;"> 2</span> <span style="color: #008080;"> 3</span>         <span style="color: #008000;">//</span><span style="color: #008000;"> 写入数据</span><span style="color: #008080;"> 4</span> <span style="color: #008000;">        //yii  ar  curd  之   insert</span><span style="color: #008080;"> 5</span>         <span style="color: #800080;">$_POST</span>['Users']['sex'] = 2<span style="color: #000000;">;</span><span style="color: #008080;"> 6</span>         <span style="color: #800080;">$_POST</span>['Users']['username'] = 'xiaohua'<span style="color: #000000;">;</span><span style="color: #008080;"> 7</span>         <span style="color: #800080;">$model</span> = <span style="color: #0000ff;">new</span><span style="color: #000000;"> Users;</span><span style="color: #008080;"> 8</span>         <span style="color: #800080;">$model</span>->attributes = <span style="color: #800080;">$_POST</span>['Users'<span style="color: #000000;">];</span><span style="color: #008080;"> 9</span>         <span style="color: #800080;">$rt</span> = <span style="color: #800080;">$model</span>-><span style="color: #000000;">save();</span><span style="color: #008080;">10</span> <span style="color: #008080;">11</span>         <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$rt</span><span style="color: #000000;">) {</span><span style="color: #008080;">12</span>             Yii::app()->user->setFlash('success','写入成功了'<span style="color: #000000;">);</span><span style="color: #008080;">13</span>             <span style="color: #800080;">$this</span>->redirect(<span style="color: #0000ff;">array</span>('index/test'<span style="color: #000000;">));</span><span style="color: #008080;">14</span>         } <span style="color: #0000ff;">else</span><span style="color: #000000;"> {</span><span style="color: #008080;">15</span>             Yii::app()->user->setFlash('error','失败了'<span style="color: #000000;">);</span><span style="color: #008080;">16</span>             <span style="color: #800080;">$this</span>->redirect(<span style="color: #0000ff;">array</span>('index/test'<span style="color: #000000;">));</span><span style="color: #008080;">17</span> <span style="color: #000000;">        }</span><span style="color: #008080;">18</span> <span style="color: #008080;">19</span>     <span style="color: #008080;">20</span>         <span style="color: #008000;">//</span><span style="color: #008000;"> 查询数据</span><span style="color: #008080;">21</span> <span style="color: #008000;">        //get one data by field</span><span style="color: #008080;">22</span>         <span style="color: #800080;">$hh</span> = Users::model()-><span style="color: #000000;">find(</span><span style="color: #008080;">23</span>               'username=:name',<span style="color: #0000ff;">array</span>(':name'=>'fzb'<span style="color: #000000;">)</span><span style="color: #008080;">24</span> <span style="color: #000000;">            );</span><span style="color: #008080;">25</span>         <span style="color: #008080;">print_r</span>(<span style="color: #800080;">$hh</span>['username'<span style="color: #000000;">]);</span><span style="color: #008080;">26</span> <span style="color: #008080;">27</span>         <span style="color: #008000;">//</span><span style="color: #008000;">get one data by id</span><span style="color: #008080;">28</span>         <span style="color: #800080;">$hh</span> = Users::model()->findByPk(1<span style="color: #000000;">);</span><span style="color: #008080;">29</span>         <span style="color: #008080;">print_r</span>(<span style="color: #800080;">$hh</span>['username'<span style="color: #000000;">]);</span><span style="color: #008080;">30</span> <span style="color: #008080;">31</span>         <span style="color: #008000;">//</span><span style="color: #008000;">get all</span><span style="color: #008080;">32</span>         <span style="color: #800080;">$hh</span> = Users::model()-><span style="color: #000000;">findAll();</span><span style="color: #008080;">33</span>         <span style="color: #008080;">print_r</span>(<span style="color: #800080;">$hh</span><span style="color: #000000;">);</span><span style="color: #008080;">34</span> <span style="color: #008080;">35</span>         <span style="color: #008000;">//</span><span style="color: #008000;">  修改数据  </span><span style="color: #008080;">36</span> <span style="color: #008000;">        // update  one</span><span style="color: #008080;">37</span>         <span style="color: #800080;">$model</span> = <span style="color: #0000ff;">new</span><span style="color: #000000;"> Users;</span><span style="color: #008080;">38</span>         <span style="color: #800080;">$count</span> = <span style="color: #800080;">$model</span>->updateByPk(5,<span style="color: #0000ff;">array</span>('username'=>'admin','sex'=>1<span style="color: #000000;">));</span><span style="color: #008080;">39</span>         <span style="color: #0000ff;">if</span>(<span style="color: #800080;">$count</span><span style="color: #000000;">) {</span><span style="color: #008080;">40</span>             Yii::app()->user->setFlash('success','修改成功了'<span style="color: #000000;">);</span><span style="color: #008080;">41</span>             <span style="color: #800080;">$this</span>->redirect(<span style="color: #0000ff;">array</span>('index/test'<span style="color: #000000;">));</span><span style="color: #008080;">42</span>         } <span style="color: #0000ff;">else</span><span style="color: #000000;"> {</span><span style="color: #008080;">43</span>             Yii::app()->user->setFlash('error','修改失败了'<span style="color: #000000;">);</span><span style="color: #008080;">44</span>             <span style="color: #800080;">$this</span>->redirect(<span style="color: #0000ff;">array</span>('index/test'<span style="color: #000000;">));</span><span style="color: #008080;">45</span> <span style="color: #000000;">        }</span><span style="color: #008080;">46</span> <span style="color: #008080;">47</span> <span style="color: #008080;">48</span>     }

希望大婶们嘴下留情

我还是小白呢

有不足之处希望大家指出，谢谢！