您好,登錄后才能下訂單哦!
這篇文章給大家分享的是有關(guān)thinkphp3.2如何將視圖查詢結(jié)果的二維數(shù)組進(jìn)行合并的內(nèi)容。小編覺(jué)得挺實(shí)用的,因此分享給大家做個(gè)參考,一起跟隨小編過(guò)來(lái)看看吧。
具體如下:
使用視圖模型查詢的時(shí)候 結(jié)果是這樣的
array(6) { [0] => array(5) { ["picTitle"] => string(7) "標(biāo)題2" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-26 11:59:50" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550278b7db.jpg" } [1] => array(5) { ["picTitle"] => string(7) "標(biāo)題2" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-26 11:59:50" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027ab89b.jpg" } [2] => array(5) { ["picTitle"] => string(7) "標(biāo)題2" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-26 11:59:50" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/547550273b753.jpg" } [3] => array(5) { ["picTitle"] => string(7) "標(biāo)題2" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-26 11:59:50" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141126/54755027d8488.jpg" } [4] => array(5) { ["picTitle"] => string(33) "同步寫(xiě)入信息和附件表里" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-20 16:05:16" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0746edb8.png" } [5] => array(5) { ["picTitle"] => string(33) "同步寫(xiě)入信息和附件表里" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-20 16:05:16" ["pictureurl"] => string(55) "attachment/picture/uploadify/20141120/546da0784831c.png" } }
想要的結(jié)果是這樣
array(2) { ["0"] => array(5) { ["picTitle"] => string(7) "標(biāo)題2" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["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) "同步寫(xiě)入信息和附件表里" ["picCategroy"] => string(6) "海報(bào)" ["picAuthor"] => string(12) "星耀學(xué)園" ["picPostTime"] => string(19) "2014-11-20 16:05:16" ["pictureurl"] => string(111) "attachment/picture/uploadify/20141120/546da0746edb8.png,attachment/picture/uploadify/20141120/546da0784831c.png" } }
完整實(shí)例開(kāi)始
控制器 里 根據(jù)生成的SQL 語(yǔ)句在phpmyadmin里運(yùn)行 出現(xiàn)排序規(guī)則不一致的情況 兩個(gè)表的字段 排序規(guī)則不一致 整表排序規(guī)則一樣的情況下
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 語(yǔ)句*/ /* 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}發(fā)布時(shí)間:{$data.picPostTime}--> {$data.picTitle} </volist> </body> </html>
感謝各位的閱讀!關(guān)于“thinkphp3.2如何將視圖查詢結(jié)果的二維數(shù)組進(jìn)行合并”這篇文章就分享到這里了,希望以上內(nèi)容可以對(duì)大家有一定的幫助,讓大家可以學(xué)到更多知識(shí),如果覺(jué)得文章不錯(cuò),可以把它分享出去讓更多的人看到吧!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。