Untitled

[phpgurukul1]

Online Library Management System using Python Django and MySQL

Library management system is a project which aims in developing a computerized system to maintain all the daily work of library .This project has many features which are generally not available in normal library management systems like facility of user login and a facility of admin login .It also has a facility of admin login through which the admin can monitor the whole system. It has also a facility where student after logging in their accounts can see list of books issued and its issue date and return date.

Click: https://phpgurukul.com/online-library-management-system-using-python-django-and-mysql/

Project Modules

In this project we use Python, Django Framework and MySQL database and it has two modules i.e.

Admin and User

Admin

Admin Dashboard

Admin can add/update/ delete category

Admin can add/update/ delete author

Admin can add/update/ delete books

Admin can issue a new book to student and also update the details when student return book

Admin can search student by using their student ID

Admin can also view student details

Admin can change own password

Students-

Student can register yourself and after registration they will get studentid

After login student can view own dashboard.

Student can update own profile.

Student can view issued book and book return date-time.

Student can also view the available books in the library.

Student can also change own password.

Student can also recover own password.

How to run the Online Library management System Django Python

1. Download the zip file

2. Extract the file, copy library folder, and paste it on the desktop

3. Open MySQL Create a database olmspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\library\

6. Now Navigate to the olms folder

cd olms

7. Run the Project using the following command

python manage.py runserver

Click: https://phpgurukul.com/online-library-management-system-using-python-django-and-mysql/

[phpgurukul1]

Medical Card Generation System using PHP and MySQL

The ‘Medical Card Generations System using PHP and MySQL’ has been designed to override the problem of existing manual system. This web application is supported to eliminate and in some case reduce the hardship faced by manual system. The application is reduced as much as possible to avoid errors while entering the data. It’s also provide message while entering invalid data. No formal knowledge is required for the user to operate this system. Overall we said that ‘Medical Card Generations System’ is user friendly.

Project Modules

In ‘Medical Card Generations System’ we use PHP and MySQL Database. This project keeps the records of medical cards. ‘Medical Card Generations System’ has two module i.e. admin and user.

Admin Module

Dashboard: In this section, admin can briefly view the total medical card created in today’s, yesterday’s and in seven days, total read and unread enquiries.

Medical Card: In this section, admin can manage medical cards (add/delete/update).

Page: In this section, admin can manage about us and contact us pages.

Enquiry: In this section, admin reads the inquiries which are sent by users.

Search: In this section, admin can search a particular medical cards by reference number.

Reports of Medical Cards: In this section admin can view and check medical card details in a particular period.

Click: https://phpgurukul.com/medical-card-generation-system-using-php-and-mysql/

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

User Module

Home Page: User can visit home page.

Medical Card: User can view his/her medical card and take print with the help of their Reference Number.

About Us: User sees the details of .website administrator.

Contact Us: User can contact with website administrator and sent enquiry to them.

Note: In this project, the MD5 encryption method was used.

How to run the Medical Card Generation System Project using PHP and MySQL

1. Download the project zip file

2. Extract the file and copy mcgs 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 the name mgsdb

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

7. Run the script http://localhost/mcgs

Click: https://phpgurukul.com/medical-card-generation-system-using-php-and-mysql/

[phpgurukul1]

Hospital Management System using Python Django and MySQL

Hospital Management System using Python Django and MySQL is web based application.The project Hospital Management system includes registration of patients, storing their details into the system. The software has the facility to give a unique id for every patient and stores the details of every patient.

Project Modules

Hospital Management System is web application for hospital which manages doctors and patients. In this project, we use Python with Django framework and MySQL database.

Click: https://phpgurukul.com/hospital-management-system-using-python-django-and-mysql/

The entire project mainly consists of 3 modules, which are

Admin module

User module (patient)

Doctor module

Admin module:

Dashboard: In this section, admin can view the Total Registered Doctors and Total Specializations.

Doctors List: In this section, admin can view doctor’s profile, their appointments and manage their patient list.

Reg Users: In this section, admin can view users detail (who take online appointment) and also have right to delete irrelevant user.

Patients: In this section, admin can view patient’s details.

Appointment History: In this section, admin can view appointment history.

Search Doctor: In this section, admin can search doctor details by their name and mobile number.

Doctor Reg Reports: In this section, admin can view reports of doctor in particular periods.

