Dynamic Menu AdminLTE And Dashboard Page – Tutorial Build PHP Point Of Sale With PDO, MySQL And Jquery Part 2

In part 2, we only edit the file index.php (pos/application/main/index.php), header.php (pos/application/layout/header.php) and pos.php (pos/application/model/pos.php)

Tutorial PHP Point Of Sale System Part 2

Dynamic Navigation Menu PHP And MySQL

I have discussed “how to create a dynamic menu on adminLTE” on some of my previous articles:

• Tutorial Create Dynamic Sidebar Menu on MySQL, Node.js, Express, AdminLTE For Beginner.
• Create Dynamic Sidebar Multilevel Menu in AdminLTE with MySQL, PHP, and PDO.
• How To Create User Permissions View To Dynamic Sidebar Menu AdminLTE.
• Creating dynamic sidebar menu with Mysql and AdminLTE Bootstrap Template.

I will not discuss in detail how to create this menu, but you can read some of my articles above to understand more. The primary purpose of this article is to create a PHP point of sale system that is safe and has a dynamic menu (to manage the menu navigation flexibly and efficiently).

To start making this menu, make sure you have created the m_user table in tutorial part 1. Then create 2 more tables with the name r_menu and r_sub_menu as follows.

In addition to the 2 tables above, please create a r_ref_system table to accommodate the main data of the application. r_ref_system table structure like the following picture:

Until this step, we have succeeded to create 4 tables in the pos database.

Add some of the following MySQL queries to fill the table r_menu and r_submenu :

Execute the MySQL query below to fill the table r_ref_system

Edit the header.php file (pos/application/layout/header.php) and fill in the following script:

Brief Description : 

The PHP navigation menu code is placed here. We store user menu permissions in the h_menu field in a string format delimited by commas. For example, “1,2,3.”

Then in the header.php file, we break up the h_menu into an array. The next step is to check the submenu code in the array. If the submenu code is in an array formed from h_menu, then the submenu will be displayed

Create Dashboard in PHP

Edit the index.php file (pos/application/main/index.php) and fill in the following script:

Edit the pos.php file (pos/application/model/pos.php) and add the following script:

Brief Description :

On the dashboard page, we create a table for item search. But the item search module does not work in this chapter, we will discuss it in the next tutorial.

To tests the dynamic menu please add the value in a h_menu field in the m_user table. Change the menu to 1,2 or 1,3 and see the result.

you can download the entire php point of sale project in the tutorial part 5 here.

Conclusion

Creating a dynamic navigation menu and Adminlte dashboard does not require a long time. Adminlte is a free dashboard framework that is easily customized according to the goals to be achieved.

List of PHP point of sale tutorials:

1. Create login page – Tutorial Build PHP Point Of Sale Part 1.
2. Create Dynamic Menu and Dashboard Page -PHP Point Of Sale Tutorial Part 2.
3. Create Master User Form – PHP Point Of Sale Tutorial Part 3
4. Create Master Item / Product Form – PHP Point Of Sale Tutorial Part 4
5. Create Sales Form / Point of sale – PHP Point Of Sale Tutorial Part 5

I think the 2nd part tutorial is pretty easy, so I don’t need to explain in detail. Up here Tutorial Build PHP Point Of Sale With, PDO, MySQL And Jquery Part 2 has been completed, In the next article will discuss how to create master user page in PHP point of sale tutorial.