Loading...

Follow PHPGurukul | PHP Projects with Source Code on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Project Name                      :  Apartment Visitor Management System (AVMS)

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)

Apartment Visitors Management System

In AVMS we use PHP and Mysqli database. This is the project which keep records of visitors who visited in  the company. AVMS has one module i.e admin.

  1. Dashboard: In this sections, admin can briefly view how many visitors visited in a particular period.
  2. Visitors: In this section, admin adds new visitors by filling their information in add visitors sections and also view and manage visitors records. Admin also put visitors out time in the manage records section.
  3. Search: In this bar, admin can search a particular person by their name and phone number.
  4. Reports: In this section admin can generate visitors reports between two dates.

Admin can also update his profile, change password and recover password.

Some Project Screenshots

Admin Login Page

Admin Dashboard

New Visitor Page

Manage Visitors Page

How to run the Apartment Visitors Management System (AVMS) Project

1. Download the  zip file

2. Extract the file and copy avms folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)

4. Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with name avmsdb

6. Import avmsdb.sql file(given inside the zip package in SQL file folder)

7.Run the script http://localhost/avms (frontend)

Credential for admin panel :

Username: admin

Password: Test @123

View Demo———————————————————-

View Demo

Apartment Visitors Management System(Full Source Code)
Size: 3.57 MB
Version: V 1.0
Download Now!20 Downloads
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The MySQL LIMIT clause is used to narrow or limit, a result set to the specified number of rows.

The LIMIT clause accepts one or two arguments, one is offset and another one is count.

Offset: It is used to specify the offset of the first row to be returned.
Count: It is used to specify the maximum number of rows to be returned.

Syntax:

SELECT column_name(s) FROM  table_name LIMIT offset_number, count;

SELECT * FROM table_name LIMIT offset,count;

SELECT * FROM table_name LIMIT 10;

The query above will limit the result set to 10 rows.

When we will use argument in the limit clause, this argument will be used to return the maximum number of rows to be returned from the beginning of the result set.

SELECT column_name FROM table_name LIMIT count;

The above ex equivalent to this ex with the LIMIT clause that accepts two arguments.

SELECT column_name FROM table_name  LIMIT 0, count;
How to use OFFSET in the LIMIT Query.

The OFFSET value allows specifying which row to start from retrieving data.

Note: The OFFSET for the first row is 0 and not 1.

let’s suppose that if you want to retrieve data starting from the middle of the rows, then you can use the LIMIT keyword together with the OFFSET value to achieve that.

Table tblstudents
idNameRoll_noClass
1Anuj kumar10806121B.tech
2Sanjeev10883327MBA
3Amit13123121BA
4Rahul23424323LLB
Ex:
Select * from tblstudents limit 2;

The query above will limit the result set to 2rows.

Output
id Name Roll_no Class
1 Anuj kumar 10806121 B.tech
2 Sanjeev 10883327 MBA

Ex:

select * from tblstudents limit 2,2;

The query above has OFFSET=2, Hence 3rd row is return and LIMIT=2, Hence only 2 record will return

Output
id Name Roll_no Class
3 Amit 13123121 BA
4 Rahul 23424323 LLB
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Project Name                      :  Vehicle Parking Management System

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 Parking Management System using use PHP and MySQL

In VPMS we use PHP and MySQL database. This is the project which keeps records of the vehicle which is going to park in the parking area. VPMS has one module i.e. admin.

  1. Dashboard: In this sections, admin can briefly view the number of vehicle entries in a particular period.
  2. Category: In this section, admin can manage category (add/update).
  3. Add Vehicle: In this section, admin add vehicle which is going to park.
  4. Manage Vehicle: In this section, admin can manage incoming and outgoing vehicle and admin can also add parking charges and his/her remarks.
  5. Reports: In this section admin can generate vehicle entries reports between two dates.
  6. Search: In this section, admin can search a particular vehicle by parking number.

Admin can also update his profile, change the password and recover the password.

Some of the Project Screens

Login page

Admin Dashboard

How to run the Vehicle Parking Management System Project

1. Download the zip file
2. Extract the file and copy the vpms folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/HTML)
4. Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with name vpmsdb
6. Import vpmsdb.sql file(given inside the zip package in  sql file folder)
7.Run the script http://localhost/vpms (frontend)
Username: admin
Password: Test @123

