摘要：<?php/** * Created by PhpStorm. * User: Administrator * Date: 2018-12-13 * Time: 8:33 */namespace app\index\controller;use think\db;class Query{ public function find() { &
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2018-12-13
* Time: 8:33
*/
namespace app\index\controller;
use think\db;
class Query
{
public function find()
{
$res=Db::table('user')
//->field('name','id')
->field(['name','id'])
->where('id','>',4)
->find();
dump($res);
}
public function select()
{
$res=Db::table('user')
//->field('name','id')
->field(['name','id'])
->where('group_id','>',30)
->select();
dump($res);
}
public function insert()
{
$data=[
'name'=>'yanwu',
'group_id'=>'113',
'password'=>'abc'
];
$num =Db::table('user')->insert($data);
$id=Db::getLastInsID();
return $num ? '添加成功,id='.$id : '没有记录添加';
}
public function update()
{
$num=Db::table('user')
->where('group_id','<=',47)
->data(['group_id'=>Db::raw('group_id + id')])
->update();
return $num ? '数理更新成功,'.$num :'没有数据更新';
}
public function delete()
{
$num =Db::table('user')
->where('group_id',45)
->delete();
return $num ? '删除成功! '.$num .'条记录' :'没有记录被删除!';
}
}
批改老师：韦小宝批改时间：2018-12-13 13:12:32
老师总结：写的很不错哦！课后要记得多多练习啊！继续加油吧！
