通过获取表单数据的id与数据库的比较查询信息实现数据修改 [ 1.1 版本 ]

controller代码
<?php
class TalkController extends CController
{

public function actionGetTalk(){//查找所有数据
    $talk = Talk::model()->findAll(); //将数据表中全部信息存到 $talk
    $this->renderPartial('admin',array('talk'=>$talk));
}
public function  actionGetTalkById(){//根据主键查询数据

    $id=$_GET['id'];
    $talk=Talk::model()->find('id=:id',':id'=>$id);
    $this->renderPartial('select',array('talk'=>$talk));
}
public function  actionGetDeleteTalk()
{
    $id=$_GET['id'];
    $talk=Talk::model()->findByPk($id);
    $talk->delete();                    // 从数据表中删除此行
    return $this->actionGetTalk();
}

public function actionToAddTalk(){
    $this->redirect('talk/index');
}

public function actionAddTalk2(){
    $talk=new Talk;
    $username=$_POST['username'];
    $subject=$_POST['subject'];
    $content=$_POST['content'];
    $talk->subject=$subject;
    $talk->username=$username;
    $talk->content=$content;
    $talk->save();
    return $this->actionGetTalk();
}
public function actionToUpdateTalk(){
    $id=$_GET["id"];
    $talk=Talk::model()->find('id=:id ',array(':id'=>$id));
    $this->renderPartial('update',array('talk'=>$talk));
}

public function actionGetUpdateTalk(){
    $id=$_POST['id'];
    $talk=Talk::model()->find('id=:id ',array(':id'=>$id));
    $talk->subject=$_POST['subject'];
    $talk->content=$_POST['content'];
    $talk->username=$_POST['username'];
    $talk->save(); // 将更改保存到数据库
    return $this->actionGetTalk();
}

}

update视图代码

<table border="1" style="margin-top: 100px;margin-left: 100px">

    <tr >
        <input type="text" name="id" value="编号" hidden/>
    </tr>

    <tr><?php foreach ($talk as $sq):
        ?>

        <td>主题</td>
        <td>
            <textarea  type="text" name="subject" style="width: 1000px" ><?php echo $sq->subject;?></textarea>
        </td>
    </tr>
    <tr>
        <td>内容</td>
        <td>
            <textarea  type="text" name="content" style="width: 1000px"><?php echo $sq->content;?></textarea>
        </td>
    </tr>
    <tr>
        <td>留言人</td>
        <td>
            <textarea  type="text" name="username" style="width: 1000px"><?php echo $sq->username;?></textarea>
        </td>
    </tr>
    <?php endforeach;
    ?>
    <tr>
        <td  colspan="2" style="text-align: center"><input type="submit" name="submit" value="修改"></td>
    </tr>
</table>

admin视图将保存在数据库的信息显示出来，每条数据后面都有修改，删除等操作，当点击修改时将其对应的数据从数据库查找输出在另一表单，问下查询的实现