本文实例讲述了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>
黄山市民网：https://www.huangshanshimin.com/