Webpage Page: In this section, admin can update the website page details.

Patient Search: In this section, admin can search patient with the help of patient name and mobile number.

Admin can also change his/her own password and profile.

User module (patient):

Dashboard: This is welcome page of user.

Book Appointment: In this section, Patient can book his/her appointment.

Appointment History: In this section, Patients can see his/her own appointment history.

User can update his/her profile, change the password and recover the password

Doctor module:

Dashboard: In this section, doctor can view total appointment, new appointment, approved appointment, cancelled appointment and total patient added by them.

Appointment: In this section, Doctor can see patient’s appointment status.

Patients: In this section, doctor can manage patients (Add/Update).

Search: Search has below sections:

Search Patient: In this section, doctor can search patient with the help of patient name and mobile number.

Search Appointment: In this section, doctor can search User(patient) with the help of name and mobile number.

Report: Report has below sections:

Appointment Report: In this section, doctor can generate between dates report of appointment which is take by registered users (patients).

Patient Report: In this section, doctor can generate between dates reports of patients which doctors add.

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

How to run the Hospital Management system Django Python

1. Download the zip file

2. Extract the file, copy hms folder, and paste it on the desktop

3. Open MySQL Create a database hmspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\hms\

6. Now Navigate to the hospital folder

cd hospital

7. Run the Project using the following command

python manage.py runserver

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

News Portal using Python Django and MySQL

News Portal using Python Django and MySQL - PHPGurukul

...

News Portal using Python Django and MySQL is a web application used to publish the News.

The aim of “Online News Portal” is to automate its existing manual system by the help of computerized equipment and full-fledge computer software, fulfilling their requirements so that their valuable date can be stored for a longer period with easy accessing and manipulation of the same. ces.

[phpgurukul1]

Online Notes Sharing System using Python Django and MySQL

Online Notes Sharing Management System using Python Django and MySQL is a web based technology which manages user and notes database and provides rights to update their details and notes.

Online Notes Sharing Management System project manage user information and notes which is provided by him/her. User’s also have rights to update their details and notes. In this web application user must be registered. The aim of this web application is to manage user and notes database.

Click here: https://phpgurukul.com/online-notes-sharing-system-using-python-django-and-mysql/

How to run the Online Notes Sharing System Django Python

1. Download the zip file

2. Extract the file, copy nss folder, and paste it on the desktop

3. Open MySQL Create a database nsspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\nss

6. Now Navigate to the Notes Sharing Folder folder

cd notessharing

7. Run the Project using the following command

python manage.py runserver

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Art Exhibition Management System using Python Django and MySQL

The Art Exhibition Management System Project using Python Django and MySQl has been designed to override the problem of existing manual system. This web application is supported to eliminate and in some case reduce the hardship faced by manual system. The application is reduced as much as possible to avoid errors while entering the data. It’s also provide message while entering invalid data. No formal knowledge is required for the user to operate this system. Overall we said that Art Exhibition Management System is user friendly.

Click here: https://phpgurukul.com/art-exhibition-management-system-using-python-django-and-mysql/

Project Modules

In Art Exhibition Management System we use Python, Django Framework and MySQL database. This project keeps the records of user enquiry, art products and art artist. Art Exhibition Management System has two module i.e. admin and user.

Admin Module

1. Dashboard: In this section, admin can briefly view the total number of artist, total answer enquiry, total unanswer enquiry, Total Art Type, total art medium and total art products.

2. Art Type: In this section, admin can manage art type (add/delete/update).

3. Art Medium: In this section, admin can manage art medium(add/update/delete).

4. Art Product: In this section, admin can manage art products(add/update/delete).

5. Enquiry: In this section, admin can view and maintain the enquiry.

6. Search Enquiry: In this section admin, can search enquiry with the help of enquiry number.

6. Page: 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.

User Module

1. Home: It is a welcome page for users.

2. About: It is an about us page of website.

3. Art Product: In this section, users can view art products and sent enquiry for that products.

4. Contact: In this section, users can view contact us details.

3. Art Type: In this section, users can view art products according to art type and sent enquiry for art products.

How to run the Art Exhibition Management System Django Python

1. Download the zip file

2. Extract the file, copy artexhibition folder, and paste it on the desktop

3. Open MySQL Create a database artpythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\artexhibition

6. Now Navigate to the artexhibition Folder folder

cd artexhibition

7. Run the Project using the following command

python manage.py runserver

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

News Portal using Python Django and MySQL

News Portal using Python Django and MySQL is a web application used to publish the News.

The aim of “Online News Portal” is to automate its existing manual system by the help of computerized equipment and full-fledge computer software, fulfilling their requirements so that their valuable date can be stored for a longer period with easy accessing and manipulation of the same. ces.

Project Module

News has three modules i.e. user, admin, sub-admins

User module

Anyone can read the news and also search for particular news. The reader can leave comments on the particular news.

Admin Module

Secure admin login system

Admin Dashboard: In this section admin can view, listed categories & sub categories, total published news.

Sub-admin: In this section, admin can add/edit/delete sub-admin.

Category — In this section admin can add/update/delete the category. Admin can also restore deleted category.

Sub- Category — In this section admin can add/update/delete the Subcategory. Admin can also restore deleted Subcategory.

Post — Admin can add /update / delete news posts. admin can also view deleted news post in trash post section and restore deleted posts.

Pages — Admin can manage the contact of about us and contact us page.

Comments — Admin can approve/ unapproved / delete reader comments.

Click Here: https://phpgurukul.com/news-portal-using-python-django-and-mysql/

Sub-Admin Module

Sub-Admin and Admin features are the same except Sub-Admin creation. Sub-Admin can’t create the Sub-Admins.

How to run the News Portal System Django Python

1. Download the zip file

2. Extract the file, copy newsportal folder, and paste it on the desktop

3. Open MySQL Create a database newspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\newsportal\

6. Now Navigate to the onps folder

cd onps

7. Run the Project using the following command

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Online Library Management System using Python Django and MySQL

Library management system is a project which aims in developing a computerized system to maintain all the daily work of library .This project has many features which are generally not available in normal library management systems like facility of user login and a facility of admin login .It also has a facility of admin login through which the admin can monitor the whole system. It has also a facility where student after logging in their accounts can see list of books issued and its issue date and return date.

Click: https://phpgurukul.com/online-library-management-system-using-python-django-and-mysql/

Project Modules

In this project we use Python, Django Framework and MySQL database and it has two modules i.e.

Admin and User

Admin

Admin Dashboard

Admin can add/update/ delete category

Admin can add/update/ delete author

Admin can add/update/ delete books

Admin can issue a new book to student and also update the details when student return book

Admin can search student by using their student ID

Admin can also view student details

Admin can change own password

Students-

Student can register yourself and after registration they will get studentid

After login student can view own dashboard.

Student can update own profile.

Student can view issued book and book return date-time.

Student can also view the available books in the library.

Student can also change own password.

Student can also recover own password.

How to run the Online Library management System Django Python

1. Download the zip file

2. Extract the file, copy library folder, and paste it on the desktop

3. Open MySQL Create a database olmspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\library\

6. Now Navigate to the olms folder

cd olms

7. Run the Project using the following command

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Staff Leave Management System Using Django Python SQLite

The Staff Leave Management System (SLMS) is a web-based application that can be accessed throughout the organization or a specified group/Dept. Staff Leave Management System Project can be used to automate the workflow of leave applications and their approvals.

Project ModulesThe modules involved are:

Administration

Staff

Admin Module details

Admin can add a Staff and also update the Staff info.

Admin can also manage the leave application (approve and not approve).

Whenever a Staff applies for leave admin will get a notification.

Admin can change own password after login.

Admin can also view admin dashboard.

Staff Module

The Staff can log in with a valid email and password.

Update his/her profile

Applied for leave

View the leave history

Change his/ her password

Click here: https://phpgurukul.com/staff-leave-management-system-using-django-python-sqlite/

How to run the Staff Leave Management System Django Python

1. Download the zip file

2. Extract the file , copy staffleave folder and paste on the desktop

3. Open PyCharm and click on the terminal

4. Go to the desktop->staffleave->slms directory using cd command as below

5. Go to the desktop->staffleave->slms directory using cd command and run the server using command

Python manage.py runserver

After running the above command you will get the below screen

Now click the url http://127.0.0.1:8000 and the Project will Run

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Blog Management System Using Django Python

