. How to manage multi level categories in PHP and MySQL Skip to main content

How to manage multi level categories in PHP and MySQL

For the websites it is common to manage articles, products and much more thing by categories. And these categories have child categories and these child also have child and so in.

So this article will show you that how to manage the Multi-level categories tree in PHP and MySql.

First of all we need a Database table to store all categories.

 CREATE TABLE `tblcategory` (  
 `id` int(10) NOT NULL auto_increment,  
 `pid` int(10) NOT NULL default '0',  
 `title` varchar(255) NOT NULL,  
 PRIMARY KEY (`id`)  
 );

Multilevel categories tree in database table.multilevel-categories-php-mysql



Now time to get list of all categories with parent and their child, grand child and so on. There are two way to find all categories.

1. First solution that all knows, Recursion  

In Recursion, first get all main parents categories and then start a loop and fetch all subcategories with their parent id's.

 function showCategories($cat_id = 0, $dashes = ''){  
      $dashes .= '--';  
      $rsSub = mysql_query("SELECT id, pid, title FROM tblcategory WHERE pid = " . $cat_id) or die(mysql_error());  
      if(mysql_num_rows($rsSub) > 0){  
           while($rows_sub = mysql_fetch_array($rsSub)){  
                echo $dashes . $rows_sub['title'] . "</br>";  
                if($rows_sub['pid'] != 0){  
                     showSubCategories($rows_sub['id'], $dashes);  
                }  
           }  
      }  
 }

2. Second solution, We can also get all categories by PHP REFERENCES.

By this method we fetch all categories at a time and set them with their parents with the help of Reference.


 $refs = array();  
 $list = array();  
 $sql = "SELECT item_id, parent_id, name FROM items ORDER BY name";  
 $result = mysql_query($sql);  
 while($data = @mysql_fetch_assoc($result)) {  
      $thisref = &$refs[ $data['item_id'] ];  
      $thisref['parent_id'] = $data['parent_id'];  
      $thisref['name'] = $data['name'];  
      if ($data['parent_id'] == 0) {  
           $list[ $data['item_id'] ] = &amp;$thisref;  
      } else {  
           $refs[ $data['parent_id'] ]['children'][ $data['item_id'] ] = &$thisref;  
      }  
 }
Labels:

Comments

Post a Comment

Popular posts from this blog

Create app in phonegap in windows

Phonegap (Cordova) is a tool that allows creating native mobile app using HTML, CSS and Javascript. This article shows you, how to create application and deploy them to various native mobile platforms using the cordova command-line interface (CLI). Install Cordova using CLI Follow these steps to install: Download and install Node.js . Following installation, you should be able to invoke node and npm on your command line. Install the cordova module using npm utility of Node.js. The cordova module will automatically be downloaded by the npm utility.   $ npm install -g cordova Create APP: Go to the directory where you maintain your source code, and run a command such as the following: using command. Create hello app: $ cordova create hello com.example.hello HelloWorld This command will create a folder ‘HelloWorld’. All subsequent commands need to be run within the project's directory, or any subdirectories. So go to in this folder ‘cd HelloWorld’. Add the pl...
Post a Comment
Read more

Connecting to Socket in React Native app

Connecting to a socket in a React Native app requires the use of a socket library that supports React Native. One popular library is socket.io-client . Here are the steps to connect to a socket using socket.io-client in a React Native app: Install socket.io-client by running the following command in your project directory: npm install socket.io-client 2. Import the library in your code: import io from 'socket.io-client'; 3. Create a socket instance by calling the io function and passing in the URL of the socket server: const socket = io('http://example.com'); Replace http://example.com with the URL of your socket server. 4. Add event listeners to the socket instance to handle incoming events: socket.on('connect', () => { console.log('Connected to socket server'); }); socket.on('event', (data) => { console.log('Received data:', data); }); Replace event with the name ...
Post a Comment
Read more

Know about the Web Socket and setup WebSocket in Javascript HTML page

  WebSockets is a protocol for providing full-duplex communication channels over a single TCP connection. It allows for real-time, two-way communication between a client and a server, which makes it ideal for web applications that require continuous updates from the server or that need to send frequent updates to the server. Here are some basic information about WebSockets: WebSockets are designed to work over a single TCP connection, which means that they are more efficient than other protocols like HTTP that require multiple connections for each request/response cycle. WebSockets use a persistent connection between the client and server, which allows for real-time communication without the need for frequent polling or long-polling requests. The WebSocket protocol uses a message-based model for sending and receiving data, which means that data is transmitted as a stream of messages rather than a series of HTTP requests and responses. WebSockets support binary data transmission, wh...
Post a Comment
Read more