Posts

Showing posts from August, 2022

Auto/Taxi Stand Management System using PHP and MySQL | PHP Gurukul

Image
 “ Auto/Taxi Stand Management System ” is a web-based technology that will manage the records of the incoming and outgoing autos and taxis in a parking stand. It’s an easy for Admin to retrieve the data if the auto and taxi has been visited through the number he can get that data“Auto/Taxi Stand Management Project in PHP”  is an automatic system that delivers data processing in very high speed in a systematic manner. Project Requirements Project Name Auto/Taxi Stand Management System Project (Using PHP & MYSQLi) Language Used PHP5.6, PHP7.x Database MySQL 5.x User Interface Design HTML, AJAX,JQUERY,JAVASCRIPT Web Browser Mozilla, Google Chrome, IE8, OPERA Software XAMPP / Wamp / Mamp/ Lamp (anyone) Project Modules In “Auto/Taxi Stand Management System project”  we use PHP and MySQL database. This is the project which keeps records of the auto and taxi which is going to park in the stand. “Auto/Taxi Stand Management System”  have module i.e., admin and user. User User can only view

Garbage Management System using PHP and MySQL | PHP Gurukul

Image
  Garbage Management System using PHP and MySQL The world is in a stage of upgradation, there is one stinking problem we have to deal with. Garbage! In our daily life, we see pictures of garbage bins being overfull and all the garbage spills out. This leads to the number of diseases and insects and mosquitoes breed on it. A big challenge in urban cities is solid waste management not only in India but in most countries in the world. Hence, such a system has to be built that can eradicate this problem or at least reduce it to the minimum level. Project Requirements Project Name Garbage Management Project (Using PHP & MYSQLi) Language Used PHP5.6, PHP7.x Database MySQL 5.x User Interface Design HTML, AJAX,JQUERY,JAVASCRIPT Web Browser Mozilla, Google Chrome, IE8, OPERA Software XAMPP / Wamp / Mamp/ Lamp (anyone) Project Modules The garbage management System Project is a Web-based application. Get Full Details : https://phpgurukul.com/garbage-management-system-using-php-and-mysql In Ga

How to get Sales reports from the database using PHP | PHP Gurukul

Image
In this tutorial, we will learn how to get sales to report month-wise and year-wise in PHP from the database. In this example, we will guide you through a step-by-step procedure for sales records. Sales report data in PHP and MySQL will look as follows: Step1:  First create a database with name “salesmydb” where order data is stored. Step2:  Second is to create a table with the name “tblproduct” and insert the products data.   1 2 3 4 5 6 7 8 CREATE TABLE ` tblproduct ` (    ` ID ` int ( 10 ) NOT NULL ,    ` ProductName ` varchar ( 250 ) DEFAULT NULL ,    ` MRP ` decimal ( 10 , 0 ) DEFAULT NULL ,    ` SellingPrice ` decimal ( 10 , 0 ) DEFAULT NULL ,    ` CreationDate ` timestamp NULL DEFAULT current_timestamp ( ) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 ;   Step3:  Third step is to create a table with the name “tblorder” where order details data is stored.   1 2 3 4 5 6 7 8 9 CREATE TABLE ` tblorder ` (    ` ID ` int ( 5 ) NOT NULL ,    ` CustomerName ` varc