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> }希望大婶们嘴下留情
我还是小白呢
有不足之处希望大家指出，谢谢！
