框架安装直接按照官网https://www.easyswoole.com/Cn/QuickStart/install.html准备数据CREATETABLE`cases`(`id`int(11)NOTNULLAUTO_INCREMENTCOMMENT'主键',`title`varchar(200)CHARACTERSETutf8COLLATEutf8_general_ciNOTNULLCOMMENT'title',`content`textCHARACTERSETutf8COLLATEutf8_general_ciNULLCOMMENT'content',`create_time`int(10)NOTNULLCOMMENT'创建时间',PRIMARYKEY(`id`)使用BTREE)ENGINE=MyISAMAUTO_INCREMENT=21CHARACTERSET=utf8COLLATE=utf8_general_ciROW_FORMAT=Dynamic;随便写几条数据INSERTINTO`test`.`cases`(`id`,`title`,`content`,`create_time`)VALUES(1,'社化网络副总经理接受电视采访station','test',1536223828);INSERTINTO`test`.`cases`(`id`,`title`,`content`,`create_time`)VALUES(3,'微信小程序超级入口,新一轮ofbonuseswillexplodeagain','test',1605757832);INSERTINTO`test`.`cases`(`id`,`title`,`content`,`create_time`)VALUES(4,'哪个小程序开发公司在北京好吗?','test',1535963051);配置mysql数据库连接,打开easyswoole根目录下的dev文件,与MAIN_SERVER同级,添加'MYSQL'=>['host'=>'你自己的IP','port'=>'port','user'=>'root','password'=>'123456','database'=>'test','timeout'=>5,'charset'=>'utf8mb4',]修改为自己的配置建模型在easyswooleApp/Models对应目录建模型Case.php写代码title='aaa';$case->content='测试';$case->create_time=time();$id=$case->保存();$this->writeJson(0,[],$id>0?'添加成功':'添加失败');}在浏览器中输入http://你自己的IP:9501/insert查看数据库,数据成功添加、删除、修改和检查“检查”控制器I在索引中添加代码publicfunctiongetAll(){$request=$this->request();$keyword=$request->getRequestParam('关键字');$page=$request->getRequestParam('page');$案例=新案例();$result=$case->getAll($page,$keyword);$this->writeJson(0,$result,"成功");}Model/App/Cases.php添加代码publicfunctiongetAll(int$page=1,string$keyword=null,int$pageSize=3):array{$list=$this->limit($pageSize*($page)-1),$pageSize)->order($this->primaryKey,'DESC')->withTotalCount()->all(function(QueryBuilder$queryBuilder)use($keyword){//使用use传递外部参数进入闭包$queryBuilder->where('title',"%{$keyword}%",'like');});$total=$this->lastQueryResult()->getTotalCount();//获取结果个数return['total'=>$total,'list'=>$list];}进入你easywoole安装下的linux命令行,Ctrl+C,然后输入phpeasyswoolestart重启服务返回windows,在浏览器输入http://你自己的IP:9501/getAll?keyword=Beijing&page=1成功查看返回信息{"code":0,"r结果":{"total":10,"list":[{"id":20,"title":"ddd","content":"test","create_time":1605764790},{"id":19,"title":"ccc","content":"test","create_time":1605764790},{"id":18,"title":"ccc","content":"test","create_time":1605764774}]},"msg":"success"}增删改查"delete"Index.php写代码publicfunctiondelete(){$request=$this->request();$id=$request->getRequestParam('id');$case=Cases::create()->get($id);$count=$case->destroy();$this->writeJson(0,[],$count>0?'Deletesuccessful':'Deletefailed');}重启服务,访问你的IP/delete?id=你的数据ID查看数据库,删除成功增删改查“change”索引.php编写代码publicfunctionupdate(){$request=$this->request();$id=$request->getRequestParam('id');$case=Cases::create()->get($id);$content=$request->getRequestParam('content');$case->content=$content;$res=$case->update();$this->writeJson(0,[],$res?'修改成功':'修改成功failed');}重启服务,访问你的IP/update?id=你的ID&content=你的内容查看数据库,删除查询成功的代码声明过程中,有任何问题,翻文档即可https://www.easyswoole.com/Cn/Components/Orm/update.html就这么简单,搞定
