PHP classification list using loops _ PHP Tutorial-php Tutorial

Use loops to implement the PHP classification list. Html code... two foreach loops are used: divclassmodContent % foreachfrom $ sortitems % divclasscategoriesacronymclassiconacronymahrefcategory. php? Sort_id %

Html code... two foreach loops are used

1. < PClass = "modContent">
2. <% Foreach from = $ sort item = s %>
3. < PClass = "categories">
4. < AcronymClass = "icon"> </Acronym>
5. < AHref = "category. php? Sort_id =
   <% $ S. sort_id %>">
6. < Strong> <% $ S. sort_name %> </Strong>
7. </> < Br />
8. <% Foreach from = $ s. zi item = z %>
9. < AHref = "category. php? Sort_id =
   <% $ Z. sort_id %>"
10. Title = "<% $ z. sort_name %>">
11. <% $ Z. sort_name %>
12. </>
13. <%/Foreach %>
14. </P>
15. <%/Foreach %>
16. </P>

PHP code for the PHP classification list is simply to use foreach to loop through an array and insert an index to this array. The result is that all subcategories are queried each time.

 
 

  
  
// Product category
  
  
$ SQL = "SELECT * FROM 'hcl _ sort'
WHERE 'parent _ id' = 0 ORDER
'Sort _ id' DESC ";
  
  
$ Sort = $ db-> getAll ($ SQL );
  
  
Foreach ($ sort as $ key => $ val ){
  
  
$ Sort_id = $ sort [$ key] ['sort _ id'];
  
  
$ SQL = "SELECT * FROM 'hcl _ sort'
WHERE 'parent _ id' = {$ sort_id }";
  
  
$ Zi = $ db-> getAll ($ SQL );
  
  
$ Sort [$ key] ['zi'] = $ zi;
  
  
}
  
  
$ Tpl-> assign ('sort ', $ sort );
 
 

The above code is the specific solution to the PHP classification list.

Loop p class = modContent % foreach from = $ sort item = s % p class = categories acronym class = icon/acronym a href = category. php? Sort_id = %...