abstract：<?php namespace app\index\controller; use think\Db; class Query { public function find() { $res = Db::table('user_info')->field(['name','s
<?php
namespace app\index\controller;
use think\Db;
class Query
{
public function find()
{
$res = Db::table('user_info')->field(['name','skill'])->where('status = 1')->find();
$res = implode($res);
return ($res);
}
public function select()
{
$res = Db::table('user_info')->field(['name','age','sex','skill'])->where('age < 22')->order('user_id asc')->select();
dump($res);
}
public function insert()
{
$data = ['name'=>'天门真人1','skill'=>'正派功法','password'=>sha1(123456)];
$res = Db::table('user_info')->data($data)->insert();
$id = Db::getLastInsId();
return '成功执行'.$res.'条数据 '.' 最后一条id是:'.$id;
}
public function insertAll()
{
$datas = [
['name'=>'天门真人2','skill'=>'正派功法','password'=>sha1(123456)],
['name'=>'天门真人3','skill'=>'正派功法','password'=>sha1(123456)],
['name'=>'天门真人4','skill'=>'正派功法','password'=>sha1(123456)],
];
// 新增多条记录，以二维数组的方式
$res = Db::table('user_info')->data($datas)->insertAll();
$id = Db::getLastInsId();
return '成功执行'.$res.'条数据'.'the last id is: '.$id;
}
public function update()
{
$name = '独孤九剑';
$res = Db::table('user_info')->where('age < 33')->data(['age'=>Db::raw('age - 14')])->update();
return $res? 'success update:'.$res:'false!';
}
public function delete()
{
$num = Db::table('user_info')->where('name','like','天门真人%')->delete();
return 'success delete:'.$numn;
}
}每个方法都测试过，成功执行，
Correcting teacher：天蓬老师Correction time：2019-04-14 21:58:11
Teacher's summary：代码无明显问题, 有个建议, 关于类的命名, 尽可能不要与系统框架重复, 哪怕可以通过命名空间进行区分,例如,你用到的Query, find