Project Demo ——————————————

View Demo Project Download link

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Project Name                      :  Paying Guest Accommodation System

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)

In PGAS project we use PHP and  Mysql database. It has three modules.

1.Admin Module

2.PG Owner Module

3.User Module

Admin Module

  1. Dashboard: In this section, admin can see all detail in brief like total state, total city, total owner and total pg.
  2. State: In this section, admin can manage state(add/update).
  3. City: In this section, admin can manage city(add/update).
  4. Reg Owner: In this section, admin can view and edit registered owner.
  5. PG Details: In this section, admin can view pg detail which is listed by pg owner.
  6. Pages: In this section, admin can manage about us and contact us pages.

Admin can also update his profile, change the password and recover the password.

PG Owner Module

  1. Dashboard: In this section, owner can see all detail in brief like total listed pg, total booking, total new booking, total confirmed booking, and total canceled booking.
  2. List Your PG: In this section, owner can list their pg.
  3. Received Booking Request: In this section, admin can view new booking and he has right to confirmed booking.
  4. Search: In this section, the owner can search booking request by booking number.
  5. Notification: In this owner can see new notification of booking.

The owner can also update his profile, change the password and recover the password.

User Module

In this module, there is two types of user guest user and registered user.

Guest User: In this guest, user can see only general information like about us, pg details, search pg and contact details.

Registered users can do the following activity

1. Book the pg.

2. Update his/her own profile.

3. Change Password.

4. Registered user can also recover his/her own password.

Output Screens of the Project

Home Page

PG Details Page

User Signup Page

Owner Dashboard

How to run the Paying Guest Accommodation System (PGAS) Project

1. Download the  zip file

2. Extract the file and copy pgas folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)

4. Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with name pgasdb

6. Import pgasdb.sql file(given inside the zip package in SQL file folder)

7.Run the script http://localhost/pgas (frontend)

8. For owner panel

http://localhost/pgas /owner/login.php  (owner panel)

9. For admin panel

http://localhost/pgas /admin  (admin panel)

Credential for admin panel :

Username: admin Password: Test@123

Credential for user panel :

Username: testuser@gmail.com Password: Test@123

Credential for owner panel :

Username: pgtest@gmail.com Password: Test@123

View Demo ——————————

View Demo Project Download Link Download Event  Management System in Rs. 599/ $8.48

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Project Name                      :  Event Management System

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)

Event Management System Module

In EMS project we use PHP and MySQL database. It has two modules.

1.Admin Module

2.User Module

Admin Module

  1. Dashboard: In this section, admin can see all detail in brief like listed categories, Sponsors, Total Events, Total Registered Users, Total Booking, Total New Booking, Total Confirmed Booking and Total Cancelled Booking.
  2. Category: In this section, admin manage event category (add and update).
  3. Manage Sponsors: In this section, admin can add sponsors and manage sponsors details (Add/Update/Delete).
  4. Events: In this section, admin manage events (add and update).
  5. Manage Users: In this section, admin can update details of registered users and also block them.
  6. Manage Booking: In this section, admin can manage booking by cancel and confirm it.
  7. News: In this section admin manage news (add and delete).
  8. Website Setting: In this section, admin can update about us and another general website setting.

Admin can also update his profile, change password and recover password.

User Module

In this module there is two types of user guest user and registered user.

Guest User: In this guest user can see only general information like about us, event details,

contact details and new about events.

Registered users can do following activity

1.Books the events.

2.Update his/her own profile.

3.Change Password.

4.Users can also cancel booking which is not confirmed.

5.Registered user can also recover his/her own password.

Project Screen Shots

Home Page

User Signup

Admin Dashboard

Admin Manage booking

How to run the Event Management System (EMS) Project

1. Download the  zip file

2. Extract the file and copy ems folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)

4. Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with name ems

6. Import ems.sql file(given inside the zip package in SQL file folder)

7.Run the script http://localhost/ems (frontend)

8. For admin panel

http://localhost/ems/admin  (admin panel)

Credential for admin panel :

Username: admin Password: Test@12345

Credential for user panel :

Username: test30 Password: Test@123

View Demo ——————————

