刪除數據表中的記錄使用delete語句，改語句返回刪除的記錄數量
~~~
$result=Db::name('book')->where(['id'=>$id])->delete();
~~~
~~~
<?php
namespace app\controller;
use app\BaseController;
use think\facade\Db;
class Book extends BaseController
{
public function getBookList($page = 1, $pageSize = 10)
{
// 獲取數據集
$books = Db::name('book')->order('id', 'desc')->paginate(['page' => $page, 'list_rows' => $pageSize]);
$books = $books->toArray();
//轉換分頁器滿足約定的接口規范
$data = array(
'count' => $books['total'],
'currentPage' => $books['current_page'],
"pageSize" => $books['per_page'],
"totalPages" => $books['last_page'],
"data"=>$books['data']
);
$response = [
'errno' => 0,
'errmsg' => '',
'data' => $data
];
return json($response);
}
public function getAllBook()
{
// 獲取數據集
$books = Db::name('book')->select();
$response = [
'errno' => 0,
'errmsg' => '',
'data' => $books
];
return json($response);
}
public function getBookInfo($id = 0)
{
$book = Db::name('book')->where(['id' => $id])->find();
if ($book) {
$response = [
'errno' => 0,
'errmsg' => '',
'data' => $book
];
} else {
$response = [
'errno' => 1000,
'errmsg' => '沒有滿足條件的數據',
'data' => null
];
}
return json($response);
}
public function deleteBookInfo($id){
$result=Db::name('book')->where(['id'=>$id])->delete();
$response= null;
$response=[
'errno' => 0,
'errmsg' => '刪除數據的條數',
'data' => $result
];
return json($response);
}
}
~~~
