php赵鹏飞的博客,Yii框架的基本操作

增删改查

namespace frontend\controllers;

use Yii;

use yii\web\Controller;

class LieController extends Controller

{

//查询显示列表

public function actionIndex()

{

$sql="select * from da";

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

return $this->render('index',['re'=>$re]);

}

//删除

public function actionPai2()

{

$id=$_GET['id'];

$sql="delete from da where id=$id";

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

if($re)

{

echo "true";

}else

{

echo "flase";

}

}

//添加页面

public function actionPai3()

{

return $this->render('lii');

}

//执行添加

public function actionPai4()

{

$request=Yii::$app->request;

$username=$request->post('username');

$sql="insert into da(username) values('$username')";

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

if($re)

{

echo "成功";

}else

{

echo "失败";

}

}

//查询后修改页面

public function actionPai5()

{

$id=$_GET['id'];

$sql="select * from da where id='{$id}'";

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

return $this->render('liii',['re'=>$re]);

}

//执行修改

public function actionPai6()

{

$request=Yii::$app->request;

$username=$request->post('username');

$id=$request->post('id');

$sql="update da set username='{$username}' where id='{$id}'";

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

if($re)

{

echo "成功";

}else

{

echo "失败";

}

//下面是控制器跳转控制器

//return $this->redirect('index.php?r=lie/index');

}

}

编号姓名删除修改添加<?php echo $v['id'] ?><?php echo $v['username'] ?> 删除 修改 添加

姓名

姓名