View Demo Project Download Link Download Event Management System in Rs. 699/ $9.90

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The comparison operators discussed so far have compared one value, exactly to one other value. Such precision may not always be desired or necessary. For this purpose MySQL provides the LIKE.

The LIKE allows comparison of one string value with another string value, which is not identical. This is achieved by using wildcard characters. Two wildcard characters that are available are :

For character data type:

  • % allows to match any string of any length (including zero length).
  • _ allows to match on a single character.
tblemployee table
idFnameLnameDepartment
1AnujKumarInformation Technology
2Ankit SinghFinance
3JhonDoeHR
Example 1 :
SELECT id,Fname,Lname,Department FROM tblemployee WHERE Fname LIKE 'An%';
Output
id Fname Lname Department
1 Anuj Kumar Information Technology
2 Ankit Singh Finance

In the above example all those records where the value held in the field Fname begins with An are displayed. The % indicates that any number of characters can follow the letters An.

Example 2:

List the employees whose names have the second character as n and h.

SELECT id,Fname,Lname,Department FROM tblemployee WHERE Fname LIKE '_n%' OR Fname like '_h%';
Output

idFnameLnameDepartment
1AnujKumarInformation Technology
2Ankit SinghFinance
3JhonDoeHR

In the above example, all those records where the value held in the Fname contains the second character as n or h are displayed. The _n and _h indicate that only one character can precede the character n or h. The % indicates that any number of characters can follow the letter An.

Example 3:

List the employees whose name start with the letters Jh and it is a four letter word.

SELECT id,Fname,Lname,Department FROM tblemployee WHERE Fname LIKE '_n%' OR Fname like 'Jh__';(i.e. two underscore characters)
Output

idFnameLnameDepartment
3JhonDoeHR

In the above example, all those records where the value held in the field Fname begins with Jh are displayed. The __(i.e. two underscore characters) indicates that only two characters can follow the letters Jh. This means the whole word will only be four characters.

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

In order to select data that is within a range of values, the BETWEEN operator is used. The BETWEEN operator allows the selection of rows that contain values with a specified lower and upper limit. The range coded after the word BETWEEN is inclusive.

The Lower value must be coded first. The two values in between the range must be linked with the keyword AND. The BETWEEN operator can be used with both character and numeric data types. However, the data types cannot be mixed i.e. the lower value of a range of values from a character column and other from a numeric column.

Syntax:

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Ex: MySQL Table tblemployee

id Emp_Name Emp_Code Emp_JoiningDate
1 Anuj Kumar 10806121 2018-05-01
2 Sanjeev Kumar 1908763 2018-08-10
3 Jonh Doe 10899781 2017-01-01

Ex1:

SELECT Emp_Name,Emp_Code from tblemployee WHERE id BETWEEN 2 and 3;

OUTPUT:

id Emp_Name Emp_Code Emp_JoiningDate
2 Sanjeev Kumar 1908763 2018-08-10
3 Jonh Doe 10899781 2017-01-01

Ex2 :

SELECT Emp_Name,Emp_Code from tblemployee WHERE Emp_JoiningDate BETWEEN '2016-12-01' and '2018-07-01';

Output :

id Emp_Name Emp_Code Emp_JoiningDate
1 Anuj Kumar 10806121 2018-05-01
3 Jonh Doe 10899781 2017-01-01

To find those employees whose id not between 1 and 2 , you can use BETWEEN operator with the NOT Operators as follows :

SELECT Emp_Name,Emp_Code from tblemployee WHERE id NOT BETWEEN 2 and 3;

Output:

id Emp_Name Emp_Code Emp_JoiningDate
1 Anuj Kumar 10806121 2018-05-01
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Project Name                      :  Daily Expense Tracking System

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)

Daily Expense Tracker System

In Daily Expense Tracker System we use PHP and MySQL database. This is the project which keeps records of daily expenses. DETS has one module i.e. user.

  1. Dashboard: In this section, admin can briefly view expenses on a daily basis, monthly basis and yearly basis.
  2. Expenses: In this section admin can manage the expenses(add/delete).
  3. Expense Report: In this section, admin can view expenses on day wise basis, month wise basis and year wise basis according to periods of time.
  4. Profile: In this section, admin can update his/her profile.
  5. Change Password: In this section, admin can change his/her passwords
  6. Logout: Through this button, user can log out.

