本文实例讲述了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) {
["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"
}
[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"] => string(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,attachment/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')->select();
/* dump($PicModel->getLastSql()); 查询最后的sql 语句*/
/* dump($s1);*/
$zhengli = $this->mergePictureURL($s1);
/* dump( $zhengli );*/
$this->assign("content",$zhengli);
$this->display();
}
视图模型里
PicViewModel.class.php
?php
namespace Home\Model;
use 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 charset="UTF-8">
title>/title>
/head>
body>
volist name="content" id="data">
!-- {$data.picTitle} {$data.picAuthor}发布时间：{$data.picPostTime}-->
{$data.picTitle}
/volist>
/body>
/html>
更多关于thinkPHP相关内容感兴趣的读者可查看本站专题：《ThinkPHP入门教程》、《thinkPHP模板操作技巧总结》、《ThinkPHP常用方法总结》、《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《Zend FrameWork框架入门教程》及《PHP模板技术总结》。
希望本文所述对大家基于ThinkPHP框架的PHP程序设计有所帮助。
您可能感兴趣的文章:- Thinkphp5.0框架视图view的模板布局用法分析
- Thinkphp5.0 框架视图view的比较标签用法分析
- Thinkphp5.0框架视图view的循环标签用法示例
- Thinkphp5.0 框架实现控制器向视图view赋值及视图view取值操作示例
- Thinkphp5框架实现获取数据库数据到视图的方法
- ThinkPHP视图查询详解
- thinkphp视图模型查询提示ERR: 1146:Table ''db.pr_order_view'' doesn''t exist的解决方法
- thinkphp3.2框架中where条件查询用法总结
- 基于thinkPHP3.2实现微信接入及查询token值的方法
- 分享ThinkPHP3.2中关联查询解决思路
