smarty中section嵌套循环

smarty中section嵌套循环  

2008-11-19 19:01:20|  分类： php |  标签： |字号大中小 订阅

在此```感谢网友"远方"的提示foreach取值 

  <select name="parentId" id="parentId">
          <option value="0">根分类</option>
    <{section name=big loop=$big}>
          <option value="<{$big[big].id}>"><{$big[big].type}></option>
     <{section name=small loop=$big[big].small}>
      <option value="<{$big[big].small[small].id}>">-<{$big[big].small[small].type}></option>
     <{/section}>
          <{/section}>
      </select>     

   $sqla="select * from ".$tabext."navigation where parentId=0";
   $allRecord=$db->getAllRecord($sqla);
    $classNameArray=array(); 
     foreach($allRecord as $v){
      $sqls="select * from ".$tabext."navigation where parentId=".$v['id'];
      $allRecords=$db->getAllRecord($sqls);
       $childNameArray=array();
       foreach($allRecords as $s){
        array_push($childNameArray,$s);
       }
       $v['small']=$childNameArray;
      array_push($classNameArray,$v);
     }
   $smarty->assign("big",$classNameArray);  

以下是根据没有用smarty程序风格的写法所写:

  <select name="ntype" id="ntype">
  <{section name=bigType loop=$bigType}>
    <option value="a"><{$bigType[bigType].type}></option>
    <{section name=smallType loop=smallType}>
     <option value="b"><{$smallType[smallType].type}></option>
      <{/section}>
   <{/section}>
  </select>   
+++++++++++++++++++++++++++++

   $sqla="select * from ".$tabext."navigation where parentId=0";
   $allRecord=$db->getAllRecord($sqla);
   
    for($i=0;$i<count($allRecord);$i++){
     $big[]=array("id"=>$allRecord[$i]['id'],"type"=>$allRecord[$i]['type']);
      $sqlb="select * from ".$tabext."navigation where parentId=".$allRecord[$i]['id'];
      $allRecords=$db->getAllRecord($sqlb);
       $countallRecords=count($allRecords);
        #debug($allRecords);
       if($countallRecords!=0){
        for($j=0;$j<countallRecords;$j++){
         $small[]=array("ids"=>$allRecords[$j]['id'],"types"=>$allRecords[$j]['type']);
         $smarty->assign('small',$small);
        }
     $smarty->assign('big',$big);
       } 
    }