这篇文章主要介绍了thinkphp 3.2框架视图模型 实例视图查询结果的二维数组合并操作,结合实例形式分析了thinkPHP3.2针对视图查询结果的数组合并相关操作技巧,需要的朋友可以参考下
本文实例讲述了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-600" } [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-600" } [2] => array(5) { ["picTitle"] => string(7) "标题2" ["picCategroy"] => string<mark style="color:transparent">来源gaodaimacom搞#代%码网</mark>(6) "海报" ["picAuthor"] => string(12) "星耀学园" ["picPostTime"] => string(19) "2014-11-26 11:59:50" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550273b753.jpg-600" } [3] => 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/54755027d8488.jpg-600" } [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-600" } [5] => 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/546da0784831c.png-600" } }
想要的结果是这样
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-600,attachment/picture/uploadify/20141126/54755027ab89b.jpg-600,attachment/picture/uploadify/20141126/547550273b753.jpg-600,attachment/picture/uploadify/20141126/54755027d8488.jpg-600" } ["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-600,attachment/picture/uploadify/20141120/546da0784831c.png-600" } }
完整实例开始
控制器 里 根据生成的SQL 语句在phpmyadmin里运行 出现排序规则不一致的情况 两个表的字段 排序规则不一致 整表排序规则一样的情况下
PictureController.class.php
public function Pic(){ $PicModel =D('PicView'); /* dump($PicModel);*/ $s1= $PicModel->field('picTitle,picCategroy,picAuthor,picPostTime,pictureurl')->order('picPostTime desc')->select(); /* dump($PicModel->getLastSql()); 查询最后的sql 语句*/ /* dump($s1);*/ $zhengli = $this->mergePictureURL($s1); /* dump( $zhengli );*/ $this->assign("content",$zhengli); $this->display(); }
视图模型里
PicViewModel.class.php
array('picTitle','picToken','picCategroy','picAuthor','picPostTime','_as'=>'Picture'), 'PictureAttachment' =>array('pictureid','pictureurl','creattime','_on'=>'Picture.picToken = PictureAttachment.pictureid','_as'=>'PictureAttachment'), ); }
视图里
<title></title> <!-- {$data.picTitle} {$data.picAuthor}发布时间：{$data.picPostTime}--> {$data.picTitle}
更多关于thinkPHP相关内容感兴趣的读者可查看本站专题：《ThinkPHP入门教程》、《thinkPHP模板操作技巧总结》、《ThinkPHP常用方法总结》、《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《Zend FrameWork框架入门教程》及《PHP模板技术总结》。
希望本文所述对大家基于ThinkPHP框架的PHP程序设计有所帮助。
以上就是thinkphp 3.2框架视图模型 实例视图查询结果的二维数组合并操作示例的详细内容，更多请关注gaodaima搞代码网其它相关文章！
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：thinkphp 3.2框架视图模型 实例视图查询结果的二维数组合并操作示例
转载请注明原文链接：thinkphp 3.2框架视图模型 实例视图查询结果的二维数组合并操作示例