User can also recover his/her password.

Some of the Project Screens

User Signup

User Login

User Dashboard

How to run the Daily Expense Tracking System Project

1. Download the zip file
2. Extract the file and copy dets folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
4. Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with name detsdb
6. Import detsdb.sql file(given inside the zip package in sql file folder)
7.Run the script http://localhost/dets (frontend)
Credential for user panel OR you can register your self:
Username: testuser@gmail.com
Password: Test @123

View Demo————————

View Demo

Download full source code(Daily Expense Tracker System)
Size: 2.86 MB
Version: V1.0
Download Now!243 Downloads

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Project Name                      :  Car Driving School Management System (CDSMS)

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)

Car Driving School Management System

In this project, we use PHP and  Mysql database. It has two modules, admin and user.

Admin Module

  1. Dashboard: In this section, admin can see all detail in brief like the total number of users, Total number of subscribes users and the total number of enquiry received.
  2. Packages: In this section, admin can manage packages(add and update).
  3. Applied Users: In this section, admin can view the detail of the user who wants to take training and also update the history of payments.
  4. Subscribed Users: In this section, admin can view subscribed users.
  5. Enquiry: In this section, admin can read new enquiry(unread enquiry) and view read enquiry(read enquiry).
  6. Pages: In this section, admin can manage about us and contact us pages.
  7. Search: In this section, admin can search users with the help of his/her registration number.
  8. Reports: In this section admin can view users detail in particular periods.

Admin can also update his profile, change the password and recover the password.

User Module

In CDSMS user not required to sign in

Home Page: User can subscribe with the driving school, user can view driving schools services and also put enquiries.

Apply Now: User can apply for training.

Enquiry: User put any enquiries.

Packages: User views the recent packages which offer by the driving school.

About Us: User can  see the detail of driving school

Contact Us: User can contact with the driving school.

Some Screens of the Project

Home Page

Application form

Admin Dashboard

Application Details Page How to run Car Driving School Management System Project

1. Download the zip file
2. Extract the file and copy cdsms folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
4. Open PHPMyAdmin (http://localhost/phpmyadmin)
5. Create a database with name cdsmsdb
6. Import cdsmsdb.sql file(given inside the zip package in sql file folder)
7.Run the script http://localhost/cdsms (frontend)
8. For admin panel http://localhost/cdsms/admin (admin panel)
Credential for admin panel :
Username: admin
Password: Test @321

View Demo ——————————

View Demo Project Download Link Download Car Driving School Management System in Rs. 399/ $5.65

  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

The data return by a SELECT query can be sorted into a specified order using ORDER BY clause.

Syntax:
SELECT column-name FROM table-name ORDER BY column-name;

When the ORDER BY keywords are followed by a table column name the retrieved data will be sorted into order based upon the type of data in the specified column. Typically, if the column data type is numerical, the retrieved data will be sorted in ascending numerical order. If the column data type is textual the retrieved data will be sorted into alphabetical order from A to Z.

Ex: MySQL Table tblemployee

id Emp_Name Emp_Code Emp_Email
1 Anuj Kumar 10806121 phpgurukulofficial@gmail.com
2 Sanjeev Kumar 1908763 sanjv @test.com
3 Jonh Doe 10899781 jonhdie@abc.com
SELECT  *  FROM  tblemployee ORDER BY id;

Output:

id Emp_Name Emp_Code Emp_Email
1 Anuj Kumar 10806121 phpgurukulofficial@gmail.com
2 Sanjeev Kumar 1908763 sanjv @test.com
3 Jonh Doe 10899781 jonhdie@abc.com
SELECT  *  FROM  tblemployee ORDER BY Emp_Name;

Output:

id Emp_Name Emp_Code Emp_Email
1 Anuj Kumar 10806121 phpgurukulofficial@gmail.com
3 Jonh Doe 10899781 jonhdie@abc.com
2 Sanjeev Kumar 1908763 sanjv @test.com
For viewing data in descending sorted order the word DESC must be mentioned after the column name and before the semi colon in the ORDER BY clause. In case there is no mention of the sort order, data will be sorted in ascending order by default.

Syntax:

SELECT * FROM table_name ORDER BY column-name SORT ORDER;

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview