Tuesday, June 3, 2014

Engine Monitoring System in PHP and MySQL

This application is written in PHP and MySQL designed to monitor the engine usage in a company. It monitors how many hours the engine runs. It is primarily for the maintenance of the engine in a factory or manufacturing firm. It also stores how many kilowatt hour being consumed by the engine.
This program has a menu for a navigation of the user. The first menu is to add records about the engine; it will store all the records in the database. The second navigation link is the view of records which allows the user of the system to view the list of dates, engine serial number, number of how the engine run and the kilowatt hour consume by the said engine. The third navigational link is for the search of record. In the search record the program will ask the user to enter the engine serial number to be search and the date it will search for the specific records that matched with the criteria given by the user.
The tools that I used in making this application are notepad++ that is free to download from the internet at http://notepad-plus-plus.org/. This editor is good in writing html, css, javascript, php and mysql codes. It is very user friendly and very easy to use. This editor is highly recommended for those beginners in web programming.
The PHP and MySQL compiler used is XAMPP that can be downloaded freely at http://www.apachefriends.org/en/xampp.html. Very nice PHP and MySQL compiler to be used the user interface is excelled to navigated. In terms of the web browser, I’m using Google chrome which is very good in testing your web pages and websites.
In using my code, once you download the code extract the code in the directory of xampp in htdocs and then create a database name engine at the phpmyadmin and then select the database named engine and then select import choose the sql dumb file named engine.sql and select go button. To create the table name records and insert a couple of records in the table.
After you have done that you are already to run the script, make sure you create a folder under htdocs, for example engine and put those downloaded file on it. In testing about this program in your web browser address bar type the following: let say http://localhost/engine/index.php it will run the index.php as your main menu of the system. But before you run make sure the XAMPP system is activated. I hope you will able to run successfully.
                      


Sample Output of Our Program



                    

No comments:

Post a Comment