Blog Management System Project is a web-based application that automates the existing manual system with the help of computerized equipment and full-fledged computer software, fulfilling their requirements, so that their valuable information can be stored for a long period with easy access and manipulation of the same. The required software and hardware are easily available and easy to work with.

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Blog Management System Project is a web-based application that automates the existing manual system with the help of computerized equipment and full-fledged computer software, fulfilling their requirements, so that their valuable information can be stored for a long period with easy access and manipulation of the same. The required software and hardware are easily available and easy to work with.

In this Python project, we will build a GUI-based “Blog Management System” Project using Django and db SQLite. It is an intermediate-level project, where you will learn how to use databases, and modules and make some great GUIs in Python and apply them in real life.

Click here: https://phpgurukul.com/blog-management-system-using-django-python/

Blog Management System” Project has two modules that are

1 Admin

2 Reader(User)

Admin Panels

Admin will be the user of this project who can control the whole website.

1.Category: In this section, Admin can manage the category(Add/Update/Delete).

2.Posts: In this section, admin can manage posts(Add/Update/Delete).

3.Tags: In this section, admin can manage tags(Add/Update/Delete).

4. Change Password: In this section, admin can change his/her password.

Admin can recover their password by running the following command

python manage.py changepassword admin

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

First, run this command “python manage.py createsuperuser” and then fill username, email, and password.

Visitor or Readers Module

Visitor or Readers can visit the website and reads the blogs.

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Student Registration/Enrollment System in Python Django

“Student Enrolment System” is a web-based application that manages all the information of the students by schools. It includes managing data such as name, father’s name, email-id, communication address, gender, which school they are in, etc.

In this Python project, we will build a GUI-based “Student Enrolment System” Project using Django and db SQLite. It is an intermediate-level project, where you will learn how to use databases, and modules and make some great GUIs in Python and apply them in real life.

Student Enrolment System has the following section

Registrations: In this section, the school administration fills the student registration details.

Registered: In this section, all registered student details have been shown.

Search: In this section, students can be searched by his/her name, father’s name, and mother’s name.

Manage: In this section, the school administrator update and delete the information of students.

Click Here: https://phpgurukul.com/student-registration-enrollment-system-in-python-django/

How to Run the Project

Install Python (How to install Python)

Install Django : python -m pip install Django

Open the project in PyCharm and go to the project directory

Finally, Run the command: python manage.py runserver

*******For Django Admin Login************** URL: http://127.0.0.1:8000/admin/ Username: admin Password: 123

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Directory Management System Using Python Django and MySQL

Directory Management System using Python Django and MySQL is web based application which store all person information data like his/her Name, Email, Profession, Address and City. In Directory Management we use Python, Django Framework and MySQL database. Directory Management System project is web based application which enables users to easily store and find contact information, such as names, addresses and telephone numbers.

Project Module

It has two modules i.e. Admin and User.

Dashboard: In this section, admin can briefly view the details of Total Records, Public and Private Records.

Directory: In this section, admin can manage directory(Add/Update/Delete) the records.

Directory by Status: In this section, admin can manage public and private.

Search: In this section, admin can search the records of person by their name and mobile number.

Reports: In this section, admin can view the between dates report of records.

Click Here: https://phpgurukul.com/directory-management-system-using-python-django-and-mysql/

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

User:

User can search for the record by name and phone number.

How to run the Directory Management System Django Python

1. Download the zip file

2. Extract the file, copy dm folder, and paste it on the desktop

3. Open MySQL Create a database dmpythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\dm

6. Now Navigate to the Directory Management folder

cd directorymgmt

7. Run the Project using the following command

Now click the URL http://127.0.0.1:8000 and the Project will Run

Login Details

*****Admin*****

Username: admin

Password: Test@123

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Online Notes Sharing System using Python Django and MySQL

Online Notes Sharing Management System using Python Django and MySQL is a web based technology which manages user and notes database and provides rights to update their details and notes.

Online Notes Sharing Management System project manage user information and notes which is provided by him/her. User’s also have rights to update their details and notes. In this web application user must be registered. The aim of this web application is to manage user and notes database.

Project Module

User:

Dashboard: This is welcome page of registered users, user can briefly view total number of notes uploaded and files uploaded.

Notes: In this section, user can add, update and delete the notes which they want to share.

My Accounts: This section have following:

Profile: User can update his/her profile.

Change Password: User can update/his/her account password.

