摘要：<?php namespace app\index\controller;use think\Controller;use app\index\model\Book as BookModel; //设置模型的别名class Book extends Controller{ //实例化模型 // { public function instance(BookModel $book)
<?php
namespace app\index\controller;
use think\Controller;
use app\index\model\Book as BookModel; //设置模型的别名
class Book extends Controller
{
//实例化模型
// {
public function instance(BookModel $book)
{
//模型实例化
// dump($book->getName());
//新增一条记录
$book->name= 'C++';
$book->price = '66';
return $book->save() ? '新增成功，ID是'.$book->book_id : '新增失败';
}
public function query()
{
//查询单条记录
// $book = BookModel::get(2);
// dump($book);
//闭包
// $book = BookModel::get(function($query){
// $query->where('price','>',50);
// });
// return $book ? '所有大于50的图书<br>'.dump($book):'查询失败';
$books = BookModel::all();
//遍历出来
foreach ($books as $book) {
echo '书名:'.$book->name.'<br>';
echo '价格:'.$book->price.'<br>';
}
}
public function update()
{
// return BookModel::update(
// ['name'=>'C#','price'=>80],
// ['book_id'=>8]
// ) ? '成功':'失败';
//复杂更新
return BookModel::update(
['price'=>\think\Db::raw('price+80')],
function($query)
{
$query->where('price','<',10);
}
) ? '成功':'失败';
}
//新增数据
public function create()
{
//create()
$date =
[
'name'=>'goland',
'price'=>30
];
$field = ['name','price'];
return BookModel::create($date,$field) ? '成功':'失败';
}
public function delete()
{
//delete
// 这是软删除
//return BookModel::destroy(9) ? '删除成功':'删除失败';
//这是物理删除
//return BookModel::destroy(10) ? '删除成功':'删除失败';
//$res = BookModel::withTrashed()->where('book_id<9')->select();
$res = BookModel::onlyTrashed()->where('book_id<=9')->select();
dump($res);
}
}
批改老师：查无此人批改时间：2019-01-10 13:29:18
老师总结：做的还不错。作业里面可以在说一些自己的看法。比如软删除有什么好处。加油
