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

2023-07-29 13:11:04 352

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

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

array(6){
[0]=>array(5){
["picTitle"]=>string(7)"标题2"
["picCategroy"]=>string(6)"海报"
["picAuthor"]=>string(12)"星耀学园"
["picPostTime"]=>string(19)"2014-11-2611: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-2611: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-2611: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-2611: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-2016: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-2016: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-2611: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-2016:05:16"
["pictureurl"]=>string(111)"attachment/picture/uploadify/20141120/546da0746edb8.png,attachment/picture/uploadify/20141120/546da0784831c.png"
}
}

完整实例开始

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

PictureController.class.php

publicfunctionPic(){
$PicModel=D('PicView');

/*dump($PicModel);*/

$s1=$PicModel->field('picTitle,picCategroy,picAuthor,picPostTime,pictureurl')->order('picPostTimedesc')->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'),

);
}

视图里










{$data.picTitle}

更多关于thinkPHP相关内容感兴趣的读者可查看本站专题：《ThinkPHP入门教程》、《thinkPHP模板操作技巧总结》、《ThinkPHP常用方法总结》、《codeigniter入门教程》、《CI(CodeIgniter)框架进阶教程》、《ZendFrameWork框架入门教程》及《PHP模板技术总结》。

希望本文所述对大家基于ThinkPHP框架的PHP程序设计有所帮助。

声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：czq8825#qq.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。

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

热门推荐

随机推荐

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