Program Flowchart – Online Inventory Management System

List of Flowchart: System Flowchart Program Flowchart (Admin Dashboard) Program Flowchart (Admin User Management page) Program Flowchart ( Admin Add New User ) Program Flowchart (Admin Edit User) Program Flowchart ( Admin Category Management Page) Program Flowchart (Admin Brand Management) Program Flowchart (Admin New Brand) Program Flowchart ( Admin Edit Brand) Program Flowchart (Admin product … Continue reading Program Flowchart – Online Inventory Management System

How to reset Auto Increment back to 1 in XAMPP MySQL using phpMyAdmin

Once the system is up and running and you have done so many tests for your database entry the entries just kept on accumulating even when you deleted every records from the table, that has an AUTO Increment ID field, the delete option will not reset the Auto Increment.  There are two methods to reset the numbering: Method … Continue reading How to reset Auto Increment back to 1 in XAMPP MySQL using phpMyAdmin

Dynamically populate Select menu for region, province, and city of the Philippines

Technical Details MYSQL Generated from MySQL 5.6.21 Credits National Statistical Coordination Board     For Region: SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for refregion -- ---------------------------- DROP TABLE IF EXISTS `refregion`; CREATE TABLE `refregion` ( `id` int(11) NOT NULL AUTO_INCREMENT, `psgcCode` varchar(255) DEFAULT NULL, `regDesc` text, `regCode` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM … Continue reading Dynamically populate Select menu for region, province, and city of the Philippines