thinkphp 3.2框架视图模型实例视图查询结果的二维数组合并操作示例

更新时间:2023-04-08 15:23:03 阅读：评论：0

本文实例讲述了thinkphp 3.2框架视图模型实例视图查询结果的二维数组合并操作。分享给大家供大家参考，具体如下：

使用视图模型查询的时候结果是这样的

array(6) { [0] => array(5) {  ["pictitle"] => string(7) "标题2"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-26 11:59:50"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550278b7db.jpg" } [1] => array(5) {  ["pictitle"] => string(7) "标题2"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-26 11:59:50"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027ab89b.jpg" } [2] => array(5) {  ["pictitle"] => string(7) "标题2"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-26 11:59:50"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550273b753.jpg" } [3] => array(5) {  ["pictit身边那些有特点的人le"] => string(7) "标题2"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-26 11:59:50"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027d8488.jpg" } [4] => array(5) {  ["pictitle"] => string(33) "同步写入信息和附件表里"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-20 16:05:16"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0746edb8.png" } [5] => array(5) {  ["pictitle"] => string(33) "同步写入信息和附件表里"  ["piccategroy"] => st杨梅酒的制作方法步骤ring(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-20 16:05:16"  ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0784831c.png" }}

想要的结果是这样

array(2) { ["0"] => array(5) {  ["pictitle"] => string(7) "标题2"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-26 11:59:50"  ["pictureurl"] => string(申之以孝悌之义223) "attachment/picture/uploadify/20141126/547550278b7db.jpg,attachment/picture/uploadify/20141126/54755027ab89b.jpg,attachment/picture/uploadify/20141126/547550273b753.jpg,attachment/picture/uploadify/20141126/54755027d8488.jpg" } ["1"] => array(5) {  ["pictitle"] => string(33) "同步写入信息和附件表里"  ["piccategroy"] => string(6) "海报"  ["picauthor"] => string(12) "星耀学园"  ["picposttime"] => string(19) "2014-11-20 16:05:16"  ["pictureurl"] => string(111) "attachment/picture/uploadify/20141120/546da0746edb8.png,attac自由投档hment/picture/uploadify/20141120/546da0784831c.png" }}

完整实例开始

控制器里根据生成的sql 语句在phpmyadmin里运行出现排序规则不一致的情况两个表的字段排序规则不一致整表排序规则一齐民样的情况下

picturecontroller.class.php

  public function pic(){     $picmodel =d('picview');    /* dump($picmodel);*/    $s1= $picmodel->field('pictitle,piccategroy,picauthor,picposttime,pictureurl')->order('picposttime desc')->lect();   /* dump($picmodel->getlastsql()); 查询最后的sql 语句*/   /* dump($s1);*/    $zhengli = $this->mergepictureurl($s1);   /* dump( $zhengli );*/    $this->assign("content",$zhengli);    $this->display();  }

视图模型里

picviewmodel.class.php

<?phpnamespace home\model;u think\model\viewmodel;class picviewmodel extends viewmodel{  public $viewfields =array(    'picture'=> array('pictitle','pictoken','piccategroy','picauthor','picposttime','_as'=>'picture'),    'pictureattachment' =>array('pictureid','pictureurl','creattime','_on'=>'picture.pictoken = pictureattachment.pictureid','_as'=>'pictureattachment'),  );}

视图里

<!doctype html><html><head lang="en">  <meta chart="utf-8">  <title></title></head><body><volist name="content" id="data"> <!-- {$data.pictitle} {$data.picauthor}发布时间：{$data.picposttime}-->  {$data.pictitle}</volist></body></html>

本文发布于:2023-04-08 15:23:02，感谢您对本站的认可！

本文链接：https://www.wtabcd.cn/fanwen/zuowen/2c0a6734420c788fefc5078a1a2c3395.html

本文word下载地址：thinkphp 3.2框架视图模型实例视图查询结果的二维数组合并操作示例.doc

本文 PDF 下载地址：thinkphp 3.2框架视图模型实例视图查询结果的二维数组合并操作示例.pdf

上一篇：PHP终止脚本执行的实例代码

下一篇：返回列表