Logout: User can logout from their panel.

Search: User can search their notes by the titles and subject.

Click here: https://phpgurukul.com/online-notes-sharing-system-using-python-django-and-mysql/

How to run the Online Notes Sharing System Django Python

1. Download the zip file

2. Extract the file, copy nss folder, and paste it on the desktop

3. Open MySQL Create a database nsspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\nss

6. Now Navigate to the Notes Sharing Folder folder

cd notessharing

7. Run the Project using the following command

Now click the URL http://127.0.0.1:8000 and the Project will Run

Login Details

*****User*****

Username: john123

Password: Test@123 OR Register a new user.

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

Art Exhibition Management System using Python Django and MySQL

The Art Exhibition Management System Project using Python Django and MySQl has been designed to override the problem of existing manual system. This web application is supported to eliminate and in some case reduce the hardship faced by manual system. The application is reduced as much as possible to avoid errors while entering the data. It’s also provide message while entering invalid data. No formal knowledge is required for the user to operate this system. Overall we said that Art Exhibition Management System is user friendly.

Project Modules

In Art Exhibition Management System we use Python, Django Framework and MySQL database. This project keeps the records of user enquiry, art products and art artist. Art Exhibition Management System has two module i.e. admin and user.

Admin Module

1. Dashboard: In this section, admin can briefly view the total number of artist, total answer enquiry, total unanswer enquiry, Total Art Type, total art medium and total art products.

2. Art Type: In this section, admin can manage art type (add/delete/update).

3. Art Medium: In this section, admin can manage art medium(add/update/delete).

4. Art Product: In this section, admin can manage art products(add/update/delete).

5. Enquiry: In this section, admin can view and maintain the enquiry.

6. Search Enquiry: In this section admin, can search enquiry with the help of enquiry number.

6. Page: 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.

Click here: https://phpgurukul.com/art-exhibition-management-system-using-python-django-and-mysql/

User Module

1. Home: It is a welcome page for users.

2. About: It is an about us page of website.

3. Art Product: In this section, users can view art products and sent enquiry for that products.

4. Contact: In this section, users can view contact us details.

3. Art Type: In this section, users can view art products according to art type and sent enquiry for art products.

How to run the Art Exhibition Management System Django Python

1. Download the zip file

2. Extract the file, copy artexhibition folder, and paste it on the desktop

3. Open MySQL Create a database artpythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\artexhibition

6. Now Navigate to the artexhibition Folder folder

cd artexhibition

7. Run the Project using the following command

Now click the URL http://127.0.0.1:8000 and the Project will Run

Login Details

*****Admin*****

Username: admin

Password: Test@123

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

News Portal using Python Django and MySQL - PHPGurukul

...

News Portal using Python Django and MySQL is a web application used to publish the News.

Click: https://phpgurukul.com/news-portal-using-python-django-and-mysql/

The aim of “Online News Portal” is to automate its existing manual system by the help of computerized equipment and full-fledge computer software, fulfilling their requirements so that their valuable date can be stored for a longer period with easy accessing and manipulation of the same. ces.

Project Module

News has three modules i.e. user, admin, sub-admins

User module

Anyone can read the news and also search for particular news. The reader can leave comments on the particular news.

Admin Module

Secure admin login system

Admin Dashboard: In this section admin can view, listed categories & sub categories, total published news.

Sub-admin: In this section, admin can add/edit/delete sub-admin.

Category — In this section admin can add/update/delete the category. Admin can also restore deleted category.

Sub- Category — In this section admin can add/update/delete the Subcategory. Admin can also restore deleted Subcategory.

Post — Admin can add /update / delete news posts. admin can also view deleted news post in trash post section and restore deleted posts.

Pages — Admin can manage the contact of about us and contact us page.

Comments — Admin can approve/ unapproved / delete reader comments.

Sub-Admin Module

Sub-Admin and Admin features are the same except Sub-Admin creation. Sub-Admin can’t create the Sub-Admins.

How to run the News Portal System Django Python

1. Download the zip file

2. Extract the file, copy newsportal folder, and paste it on the desktop

3. Open MySQL Create a database newspythondb then import the SQL File available in the SQL File Folder (For MySQL we used XAMPP server)

4. Open PyCharm and click on the terminal

5. Navigate the project folder using the cd command

