Posts

Showing posts from July, 2022

Global Vehicle Rental Management System using PHP and MySQL | PHP Gurukul

Image
  Project Name                :  Vehicle Rental Management System Project (VRMS) Language Used                   :   PHP Database                              :   MySQL User Interface Design       :   HTML, AJAX,JQUERY,JAVASCRIPT Web Browser                       :   Mozilla, Google Chrome, IE8, OPERA Software                               :   XAMPP / Wamp / Mamp/ Lamp (anyone) Vehicle Rental Management System is web application which provides vehicle on rent to the register users. In this project, we use PHP and MySQL database. It has two modules. Admin Users Admin Dashboard:  In this section, admin can see two-wheeler and four-wheeler vehicle detail in brief. Brand:  In this section, admin can manage brands (Add/Update). Two Wheeler:  In this section, admin can manage two-wheeler vehicles (Add/Update). Four Wheeler:  In this section, admin can manage a four-wheeler vehicle (Add/Update). Pages:  In this section, the admin can manage about us and contact us pages. Reg Users:  In this

How to Search Employee data from Database using PHP | PHP Gurukul

Image
 In this tutorial, we will learn how to search employee records on the basis of their name, email, mobile number, and employee id in PHP from the database. In this example, we will guide you a step-by-step procedure to search employee records. Search employee data in PHP and MySQL will look as follows. Step1:  First create a database with name “betdb” where employee data is stored. Step2:  Second is to create a table with the name “tblempdata” and insert the employee data. Table Structure   1 2 3 4 5 6 7 8 9 10 11 CREATE TABLE ` tblempdata ` (    ` ID ` int ( 5 ) NOT NULL ,    ` EmployeeName ` varchar ( 200 ) DEFAULT NULL ,    ` Department ` varchar ( 200 ) DEFAULT NULL ,    ` Email ` varchar ( 200 ) DEFAULT NULL ,    ` MobileNumber ` varchar ( 200 ) DEFAULT NULL ,    ` EmpID ` varchar ( 200 ) DEFAULT NULL ,    ` JoiningDate ` date DEFAULT current_timestamp ( ) ,    ` PostingDate ` timestamp NULL DEFAULT current_timestamp ( ) ) ENGINE = InnoDB DEFAULT CHARSE