首页 > 代码库 > ThinkPHP5 查询数据并处理结果
ThinkPHP5 查询数据并处理结果
在处理数据库查询结果时遇到了些问题,记录下用到过的几种查询方式和结果处理。
1. 查询某条记录
- $where=array(
- "version_id"=>$version_id
- );
- $data = model("PackageWhitelist")->where($where)->find();
- $this->assign("package_id",$package_id);
- $where=array(
- "package_id"=>$package_id
- );
- $data = model("Package")->where($where)->find();
- if($data){
- $this->assign("target_version",$data[‘target_version‘]);
- }
2. 查询某条记录某个字段
- $this->assign("device_number",$device_number_list[‘device_number‘]);
3. 查询多个记录某个字段 , 并处理结果,结果是一个数组集
- $where=array(
- "version_id"=>$version_id
- );
- $data = model("PackageWhitelist")->where($where)->field("device_number")->select();
- $device_number_list=‘‘;
- foreach($data as $val){
- $list = $val->toArray();
- if($device_number_list){
- $device_number_list=$device_number_list.‘;‘.$list["device_number"];
- }else{
- $device_number_list=$list["device_number"];
- }
- }
4. 查询多条记录
- $where=array(
- "version_id"=>$version_id
- );
- $data = model("PackageWhitelist")->where($where)->select();
- $device_number_list=‘‘;
- foreach($data as $val){
- $list = $val->toArray();
- if($device_number_list){
- $device_number_list=$device_number_list.‘;‘.$list["device_number"];
- }else{
- $device_number_list=$list["device_number"];
- }
- }
5. 已页形式查询,并处理结果。
- public function index($version_id){
- $where=array(
- "version_id"=>$version_id
- );
- $version_name = model("Version")->where($where)->field("version_name")->find();
- $listrows=config("LISTROWS")?config("LISTROWS"):10;
- $package_lists=model("Package")->where($where)->paginate($listrows);
- $package_infos = $package_lists->toArray()["data"];
- foreach($package_infos as $key=>$value){
- $package_infos[$key] = array("source_version" => $version_name["version_name"]) + $package_infos[$key];
- }
- }
ThinkPHP5 查询数据并处理结果
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。