Design tree structure product classification status, tree structure product classification

1 php 2 header('Content-Type: text/html; charset=utf-8'); 3 $mp = array( 4 'name' => 'mobile phone', 'children' => array( 5 array('name' => 'non-smartphone'), 6 array('name' => 'Smartphone', 'children' =>array( 7 array('name' => 'Android'), 8 array('name' => 'Mac'), 9 array('name' => 'WP machine') 10 )) 11 ) 12 ); 13 14 $cp =array( 15 'name' => 'Computer', 'children' => array( 16 array('name' => 'computer machine', 'children' => array( 17 array('name' => 'notebook'), 18 array('name' => 'Ultrabook'), 19 array('name' => 'Gamebook') 20 )), 21 array('name' => 'Computer Accessories', 'children' => array( 22 array('name' => 'CPU'), 23 array('name' => 'Motherboard') 24 )) 25 ) 26 ); 27 28 $goodsCats = array($mp, $cp); 29 30 //Recursively traverse all elements in $goodsCat 31 function tree($goodsCats, $deep=0){ 32 //1: Define a container to hold all categories 33 static $tree = array(); 34 //2: Define a variable to record the level of classification 35 ++$deep; 36 foreach($goodsCats as $goodsCat){ 37 $treeCat = array('name' => $goodsCat['name']); //Store the category name into the array 38 $treeCat['deep'] = $deep; //Store the classification level into the array 39 $tree[] = $treeCat; //Store the classification of each cycle 40 //Check whether there are subcategories under each category, if so, continue traversing 41 if(isset($goodsCat['children'])){ 42 tree($goodsCat['children'],$deep); 43 } 44 } 45 return $tree; 46 } 47 48 $treeData = tree($goodsCats); 49 50 foreach($treeData as $catData){ 51 echo str_repeat('------',($catData['deep']-1 )).$catData['name']."
"; 52 } View Code

How to design a tree structure data table

For example, the table structure I use is like this. You can refer to the name type constraint description below Name, duplicates are not allowed
type_father int is not allowed to be empty. The parent category identifier of this category, if it is a top node, set it to a unique value
type_layer char(6) Limited to 3 layers, the initial value is 000000 Category Pre-order traversal is mainly to reduce the number of database searches. According to this table structure, let's take a look at the data recorded in the table in the above example: type_id type_name type_father type_layer
1 Total category 0 000000
2 Category 1 1 010000
3 Category 1.1 2 010100
4 Category 1.2 2 010200
5 Category 2 1 020000
6 Category 2.1 5 020100
7 Category 3 1 030000
8 .1 7 030100
9 Category 3.2 7 030200
10 Category 1.1.1 3 010101
…… Now search according to the size of type_layer: SELECT * FROM Type_table_2 ORDER BY type_layer List the record set as follows: type_id type_name type_father type_layer
1 Total Category 0 000000
2 Category 1 1 010000
3 Category 1.1 2 010100
10 Category 1.1.1 3 010101
4 Category 1.2 2 010200
5 Category 2 1 020000
6...The rest of the full text>>

Provide some typical project names for programming in JAVA. Detailed descriptions will be appreciated

1: chat project
By completing a simulated online chat system, the Chat project mainly exercises everyone's abilities in TCP/IP, Socket programming, C/S mode programming, and the use of threads.
The knowledge points involved in this project include JavaSE, Socket, C/S, multi-threading, etc.

2: Tank stand-alone version/picture version/online version project
These three projects train everyone’s ability to comprehensively use JavaSE through the form of mini-games that everyone loves, and can initially use object-oriented Programming concepts, exercise preliminary design capabilities, and basically master multi-threaded programming.
The knowledge points involved in these three projects include JavaSE, Socket, C/S, multi-threading, AWT, GUI, event processing, Eclipse application, Debug debugging, use of property files, image processing, etc.

3: Design Pattern Version of Tank Battle
This project is a replacement for the above tank project. After previewing the above project, the focus of this project is to cultivate everyone’s understanding of design patterns. For design patterns, If you have a certain amount of code and understand object-oriented, it is very easy to understand a single design pattern, but for the comprehensive application of multiple design patterns, I am afraid that you need comprehensive practice. At the same time, for multi-layer architecture, SSH Frameworks, etc., if you want to understand them more thoroughly and at a lower level, design patterns are also essential. This project formally achieves understanding through the comprehensive use of multiple design patterns and prepares for subsequent courses.
The knowledge points involved in this project include JavaSE, multi-threading, AWT, GUI, event processing, Eclipse application, Debug debugging, property file application, Singleton mode, Factory series mode, Strategy mode, Observer mode, ChainOfResponsibility mode, Comprehensive application of Composite mode and design patterns, etc.

4: BBS2006 / BBS2007 project
The two projects of BBS have completed a forum system with complete front-end display and back-end management. The business logic of the forum system is familiar to everyone and is used for JavaWeb development. Excellent entry system. However, because its business logic is too simple, Shangxuetang has replaced it with search items in its current curriculum system.
The knowledge points involved in this project include JDBC, database, HTML, CSS, java script, AJAX, paging, tree structure design and presentation, JSP, Servlet, Session, etc.

6: Enterprise search project
Behind a simple page on Google and Baidu, cutting-edge technologies such as crawling/indexing/searching/caching play a decisive and supporting role. At the same time, , with the large number of applications such as enterprise knowledge base systems/knowledge management systems/document management systems, a large number of enterprises are in great need to apply search systems. This project builds an efficient search system through a series of open source search engine projects/spider programs. This system It can be fully applied in enterprise-level projects. At the same time, it helps students understand the principles of search engines. In addition, it also integrates preliminary user management/tree display and other knowledge points.
The knowledge points involved in this project include crawling, indexing, search, caching, JDBC, database, HTML, CSS, java script, AJAX, paging, tree structure design and display, JSP, Servlet, Session, etc. It also explains in detail the search-related open source series software (Lucene, etc.), and also introduces the principles of search engines in detail.

7: Jinshang Online Mall Project
This system integrates product display, product management, product category management, shopping cart, member management and other functions, providing easy operation, rich functions and complete permissions Management provides users with a low-cost, high-efficiency online mall construction solution. This project adopts a tree-like hierarchical design structure in the product category design; at the front desk, you can browse all product details by category, place an order to purchase goods, view the shopping cart status and feedback information from purchasing users; at the backend of the system, you can manage members and manage products And product categories...The rest of the full text>>