cd project_path

For ex: cd C:\Users\ANUJ\OneDrive\Desktop\newsportal\

6. Now Navigate to the onps folder

cd onps

7. Run the Project using the following command

Now click the URL http://127.0.0.1:8000 and the Project will Run

Login Details

*****admin*****

Username: admin

Password: Test@123

*****Sub-admin*****

Username: john12

Password: Test@123 or Register a new Subadmin

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

How to check Email and username availability live using jquery/ajax, PHP and PDO

In this tutorial, We will learn how to How to check Email and username availability live using jQuery/ajax and PHP-PDO.

Click : https://phpgurukul.com/how-to-check-email-and-username-availability-live-using-jquery-ajax-php-and-pdo/

File Structure for this tutorials

index.php (Main File)

config.php (Database Connection file)

check_availability.php (Used to check the Email and User availability)

Create a database with name demos. In demos database, create a table with name email_availabilty Sample structure of table email_availabilty

CREATE TABLE IF NOT EXISTS `email_availabilty` (

`id` int(11) NOT NULL,

`email` varchar(255) NOT NULL,

`username` varchar(255) NOT NULL

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

2. Create a database connection file

config.php

<?php

//DB Connection

define(‘DB_HOST’,’localhost’);

define(‘DB_USER’,’root’);

define(‘DB_PASS’,’’);

define(‘DB_NAME’,’demos’);

// Establish database connection.

try

{

$dbh = new PDO(“mysql:host=”.DB_HOST.”;dbname=”.DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES ‘utf8’”));

}

catch (PDOException $e)

{

exit(“Error: “ . $e->getMessage());

}

3. Now Create an HTML form index.php

<?php

include_once(“config.php”);

?>

<table>

<tr>

<th width=”24%” height=”46" scope=”row”>Email Id :</th>

<td width=”71%” ><input type=”email” name=”email” id=”emailid” onBlur=”checkemailAvailability()” value=”” class=”form-control” required /></td>

</tr>

<tr>

<th width=”24%” scope=”row”></th>

<td > <span id=”email-availability-status”></span> </td>

</tr>

<tr>

<th height=”42" scope=”row”>User Name</th>

<td><input type=”text” name=”username” id=”username” value=”” onBlur=”checkusernameAvailability()” class=”form-control” required /></td>

</tr>

<tr>

<th width=”24%” scope=”row”></th>

<td > <span id=”username-availability-status”></span> </td>

</tr>

</table>

4. Jquery/ajax script where you pass variable to check_availability.php page. put this in index.php inside head.

<script>

