Table of Contents
Design tree structure product classification status, tree structure product classification
How to design a tree structure data table
Home Backend Development PHP Tutorial Design tree structure product classification status, tree structure product classification_PHP tutorial

Design tree structure product classification status, tree structure product classification_PHP tutorial

Jul 13, 2016 am 10:16 AM
header php Classification state structure design

Design tree structure product classification status, tree structure product classification

Design tree structure product classification status, tree structure product classification_PHP tutorial 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>>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/899961.htmlTechArticleDesign 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...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

How To Set Up Visual Studio Code (VS Code) for PHP Development How To Set Up Visual Studio Code (VS Code) for PHP Development Dec 20, 2024 am 11:31 AM

Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c

7 PHP Functions I Regret I Didn't Know Before 7 PHP Functions I Regret I Didn't Know Before Nov 13, 2024 am 09:42 AM

If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op

How do you parse and process HTML/XML in PHP? How do you parse and process HTML/XML in PHP? Feb 07, 2025 am 11:57 AM

This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an

Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Apr 05, 2025 am 12:04 AM

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

PHP Program to Count Vowels in a String PHP Program to Count Vowels in a String Feb 07, 2025 pm 12:12 PM

A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total

Explain late static binding in PHP (static::). Explain late static binding in PHP (static::). Apr 03, 2025 am 12:04 AM

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases? What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases? Apr 03, 2025 am 12:03 AM

What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.

See all articles