abstract：<?php namespace app\index\controller; use think\Db; clas
<?php
namespace app\index\controller;
use think\Db;
class Index
{
public function index()
{
return ;
}
//單條查詢
public function find(){
$res = Db::table('reader')
->where('id','>',1) //id大于1
->find();
dump($res);
}
//多條查詢方法
public function select(){
$res = Db::table('reader')
//指定字段
->field(['name','age','tel','email'])
//->field(['name'=>'姓名','age'=>'年齡'，'tel'=>'電話','email'=>'郵箱'])
->where('id','>=','2')
->order('name','DESC')
->select();
dump($res);
}
//新增記錄
public function insert(){
//添加一條記錄
$data =['name'=>'孫一','age'=>32,'tel'=>'15926897575','email'=>'15926897575@qq.com','salary'=>3500];
$res = Db::table('reader')
->data($data)
->insert();
echo $res ? '添加'.$res.'條記錄成功!' :'添加失敗';
}
//新增多條記錄
public function insertAll(){
//添加多條記錄
$data =[
['name'=>'胡中','age'=>36,'tel'=>'13586892126','email'=>'13586892126@qq.com','salary'=>3500],
['name'=>'長(zhǎng)國(guó)','age'=>21,'tel'=>'15895656563','email'=>'15895656563@qq.com','salary'=>3500],
['name'=>'至國(guó)','age'=>38,'tel'=>'13698366535','email'=>'13698366535@qq.com','salary'=>3500],
];
$res = Db::table('reader')
->data($data)
->insertAll();
echo $res ? '添加'.$res.'條記錄成功!' :'添加失敗';
}
public function update(){
//更新記錄操作
$res = Db::table('reader')
->data(['salary'=>Db::raw('salary+500')])
->where('salary','<=',3000)
->update();
echo $res ? '更新'.$res.'條記錄成功!' :'更新失敗';
}
public function delete(){
//刪除記錄
$res = Db::table('reader')
->where('salary','>=',4000)
->delete();
echo $res ? '刪除'.$res.'條記錄成功!' :'刪除失敗';
}
}
Correcting teacher：天蓬老師Correction time：2019-11-01 14:39:12
Teacher's summary：實(shí)際上, 你可以試試用命令來生成這些資源管理器