function checkemailAvailability() {

$(“#loaderIcon”).show();

jQuery.ajax({

url: “check_availability.php”,

data:’emailid=’+$(“#emailid”).val(),

type: “POST”,

success:function(data){

$(“#email-availability-status”).html(data);

$(“#loaderIcon”).hide();

},

error:function (){}

});

}

function checkusernameAvailability() {

$(“#loaderIcon”).show();

jQuery.ajax({

url: “check_availability.php”,

data:’username=’+$(“#username”).val(),

type: “POST”,

success:function(data){

$(“#username-availability-status”).html(data);

$(“#loaderIcon”).hide();

},

error:function (){}

});

}

</script>

5.check_availability.php page in this page you will check the availability of email or email.

<?php

require_once(“config.php”);

//code check email

if(!empty($_POST[“emailid”])) {

$uemail=$_POST[“emailid”];

$sql =”SELECT email FROM email_availabilty WHERE email=:email”;

$query= $dbh -> prepare($sql);

$query-> bindParam(‘:email’, $uemail, PDO::PARAM_STR);

$query-> execute();

$results = $query -> fetchAll(PDO::FETCH_OBJ);

if($query -> rowCount() > 0)

echo “<span style=’color:red’> Email Already Exit .</span>”;

else

echo “<span style=’color:green’> Email Available.</span>”;

}

// End code check email

//Code check user name

if(!empty($_POST[“username”])) {

$username=$_POST[“username”];

$sql =”SELECT username FROM email_availabilty WHERE username=:username”;

$query= $dbh -> prepare($sql);

$query-> bindParam(‘:username’, $username, PDO::PARAM_STR);

$query-> execute();

$results = $query -> fetchAll(PDO::FETCH_OBJ);

if($query -> rowCount() > 0)

echo “<span style=’color:red’> Username already exit .</span>”;

else

echo “<span style=’color:green’> Username Available.</span>”;

}

// End code check username

?>

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com

[phpgurukul1]

jQuery Dependent DropDown List – States and Districts Using PHP-PDO

In this tutorial, we are going to learn how to change the district dropdown list option based on the selected state name using PHP-PDO.

In this example, we have two dropdowns for listing states and districts. On changing states drop-down values, the corresponding district dropdown values will be loaded dynamically using jQuery AJAX.

Click: https://phpgurukul.com/jquery-dependent-dropdown-list-states-and-districts-using-php-pdo/

File structure for this tutorial

config.php — Database connection file.

index.php — Main file having drop down

get_district.php — used to retrieve the district based on the selected state name.

MySQL Database structure for this tutorial

In this tutorial two MySQL Database table is used.

state

district

state table structure

CREATE TABLE `state` (

`StCode` int(11) NOT NULL,

`StateName` varchar(150) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

district table structure

CREATE TABLE `district` (

`DistCode` int(11) NOT NULL,

`StCode` int(11) DEFAULT NULL,

`DistrictName` varchar(200) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Step 1: Create a database connection file (config.php)

<?php

// DB credentials.

error_reporting(0);

define(‘DB_HOST’,’localhost’);

define(‘DB_USER’,’root’);

define(‘DB_PASS’,’’);

define(‘DB_NAME’,’demos’);

// Establish database connection.

try

{

$dbh = new PDO(“mysql:host=”.DB_HOST.”;dbname=”.DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES ‘utf8’”));

}

catch (PDOException $e)

{

exit(“Error: “ . $e->getMessage());

}

?>

Step2: Create a HTML form with two fields . One is for state and another one is for district.

<form name=”insert” action=”” method=”post”>

<table width=”100%” height=”117" border=”0">

<tr>

<th width=”27%” height=”63" scope=”row”>Sate :</th>

<td width=”73%”><select onChange=”getdistrict(this.value);” name=”state” id=”state” class=”form-control” >

<option value=””>Select</option>

<! — — Fetching States — ->

<?php

$sql=”SELECT * FROM state”;

$stmt=$dbh->query($sql);

$stmt->setFetchMode(PDO::FETCH_ASSOC);

while($row =$stmt->fetch()) {

?>

<option value=”<?php echo $row[‘StCode’];?>”><?php echo $row[‘StateName’];?></option>

<?php }?>

</select></td>

</tr>

<tr>

<th scope=”row”>District :</th>

<td><select name=”district” id=”district-list” class=”form-control”>

<option value=””>Select</option>

</select></td>

</tr>

</table>

</form>

Step3: Getting States using jQuery AJAX

This script contains a function that will be called on changing state dropdown values. It will send AJAX request to a PHP page to get corresponding district dropdown options.

<script>

function getdistrict(val) {

$.ajax({

type: “POST”,

url: “get_district.php”,

data:’state_id=’+val,

success: function(data){

$(“#district-list”).html(data);

}

});

}

</script>

Step 4: Read the district table using PHP based on the selected state name.

This PHP code connects the database to retrieve district table values based on the state id passed by jQuery AJAX call.

<?php

require_once(“config.php”);

if(!empty($_POST[“state_id”]))

{

$stateid=$_POST[“state_id”];

$sql=$dbh->prepare(“SELECT * FROM district WHERE StCode=:stateid”);

$sql->execute(array(‘:stateid’ => $stateid));

?>

<option value=””>Select District</option>

<?php

while($row =$sql->fetch())

{

?>

<option value=”<?php echo $row[“DistrictName”]; ?>”><?php echo $row[“DistrictName”]; ?></option>

<?php

}

}

?>

How to run this script

1.Download the zip file

2.Extract the file and copy statedistdropdown-pdo 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 demos

6.Import regdb.sql file(given inside the zip package )

7.Run the script http://localhost/statedistdropdown-pdo

PHP Gurukul

Welcome to PHPGurukul. We are a web development team striving our best to provide you with an unusual experience with PHP. Some technologies never fade, and PHP is one of them. From the time it has been introduced, the demand for PHP Projects and PHP developers is growing since 1994. We are here to make your PHP journey more exciting and useful.

Website : https://phpgurukul.com