快捷導(dǎo)航

thinkphp 3.2框架視圖模型實(shí)例視圖查詢結(jié)果的二維數(shù)組合并操作示例

更新時(shí)間：2020年03月10日 12:35:33 作者：星耀學(xué)園

這篇文章主要介紹了thinkphp 3.2框架視圖模型實(shí)例視圖查詢結(jié)果的二維數(shù)組合并操作,結(jié)合實(shí)例形式分析了thinkPHP3.2針對(duì)視圖查詢結(jié)果的數(shù)組合并相關(guān)操作技巧,需要的朋友可以參考下

本文實(shí)例講述了thinkphp 3.2框架視圖模型實(shí)例視圖查詢結(jié)果的二維數(shù)組合并操作。分享給大家供大家參考，具體如下：

使用視圖模型查詢的時(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)于thinkPHP相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《ThinkPHP入門(mén)教程》、《thinkPHP模板操作技巧總結(jié)》、《ThinkPHP常用方法總結(jié)》、《codeigniter入門(mén)教程》、《CI(CodeIgniter)框架進(jìn)階教程》、《Zend FrameWork框架入門(mén)教程》及《PHP模板技術(shù)總結(jié)》。

希望本文所述對(duì)大家基于ThinkPHP框架的PHP程序設(shè)計(jì)有所幫助。

您可能感興趣的文章: