[版本 4.x] 欢迎交流CI4实际开发中的问题,本人正在开发的小项目

/*
Navicat MySQL Data Transfer

Source Server : localhost
Source Server Version : 50726
Source Host : localhost:3306
Source Database : ci4

Target Server Type : MYSQL
Target Server Version : 50726
File Encoding : 65001

Date: 2021年09月10日 15:43:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `my_news`
-- ----------------------------
DROP TABLE IF EXISTS `my_news`;
CREATE TABLE `my_news` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`auth` VARCHAR(20) NOT NULL,
`img_path` VARCHAR(100) NOT NULL,
`title` VARCHAR(128) NOT NULL,
`slug` VARCHAR(128) NOT NULL,
`body` text NOT NULL,
PRIMARY KEY (`id`),
KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of my_news
-- ----------------------------
INSERT INTO `my_news` VALUES ('1', 'admin', './public/uploads/images/logo.png', '测试数据一条11112222', '什么意思呢', '何必你好1212');
INSERT INTO `my_news` VALUES ('11', '', '', '再加一个', '加一个什么呢', '看不看得到啊');
INSERT INTO `my_news` VALUES ('12', '', '', '随便写', '写一个什么呢啊啊a', 'a阿萨v阿萨阿斯顿啊啊啊啊阿萨');
INSERT INTO `my_news` VALUES ('3', '', '', 'Caffeination, Yes!', 'caffeination-yes', 'World\'s largest coffee shop␣\r\n都是啥玩意');
INSERT INTO `my_news` VALUES ('5', '', '', '呵呵呵呵', '士大夫打撒', '士大夫大师傅撒飞洒发生发生发生飞洒发生');
INSERT INTO `my_news` VALUES ('6', '', '', '温德尔瓦', '巍峨哇', '温热嗡嗡嗡我认为');
INSERT INTO `my_news` VALUES ('7', '', '', '取桥桥', '的撒范德萨', '是否是否打算打发发书法大赛v士大夫打撒');
INSERT INTO `my_news` VALUES ('8', '', '', '胜多负少', '士大夫打撒是', '士大夫打撒');
INSERT INTO `my_news` VALUES ('9', '', '', '331我顶顶顶顶是', '首发式发生', '上的发大水发大水发大水发生发生发啊沙发沙发阿斯顿发顺丰');

<?php
namespace App\Models\Apimodel;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
class News_model extends \CodeIgniter\Model{
protected $table='my_news';
protected $primarykey='id';
protected $allowedFields=[
'auth',
'title',
'img_path',
'slug',
'body',
];
}

<?php
namespace App\Controllers\Api;
use CodeIgniter\RESTful\ResourceController;
use CodeIgniter\API\ResponseTrait;
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
class News extends ResourceController{
use ResponseTrait;
public function index(){
$model=New \App\Models\Apimodel\News_model();
$data=$model->findAll();
return $this->respond($data);
}
public function show($id=null){
$model=new \App\Models\Apimodel\News_model();
$data=$model->getwhere(['id'=>$id])->getResult();
if($data){
return $this->respond($data);
}else{
return $this->failNotFound("没有找到这个id=".$id."的数据.");
}
}
public function add(){
$model=new \App\Models\Apimodel\News_model();
$data['auth']=$this->request->getVar('auth');
$data['img_path']=$this->request->getVar('img_path');
$data['title']=$this->request->getVar('title');
$data['slug']=$this->request->getVar('slug');
$data['body']=$this->request->getVar('body');
$model->insert($data);
$response=[
'status'=>201,
'error'=>null,
'message'=>[
'success'=>'数据添加成功',
]
];
return $this->respondCreated($response);
}
public function update($id=null){
$model=New \App\Models\Apimodel\News_model();
$input=$this->request->getRawInput();
$data=[
'auth'=>$input['auth'],
'img_path'=>$input['img_path'],
'title'=>$input['title'],
'slug'=>$input['slug'],
'body'=>$input['body'],
];
$model->update($id,$data);
$response=[
'status'=>200,
'error'=>null,
'message'=>[
'success'=>'数据更新成功',
],
];
return $this->respond($response);
}
public function del($id=null){
$model=new \App\Models\Apimodel\News_model();
$data=$model->find($id);
if($data){
$model->delete($id);
$response=[
'status'=>200,
'error'=>null,
'message'=>[
'success'=>'数据删除成功',
]
];
return $this->respondDeleted($response);
}else{
return $this->failNotFound("没有找到这个id=".$id."的数据.");
}
}
}

<?php
namespace App\Controllers;

/**
* Class BaseController
*
* BaseController provides a convenient place for loading components
* and performing functions that are needed by all your controllers.
* Extend this class in any new controllers:
* class Home extends BaseController
*
* For security be sure to declare any new methods as protected or private.
*
* @package CodeIgniter
*/

use App\Controllers\BaseController;
use App\Models\ApisModel;

class ApiBase extends BaseController
{

/**
* An array of helpers to be loaded automatically upon
* class instantiation. These helpers will be available
* to all other controllers that extend BaseController.
*
* @var array
*/
protected $helpers = [];
protected $apisModel;
protected $mokappkey;
protected $mokappsecret;
protected $moktoken;//接口令牌 有效期1周 过期后 重新换取
protected $mokapp; //当前接口应用信息
protected $usertoken;//用户令牌
protected $user;

/**
* Constructor.
*/
public function initController(\CodeIgniter\HTTP\RequestInterface $request, \CodeIgniter\HTTP\ResponseInterface $response, \Psr\Log\LoggerInterface $logger)
{
// Do Not Edit This Line
parent::initController($request, $response, $logger);

$this->apisModel = new ApisModel();

$this->usertoken = $this->request->getHeaderLine('token');
$this->moktoken = $this->request->getHeaderLine('moktoken');
$this->mokappkey = $this->request->getHeaderLine('mokappkey');
$this->mokappsecret = $this->request->getHeaderLine('mokappsecret');


$this->checkApiToken();//

$this->getUserInfor();

}

//通过mokappkey 和 mokappsecret 生成 token 一周有效期
protected function createApiToken()
{
$data = $this->apisModel->getOpenByKey($this->mokappkey);
if (!$data) {
$this->_json(1, '应用不存在');
}
$this->mokapp = $data;
$secret = md5 ($data['secret'] . $data['key']);
if ($secret != $this->mokappsecret) {
$this->_json(1, '应用授权错误');
}
$this->moktoken = md5 ($secret);
//生成apptoken
$this->cache->save($this->moktoken, ['id' => $data['id'], 'key' => $data['key'], 'userid' => $data['userid'], 'platform' => $data['platform']], WEEK);
$this->_json(0, 'ok', $this->moktoken);
}

protected function checkApiToken()
{
$value = $this->cache->get($this->moktoken);
return $value;
}

public function getUserInfor()
{
$cache = $this->cache->get($this->usertoken);
if (!$cache) {
$this->userid = 0;
$this->user = null;
return '';
}
if (isset ($cache['userid']) && $cache['userid']) {
$this->userid = $cache['userid'];
$this->session->set('userid', $this->userid);
$this->user = $this->userModel->getUser($this->userid);
$this->renderer->setData(['user' => $this->user, 'userid' => $this->userid]);
}

}

}