直接上代码,
Model层,可调用方法
————————————————————————————————————————————————————
Goods.php
_____________________________________________________________________________________________________________________________
namespace app\index\model;
use think\Db;
use think\Model;
class Goods extends Model
{
//增加
function insertData($tabla,$data)
{
return Db::table("$tabla")->insert($data);
}
//展示
function show($tabla)
{
return Db::table("$tabla")->select();
}
//带条件查询
function show_where($tabla,$data)
{
return Db::table("$tabla")->where("is_show=$data")->select();
}
//删除
function deleteData($tabla,$id)
{
return Db::table("$tabla")->where("book_id='$id'")->delete();
}
//查询单条
function findData($tabla,$name)
{
return Db::table("$tabla")->where('name','=',$name)->find();
}
//修改
function updateData($tabla,$data,$id)
{
return Db::table("$tabla")->where('book_id','=',$id)->update($data);
}
//登录
function login($tabla,$name,$pwd)
{
return Db::table("$tabla")->where('name','=',$name,'pwd','=',$pwd)->find();
}
//文件写入
function file($file,$data)
{
$myfile = fopen("$file", "a",FILE_APPEND) or die("Unable to open file!");
fwrite($myfile, "\n'$data'");
fclose($myfile);
}
//文件上传(图片)
public function upload($file){
//$file = request()->file("file");//这行注释是控制器file的传值方式
//移动图片到相应文件夹
$info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
$img = $info->getSaveName();
//拼接地址
$path ="http://localhost/11month/tp5week/public/uploads/" ."$img";
//将字符串转换成数组
$file_path = explode(",",$path);
return $file_path;
}
//带条件分页
public function getPagedata($tabla,$where,$data)
{
//表名——条件——每页显示条数——{$select->render()}//视图层显示
return Db::name($tabla)->where($where)->paginate(3,false,['query'=>request($data)->param()]);
}
}
——————————————————————————————————————————————————
可直接粘贴使用。