0% found this document useful (0 votes)

119 views185 pages

Documentation CLG

The document outlines a project report for the College Placement Management System, developed by students at Gonna Institute of Information Technology and Sciences as part of their Bachelor of Technology in Computer Science & Engineering. The system is designed to facilitate job placements by allowing students to manage their profiles, while enabling placement officers and recruiters to oversee job postings and candidate selection. The report includes sections on objectives, feasibility studies, system design, and user modules, emphasizing the importance of connecting job seekers with employers efficiently.

Uploaded by

adityaandukuri6

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

119 views185 pages

Documentation CLG

Uploaded by

adityaandukuri6

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

You are on page 1/ 185

THE PLACEMENT MANAGMENT SYSTEM

A project report submitted in partial fulfillment of the requirements for award of

BACHELOR OF TECHNOLOGY
in
Computer Science & Engineering

By
K. BHAVANI (216E1A0519)
A. MADHU (216E1A0511)
M.SNIHETHA (216E1A0532)
A.H.K.ADITYA SRIRAM (226E5A0502)

Under the guidance

of
Mr.K.KURMA
Assistant Professor

Department of Computer Science & Engineering

GONNA INSTITUTE OF INFORMATION TECHNOLOGY AND SCIENCES

(Approved by AICTE, Affiliated to JNTU GURAJADA VIZINANAGARAM An ISO 9001-2008 Certified
Institution) Gonnavanipalem, Aganampudi, Visakhapatnam-530053. (2021-2025 )

.
GONNA INSTITUTE OF INFORMATION TECHNOLOGY AND SCIENCES

(Approved by AICTE, Affiliated to JNTU GURAJADA VIZINANAGARAM An ISO 9001-2008

Certified Institution) Gonnavanipalem, Aganampudi, Visakhapatnam-530053. (2021-2025 )

DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

CERTIFICATE
This is to certify that “THE COLLEGE PLACEMENT MANGAMENT SYSTEM” is a
bonified project work done by
K.BHAVANI(216E1A0519)A . M A D H U (216E1A0511),M.SNIHETHA (216E1A0532),
A.H.K.ADITYA SRIRAM(226E5A0502) students of final year B Tech, Department of Computer
Science and Engineering, GONNA INSTITUTE OF INFORMATION TECHNOLOGY AND
SCIENCES, affiliated to Jawaharlal Nehru Technological University, Gurajada Vizianagaram
during the academic year 2021 – 2025. We have done this project report in partial fulfillment for
the award of the degree of Bachelor of Technology in Computer Science and Engineering.

Internal Examiner Head of the department

External Examiner
DECLARATION

This is certified that the project titled “THE COLLEGE PLACEMENT MANGAMENT
SYSTEM” is bonified work done by us
K.BHAVANI(216E1A0519)A . M A D H U (216E1A0511),M.SNIHETHA (216E1A0532),
S.ANIL(216E1A0539),A.H.K.ADITYA SRIRAM(226E5A0502) in partial fulfillment of the
requirements for the awards of the degree B Tech and submitted in the Department of Computer
Science and Engineering GONNA INSTITUTE OF INFORMATION TECHNOLOGY &
SCIENCES, Gonnavanipalem.
We also declare that this project is a result of our own effort and that has not been copied from
anyone and we have taken only citations from the sources which are mentioned in the references.
The work was not submitted earlier at any University or Institute for the event of any degree.

K. BHAVANI (216E1A0519)
A. MADHU (216E1A0511)
M.SNIHETHA (216E1A0532)

A.H.K. ADITYA SRIRAM (226E5A0502)

ACKNOWLEDGEMENT

I consider it as a privilege to thank all those people who helped me a lot for successful
completion of the project “THE COLLEGE PLACEMENT MANGAMENT SYSTEM”.
First of all, we would like to thanks to my Project Guide Mr. Kurma, Assistant Professor,
Department of Computer science & Engineering for helping me a lot in completing my project work
and for enlightening me with constructive suggestions for solving my problems patiently and
helping me to improve the quality of work.
We would like to thank our ever-inspiring Head of the Department Mrs. Anuradha, MTech,
Department of Computer Science & Engineering for his spontaneous response to every request
though he is busy with his hectic schedule of administration and teaching.
We would like to thank Principal of Gonna Institute of Information Technology & Science
Dr.P.S.N. MURTHY for his encouragement to me during the course of this project work.
We also express my sincere thanks to our beloved Secretary Sri. GONNA HEMACHAND NAIDU,
“Gonna Institute of Information Technology & Science”, for his valuable inspiration at every stage. I
thank to the entire faculty who have been a constant source of support during my study tenure.

K. BHAVANI (216E1A0519)
A. MADHU (216E1A0511)
M.SNIHETHA (216E1A0532)
A.H. K. ADITYA SRIRAM (226E5A0502)
ABSTRACT

The Placement Management System is a web-based application designed for the training and
placement department of the college. Accessible with secure login credentials, the system
enables students to upload and manage their personal and educational details efficiently.
Placement officers can oversee student data, post job openings, and track placement activities,
while recruiters can post requirements, view eligible profiles, and shortlist candidates.
CONTENT

Sr.No. Subject Page Number

1. Introduction 3

2. Objective 6

3. Feasibility Study 7
4. Requirement Analysis 10

5. Design 11

6. Project Modules 24

7. Output Screens 38

8. Project Code 52

9. Testing 79
10. Implementation 90
11. Maintenance 91
introduction
INTRODUCTION

Our project THE COLLEGE PLACEMENT MANGAMENT SYSTEM”.

has been designed to help the millions of unemployed youths to get in touch with the major companies
which would help them in getting the right kind of jobs and would also help the companies to get the
appropriate candidates for appropriate jobs.
This online project would be of great help for job seekers as well as job providers.
Companies are the clients who want the best manpower to be selected for their concern. Students are the
users who want to be placed in the best company. In this system, there is a registration process each for
the companies and for students. To use the services of this system companies and students have to
register themselves.
This job site uses forms authentication to authenticate users. When new users register the forms,
authentication module automatically give an authentication ticket to the user’s browser to identify the
user.
To simplify development all the pages in the job site are built with user controls. For example, the
standard header and footer for each page are created with header and footer user control. Users of the
website can publicity post Resume and find better job of companies. If a user is interested in a job, the
user can submit a resume, and if employer is interested in that user then they enquiry about user and
send response by mail or phone.
This is a public website for posting resume and finding an IT-job. All the registered users of job site
have there own personal home page. The job site includes a Search button for finding Quick job, it has
four option that are:-
 Search by location
 Search by Date
 Search by Qualification.
 Search by job Title.
Our project is divided into two main modules.

 Student module

 Admin module

 Co-Ordinator module

The User Module- In this, first of all the users have to register themselves. If a user is already
registered, he can directly login to the site by entering the unique id and password provided to him. Once
the user has logged in, then he/she can view the various jobs available which are posted by the various
companies. After registering with our website we will send their resumes and other details to the
appropriate companies directly. The companies will check the resumes of the students and they can send
a call letter for the placement procedure. The student will be selected as per the company’s procedure.
This section also deals with providing the user with various details such as
1) Company information
2) Option for changing their passwords
3) They can also send e-mail to the website administrator for any further query or
doubts.

The college placement management system

Student

View company
details

Verify company
details

Student
registration

Fig 1.1 User module

The college placement management system

The Admin Module-The second module, i.e., the admin module is under the control of the website
owners and has no connection with the users. Here the administrator gets to control the website as per
his wish. In this section, the administrator can add records of the various companies that want to be
registered with the website and the various jobs being offered by these companies. He can also view all
the records of all the users who have registered their details with the website and the record of users who
have logged in the website along with their passwords.
All in all the administrator gets to take a full control of the website which includes the adding and
deleting of all the records related to the company as well as the users.

Admin

View student and company

details

Sending mails to the student

Fig 1.2 Admin sending mails to student

The college placement management system

Co-Ordinator module

A coordinator's role involves organizing and managing various aspects of a project, event, or team to
ensure smooth execution and efficient collaboration, often acting as a liaison between different groups
and stakeholder
 Planning and Organization:
Coordinators are responsible for planning and organizing events, projects, or activities, including setting
schedules, managing budgets, and coordinating resources.
 Communication:
They act as a central point of communication, ensuring that all relevant parties are informed about
important information and updates.
 Task Management:
Coordinators often manage tasks, delegate responsibilities, and monitor progress to ensure that projects
stay on track and deadlines are met.
 Resource Management:
They are responsible for managing resources, including personnel, equipment, and supplies, to ensure
that they are available when and where they are needed.
 Problem Solving:
Coordinators often identify and resolve problems or issues that arise during the course of a project or
event.
 Collaboration:
They facilitate collaboration among team members and stakeholders, ensuring that everyone is working
towards the same goals.

The college placement management system

Fig1.3 Co-
Ordinator module

The college placement management system

Objectives

The college placement management system

OBJECTIVES

The objectives of developing the job center are as given below: -

To store data of the entire user who are registered in the site.
To solve the user’s problem in time efficient manner. Helping the user to search different job with a
robust search tools
To facilitate easy and efficient retrieval of data as and when required for job by the company.
To generate and print out the various reports.
Online updating of all type of data, updating data using web based interfaces and with the help of
buttons and links in an easy and convenient way.
Data security is maintained to relatively high level by implementing it at Database level, so as to ensure
that only authorized users have access to confidential client information.
Developing a viable candidate system that fulfill the
Faster and accurate information retrieval
Easy registration
Login dependent information retrieval and updating.
Correct and consistent maintenance of data and its quick retrieval
The overall objective of the system to bring the IT-jobseeker and employer round the globe more
closely to each other so that jobseeker can get correct job and employer can get the correct candidate.

The college placement management system

FEASIBILITY STUDY

A feasibility study is a test of system proposal according to its work ability, impact on the organization,
ability to meet user needs and effective use of resources. The objective of feasibility study is not to solve
problem but to acquire a sense of its scope. Consequently, costs/benefits are estimated.
Feasibility study is a process of determining that whether a project is feasible or not. There can be a
number of ways to solve a problem but each solution can not be the optimal one. Feasibility is the
determination of whether or not a project is worth doing. A feasibility study is an analysis of a problem
to determine if it can be solved effectively in the given budgetary, operational, technical and schedule
constraints in place. The results of the feasibility study determine which, if any, of a number of feasible
solutions to be developed in the design phase. The aim of the feasibility study is to identify the best
solution under the circumstances by identifying the effects of this solution on the organization. The
contents and recommendations of such a study will be used as a sound basis for deciding whether to
proceed, postpone or cancel the project.
There can be 3 different types of feasibility studies related to a particular project:

1) Technical feasibility: The current level of technology can support the proposed system, the proposed
software is able to meet all the objective of the system and output received is more efficient. So the
project is technically feasible. Depending on the results of the initial investigation, the survey is
expanded to a more detailed feasibility study. Feasibility study is a test of system
proposal according to its workability, impact on the organization, ability to meet user needs,
and effective use of resource

2) Economic feasibility: Today, software is the most expensive element of virtually all computer-based
systems. For complex, custom systems, a large cost estimation error can make the difference between
profit and loss. Estimation of resources, cost, and schedule for a software engineering effort requires
experience, access to good historical information, and the courage to commit to quantitative
predictions when qualitative information is all that exists. Estimation carries inherent risk and this
risk leads to uncertainty. Project complexity has a strong effect of the uncertainty inherent in
planning. Complexity, however, is a relative measure that is affected by familiarity with past effort.
Project size is another important factor that can effects the accuracy and efficiency of estimates. The
proposed system needs to get hardware and software installed. The short–term costs are over
shadowed by the long–term.

The college placement management system

3) The profit of the business is rated as per this visual drafting system help in establishing the better
relationship between clients and also satisfy their queries and so the cost of the development of the
software and hardware is over shadowed thus project is economically feasible. Economic feasibility
is the most frequently used technique for evaluating the effectiveness of the proposed system. It is
commonly known as cost/benefit analysis. The procedure is to determine the benefits and savings that
are expected form the system and compare them with the costs. If the benefits outweigh costs, a
decision is taken to design and implement the system otherwise further justification or the
alternatives are proposed.

3.) Operational feasibility: The current system has lot of problems, that are removed in the proposed
system and clients of the system will be free form the burden and a lot of confusion. Clients are
themselves interested in getting the manual replaces by the automated one the proposal system is
user friendly so any person can use it thus it is operationally feasible. It was established that the
proposed automated system work when it is developed and installed. No major barriers to
implementation were

The college placement management system

Software Requirements

The college placement management system

ZDESIGN

REQUIREMENT ANALYSIS

SOFTWARE AND HARDWARE REQUIREMENTS

The SOFTWARE REQUIREMENT SPECIFICATION

(SRS) is very important part of the software building process, which describes the actual user level requirement form
technical point of view that is what the user exactly, wants?

The objective of preparing the software requirement specification is to represent the requirements of the software in
such a manner that ultimately leads to successful software implementation. It is the result of the analysis process of the
software development. It should contain all the data the software is going to process, the function it will provide, and
the behavior will exhibit.

It works on all types of operating system

OPERATING SYSTEM
Microsoft IIS version 5.0 or more
OTHER SOFTWARES SQL Serving ter 2000, Visual Studio.Net
2005
HTML, CSS, JAVASCRIPT
FRONT END REACT, BOOTSTRAP
PHP
BACKEND
MY SQL
DATA BASES

HARDWARE REQUIREMENTS

PROCESSOR Pentium IV higher

HARD DISK 6 GB or more
R.A.M 256 MB or more
MONITOR Colored monitor
Keyboard Standard 110 keys
Mouse Simple/scroll/optical

The college placement management system

INTRODUCTION:

System design is the process of developing specifications for a candidate system that
meet the criteria established in the system analysis. Major step in system design is the
preparation of the input forms and the output reports in a form applicable to the user.
The main objective of the system design is to make the system user friendly. System
design involves various stages as:
 Data Entry
 Data Correction
 Data Deletion
 Processing
 Sorting and Indexing
 Report Generation
System design is the creative act of invention, developing new inputs, a database, offline
files, procedures and output for processing business to meet an organization objective.
System design builds information gathered during the system

CHARACTERSTICS OF A WELL-DEFINED SYSTEM

 analysis

 Decision Making Ability

 Simplicity

 Reliability

The college placement management system

DATA BASE DESIGN:
A database management system (DBMS) consists of a collection of interrelated data and
a set of programs to access those data. The collection of data, usually referred to as the
database, contains information about one particular enterprise. The primary goal of a
DBMS is to provide an environment that is both convenient and efficient to use in
retrieving and sorting database information.

Database systems are designed to manage large bodies of information. The management
of data involves both the definition of storage of information and the provision of
mechanisms for the manipulation of information. We used relational database
management system for developing this system.

The goal of a relational- database management system (RDBMS) design is to generate a

set of relation schemas that allows us to store information without unnecessary
redundancy. Yet also allows us to retrieve information easily. One approach is to design
schemas that are in an appropriate normal form.

Redundancy means repetition of information i.e., same information may be written or

stored in many place (files). This redundancy gives higher storage and access cost. It
may lead to data inconsistency i.e., the various copies of

The college placement management system

 the same data may no longer agree. When we access this inconsistent data, system
may give wrong information. To reduce the data redundancy we use the concept
of normalization.

 Normalization of data is a process in which unsatisfactory relation schemas are decomposed by

breaking up their attribute into smaller relation schemas that possess desirable properties.
Normal forms provide database designers with, a formal framework for analyzing relation
schemas based on their keys and the functional dependencies among attributes.

Data Structure:

Resume table:

The college placement management system

Field Name Data Type Description

Resume code Integer, [ Primary key ] Resume code

User id Integer , [Foreign Key] User code

User first name Varchar First name of the user

User last name Varchar Last name of the user

Date of birth Date/time Birth Date of the user

Address Varchar First location

City Varchar City of the location

State Varchar State name

Zip Integer Zip code of the city

Country Varchar User country name

Phone Field Name Data Type

Integer Description
Phone no of the user
Login table
Email Company Id Integer,[
Varchar primary Company unique id
Email id of the user
key]
Sex Company name Varchar
Boolean Company name
Male(M),female(F)
Field name Data Type Description
Company Address Varchar
Qualification1 Varchar Company first
First qualification
Address
User id Varchar,
Company location Varchar Primary
Varchar User id is the location
Company E-mail_id of the user)
Qualification2 Second qualification
key
State
Qualification3 Varchar
Varchar State
Higheruser
qualification
User password Varchar Registered have password
Zip
Experience Integer
Integer City zipof the Experience
Year

Phone
Resume Integer
Varchar Company
Resume phone
in text Format

Email id Varchar Company email id

The college placement management system
Company site id Varchar Company web ID
Company table

The college placement management system

Apply table:

Field Name Data Type Description

Apply date Date Apply date of the job

Company name Varchar Which company apply

Company id Integer, [Foreign Key] Apply company id

Resume id Integer, [Foreign Key] Applicant resume id

User id Integer , [Foreign Key] Applicant User id

Response Varchar Pending , Short listed

Job table

Field Name Data Type Description

Job_Id Varchar, [primary key ] Job id

Job company id Integer , [Foreign Key]

Job_sdate Date Job apply date

Job title Varchar Job title

Job_ldate Date Job last date of apply

Job_mail_id Varchar Job email id

Job location Varchar Job location

Job_Qulification Varchar Condition of the job

The college placement management system

Data flow diagrams

The college placement management system

DATA FLOW DIAGRAMS

Resume submit

Registered
Job Applications Users Detail

Apply Job
Detail
Registered User Job Placement
System

Job Search(Title)

Company Details
Job Search(Loca
tion)
Job details
Job Search
(Qualification)

The college placement management system

LEVEL -1 DFD

The college placement management system

FLOWCHART

The college placement management system

The college placement management system
The college placement management system
Project modules

The college placement management system

PROJECT MODULES

The project include following main modules:-

 Login of the job-seeker.

 Registration of user.
 Job description.
 Company information.
 Application module.
 User profile information.
 The validation master
 Report generation
Brief description of the all modules:
Login of the job-seeker and administrator
This module is considered with login of new user and administrator. Every user must enter his resume
and some details about itself for login the home page and after submitted his resume system provided a
particular user-id and password at the time of registration. The administrator can also login from this
module. He can insert, delete or update the user login name and password. This module checks the
authenticity of the person accessing the project. The main objective behind this module is to provide
security to the project so that access is restricted to the authorized users. Input is taken as login and
password that the user enters. If the login id and password entered by the user matches those of the
database file then it will return and redirected to respective control panel, otherwise give an Error
massage “login denied

The college placement management system

Registration of user: It takes the information from the user and stores it into the database. This module
uses the table “Resume” for its operation.
This table has following sub module.

1) Add
2) Edit
3) Save
4) Delete
Job description: It takes the information from the user and enters it into database. This module user
the table ‘JOB’ for its operation.
This table has following sub module

1) Add
2) Update
3) Delete

Company information: It takes company information from the user and enters it into database. This
module uses the table ‘Company’ for its operation.
User profile information: It takes user profile information from the user enters it into database. This
module uses the table ‘resumes’ for its operation.
This table user has following sub module
1) add
2) update
3) delete
Validation master: This module validation the entry made by user. If the entry is not as per the
specification an appropriate message is given to the user.
Application module: With the user of this module user apply to the company he desire. This module
uses the tables “resume” and “apply” for its operation.

The college placement management system

SCHEMA DESIGN:

In database design, several views of data must be considered along with the persons who use them. In
addition to data structuring, where relationships are reflected between and within entities, we need to
identify the application program’s logical views of data within an overall logical data structure. The
logical view is what the data look like, regardless of how they are stored. The physical view is the way
data exist in physical storage. It deals with how data are stored, accessed, or related to other data in
storage. The schema is the view that helps the DBMS decide in storage act upon as requested by the
application program.

RELATIONAL MODEL:
Certain rules followed in creating and relating databases in the relational databases. This governs
how to relate data and prevent redundancy of the data in the databases. The first set of rules
called relational rules ensures that the database is a relational database. The second set called the
normalization rules simplifies the database and reduce the redundancy of the data. In proposed
system this relational database rules are applied to reduce the redundancy to make future changes
to the table structure easier to manage and minimize the impact of these changes on users
interface or the database. This is done first determining what information is needed, how items
are related, what constraints are required. Tables are created and linked by appropriate key fields.
The constraints on the data are used to guide the building of tables. The tables are created by
making use of the normalization principles. The proposed system has its tables in the third
normal form.

The college placement management system

VALIDATION CHECKS:

A common problem with computer system is that it is very easy to put incorrect data into them.
So, the input data is validated to minimize errors and wrong data entry. For certain data, specific
code has been given and validations are done which enable the user to enter the required data and
correct them if they have entered wrong codes, e.g. you could mistype a link name or a URL in a
database resulting in reports being occurred in the wrong link name. If you put incorrect data into
the computer system then you will get incorrect results out of it. Processing incorrect inputs will
produce incorrect outputs. A validation check is an automatic check made by computer to ensure
that any data entered into the computer is sensible. A validation check does not make sure that
data has been entered correctly. It only ensures that data is sensible. For this reason, validation
checks are not usually as effective as verification checks. They can however be carried out
automatically by the computer and therefore require less work by the computer operators making
them cheaper to use.

The college placement management system

METHODS OF VALIDATION:

There are many different methods of validations. The most appropriate method to use will
depend upon what data is being entered. The most common methods are listed here.

Presence Checks: checks that data has been entered into the field and that it has not been left
blank, e.g. checks that Project ID is always entered into each record in a database of project
details.

Type Checks: checks that an entered value is of particular type. E.g. checks that a field is
varchar, a number, etc.

Length Checks: checks length of an entered value, e.g. Project ID is no longer than a particular
number of characters.

Format Checks: Checks that an entered value has a particular format. E.g. a date must be consist
of “mm-dd-yy” format. If the user tries to do unauthorized operations the appropriate error
messages are produced by the systems.
DATA DICTIONARY:

In our DFD, we give names to data flows, processes, and data stores. Although the names are
descriptive of the data, they do not give details. So in the following DFD, our interest is to build
some structured in place to keep details of the contents of data flow, processes, and data store. A
data dictionary is a structured repository of data about data. It is a set of rigorous definition of all
DFD data element and data structure.

The college placement management system

A data dictionary has many advantages:

1.The most obvious is documentation. It is valuable reference in any organization.

2.Another advantage is improving analyst/user communication by establishing consistent

definition of various elements, terms and procedures.

3.During implementation, it serves as a common base against which programmers who are
working on the system compare data description.

4.Also control information is maintained for each data element cross referenced in the data
dictionary. E.g. program that use a given data element are cross referenced in a data
dictionary, which makes it easy to identify them and make any necessary changes Finally, a
data dictionary is an important step in building a database. Database management system
has a data dictionary as a standard feature.
INPUT DESIGN:

The input design is the link between the information system and the user. It comprises
developing specification and procedure for data preparation and those steps that are necessary to
put transaction data into a usable form for processing data entry. The activity of putting data into
the computer for processing can be achieved by instructing the computer to read data from a
written or printed document or it can occur by having people key data directly into the system.
The design of inputs focuses on controlling the amount of inputs required, controlling errors,
avoiding delay, avoiding extra steps and keeping the process simple.

The college placement management system

The system needs the following information for processing:

 Information regarding Project Details

 Information regarding Project Design Details

 Information regarding Category, Location Details

OUTPUT DESIGN:

In output design, emphasis is given on producing a hard copy of the information required as the outputon the computer
screen in some predefined manner. Computer output is the most important and direct source of information to the user.
Output design is a process that involves designing necessary outputs that should be given to various users according to
their requirements. Efficient, intelligible output design should improve the system’s relationship with the user and help
in decision making. Since the reports are directly referred by the management for taking the decisions and to draw
conclusions, they must be designed with utmost care and the details in the reports must be simple, descriptive and clear
to the user. The options for the outputs and reports are given the system men

The college placement management system

Output screens

The college placement management system

OUTPUT SCREENS

HOME PAGE

Home page!

The college placement management system

WELCOME PAGE FOR ADMINISTRATOR

Admin login page!

The college placement management system

PAGE FOR ADDING COMPANY DETAILS

The college placement management system

39
CONTACT US

The college placement management system

PAGE FOR DISPLAYING USER STUDENT DETAILS

Student details page !

The college placement management system

41
PAGE FOR DISPLAYING USER LOGIN DETAILS

Student result viewing page !

The college placement management system

42
STUDENT RESULT ANALYSIS

====-

Result shown to the user

The college placement management system

Placement officer login page !

The college placement management system

Admin Table

The college placement management system

apply job post table !

The college placement management system

The college placement management system
Project code

The college placement management system

PROJECT CODE
Login code:

<!DOCTYPE html>
<html lang="en">

<link href="assets/css/variables.css" rel="stylesheet">

The college placement management system

<body>

<?php

include 'php/header.php'

?>
<section class="text-gray-600 body-font">
<div class="container px-5 py-24">
<div class="flex flex-wrap -m-4">
<div class="p-4 md:w-1/3">
<div class="h-full border-2 border-gray-200 border-opacity-60 rounded-lg overflow-
hidden">
<img class="lg:h-48 md:h-36 w-full object-cover object-center"
src="assets/img/login/login-2.jpg" alt="blog">
<div class="p-6">
<h2 class="tracking-widest text-xs title-font font-medium text-gray-400 mb-1">Are
you a </h2>
<h1 class="title-font text-lg font-medium text-gray-900 mb-3">Student?</h1>
<p class="leading-relaxed mb-3">Students can login using their credentials. New
students can register.</p>
<div class="flex items-center flex-wrap ">
<a href="login-candidates.php" class="text-indigo-500 inline-flex items-center
md:mb-2 lg:mb-0">Login/Register
<svg class="w-4 h-4 ml-2" viewBox="0 0 24 24" stroke="currentColor" stroke-
width="2" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path d="M5 12h14"></path>
<path d="M12 5l7 7-7 7"></path>
</svg>
</a>

</div>
</div>
</div>
The college placement management system
</div>
<div class="p-4 md:w-1/3 ">
<div class="h-full border-2 border-gray-200 border-opacity-60 rounded-lg overflow-
hidden">
<img class="lg:h-48 md:h-36 w-full object-cover object-center"
src="assets/img/login/login-1.jpg" alt="blog">
<div class="p-6">
<h2 class="tracking-widest text-xs title-font font-medium text-gray-400 mb-1">Are
you from the</h2>
<h1 class="title-font text-lg font-medium text-gray-900 mb-3">Placement Cell ?</h1>
<p class="leading-relaxed mb-3">The placement coordinators can log into their
account from here.</p>
<div class="flex items-center flex-wrap">
<a href="login-company.php" class="text-indigo-500 inline-flex items-center
md:mb-2 lg:mb-0">Login/Register
<svg class="w-4 h-4 ml-2" viewBox="0 0 24 24" stroke="currentColor" stroke-
width="2" fill="none" stroke-linecap="round" stroke-linejoin="round">
<path d="M5 12h14"></path>
<path d="M12 5l7 7-7 7"></path>

</svg>
</a>

</div>
</div>
</div>
</div>
<div class="p-4 md:w-1/3 bg-gray-700" style="font-family: 'Andada Pro', serif;
color:#d1b8c6">
<ol list-style:upper-roman>
<li>Placement is a decisive factor of successful completion of any coursework at the
graduate or postgraduate level.</li>
<br>
<li>It is a dream of every student to get placed in top MNCs to achieve their set goals and
objectives.</li>
<br>
<li> The private universities are also levelling up their game by equipping and upgrading
their training and placement cells.</li>
<br>
<li> Contrary to popular belief, the role of the placement cell is not limited to
organisingrecruitment drive at the campus.</li>
<br>
The college placement management system
<li> They play a much broader role in placing a student in a reputed organisation. Let’s
find out how!</li>
<br>
<li style="text-align:right">- Training and Placement Officer</li>

</ol>
</div>
</div>

</div>
<div>

</div>
</section>

<?php
include 'php/footer.php'
?>

</body>

</html>

Admin code:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
The college placement management system
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';

<section id="candidates" class="content-header">

<div class="container">
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
The college placement management system
<div class="box-header with-border">
<h3 class="box-title">Welcome <b>Admin</b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Dashboard</a></li>
<li class="active"><a href="active-jobs.php"><i class="fa fa-briefcase"></i> Active
Drives</a></li>
<li><a href="applications.php"><i class="fa fa-address-card-o"></i> Students
Profile</a></li>

<li><a href="companies.php"><i class="fa fa-arrow-circle-o-right"></i> Co -
Ordinators</a></li>
<li><a href="../logout.php"><i class="fa fa-arrow-circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">

<h3>Active Drives</h3>
<div class="row margin-top-20">
<div class="col-md-12">
<div class="box-body table-responsive no-padding">
<table id="example2" class="table table-hover">
<thead>
<th>Drive Name</th>

<th>Date Created</th>
<th>View</th>
<th>Delete</th>
</thead>
<tbody>
<?php
$sql = "SELECT job_post.*, company.companyname FROM job_post INNER JOIN
company ON job_post.id_company=company.id_company";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$i = 0;
while ($row = $result->fetch_assoc()) {
?>
<tr>
<td><?php echo $row['jobtitle']; ?></td>

<td><?php echo date("d-M-Y", strtotime($row['createdat'])); ?></td>

<td><a href="view-job-post.php?id=<?php echo $row['id_jobpost']; ?>"><i class="fa
fa-address-card-o"></i></a></td>
<td><a href="delete-job-post.php?id=<?php echo $row['id_jobpost']; ?>"><i
class="fa fa-trash"></i></a></td>
The college placement management system
</tr>
<?php

// $_SESSION['id_jobpost'] = $row['id_jobpost'];
}
}
?>
</tbody>
</table>
</div>
</div>
</div>

</div>
</div>
</div>
</section>

<div class="modal modal-success fade" id="modal-success">

<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Job Title</h4>
</div>
<div class="modal-body">
<h3><b>Created On</b></h3>
<p>24/04/2017</p>
<br>
<h3><b>Company Name</b></h3>
<p>XYX Private Limited</p>
<br>
<h3><b>Company Email</b></h3>
<p>test@test.com</p>
<br>
<h3><b>Location</b></h3>
<p>India</p>
<br>
<h3><b>Application Message</b></h3>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-left" data-dismiss="modal">Close</button>
The college placement management system
</div>
</div>

</div>

</div>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="text-center">
<strong>Copyright © 2022 <a href="learningfromscratch.online">Placement
Portal</a>.</strong> All rights
reserved.
</div>
</footer>

<div class="control-sidebar-bg"></div>

</div>

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';

<section id="candidates" class="content-header">

<div class="container">
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">Welcome <b>Admin</b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Dashboard</a></li>
<li><a href="active-jobs.php"><i class="fa fa-briefcase"></i> Active Drives</a></li>
<li class="active"><a href="applications.php"><i class="fa fa-address-card-o"></i>
Students Profile</a></li>

<li><a href="companies.php"><i class="fa fa-arrow-circle-o-right"></i> Co -
Ordinators</a></li>
<li><a href="../logout.php"><i class="fa fa-arrow-circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">

<h3>Candidates Database</h3>
<div class="row margin-top-20">
<div class="col-md-12">
<div class="box-body table-responsive no-padding">
<table id="example2" class="table table-hover">
<thead>
<th>Candidate</th>
<th>Highest Qualification</th>
<th>Skills</th>
<th>City</th>
<th>State</th>
The college placement management system
<th>Download Resume</th>
<th>Status</th>
<th>Delete</th>
</thead>
<tbody>
<?php
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {

$skills = $row['skills'];
$skills = explode(',', $skills);
?>
<tr>
<td><?php echo $row['firstname'] . ' ' . $row['lastname']; ?></td>
<td><?php echo $row['qualification']; ?></td>
<td>
<?php
foreach ($skills as $value) {
echo ' <span class="label label-success">' . $value . '</span>';
}
?>
</td>
<td><?php echo $row['city']; ?></td>
<td><?php echo $row['state']; ?></td>
<?php if ($row['resume'] != '') { ?>
<td><a href="../uploads/resume/<?php echo $row['resume']; ?>" download="<?php
echo $row['firstname'] . ' Resume'; ?>"><i class="fa fa-file-pdf-o"></i></a></td>
<?php } else { ?>
<td>No Resume Uploaded</td>
<?php } ?>
<td>
<?php
if ($row['active'] == '1') {
echo "Activated";
} else if ($row['active'] == '2') {
?>
<a href="reject-student.php?id=<?php echo $row['id_user']; ?>">Reject</a> <a
href="approve-student.php?id=<?php echo $row['id_user']; ?>">Approve</a>
<?php
} else if ($row['active'] == '3') {
?>
<a href="approve-student.php?id=<?php echo $row['id_user']; ?>">Reactivate</a>
<?php
} else if ($row['active'] == '0') {
echo "Rejected";
}
The college placement management system
?>
</td>

<td><a href="delete-student.php?id=<?php echo $row['id_user'];

?>">Delete</a></td>
</tr>

<?php

}
}
?>

</tbody>
</table>
</div>
</div>
</div>

</div>
</div>
</div>
</section>

<div class="modal modal-success fade" id="modal-success">

<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span></button>
<h4 class="modal-title">Candidate Profile</h4>
</div>
<div class="modal-body">
<h3><b>Applied On</b></h3>
<p>24/04/2017</p>
<br>
<h3><b>Email</b></h3>
<p>test@test.com</p>
<br>
<h3><b>Phone</b></h3>
<p>44907512447</p>
<br>
<h3><b>Website</b></h3>
<p>learningfromscratch.online</p>
<br>
<h3><b>Application Message</b></h3>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
The college placement management system
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-outline pull-left" data-dismiss="modal">Close</button>
</div>
</div>

</div>

</div>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="text-center">
<strong>Copyright © 2022 <a href="learningfromscratch.online">Placement
Portal</a>.</strong> All rights
reserved.
</div>
</footer>

<div class="control-sidebar-bg"></div>

</div>

session_start();

if(empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");

if(isset($_GET)) {

//Delete Company using id and redirect

$sql = "UPDATE company SET active='1' WHERE id_company='$_GET[id]'";
if($conn->query($sql)) {
header("Location: companies.php");
exit();
} else {
echo "Error";
}
}
Approve student:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");

if (isset($_GET)) {

$sql = "UPDATE users SET active='1' WHERE id_user='$_GET[id]'";

if ($conn->query($sql)) {
header("Location: applications.php");
exit();
} else {
The college placement management system
echo "Error";
}
}
Check login:
<?php

//To Handle Session Variables on This Page

session_start();

//Including Database Connection From db.php file to avoid rewriting in all files
require_once("../db.php");

//If user Actually clicked login button

if(isset($_POST)) {

//Escape Special Characters in String

$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = mysqli_real_escape_string($conn, $_POST['password']);

//Encrypt Password
// $password = base64_encode(strrev(md5($password)));

//sql query to check user login

$sql = "SELECT * FROM admin WHERE username='$username' AND password='$password'";
$result = $conn->query($sql);

//if user table has this this login details

if($result->num_rows > 0) {
//output data
while($row = $result->fetch_assoc()) {

//Set some session variables for easy reference

$_SESSION['id_admin'] = $row['id_admin'];
header("Location: dashboard.php");
exit();
}
} else {
$_SESSION['loginError'] = true;
header("Location: index.php");
exit();
}

$conn->close();

} else {
header("Location: index.php");
exit();
}
Companies:
The college placement management system
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

The college placement management system

<?php

include 'header.php';
?>

<section id="candidates" class="content-header">

<div class="container">
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">Welcome <b>Admin</b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li><a href="dashboard.php"><i class="fa fa-dashboard"></i> Dashboard</a></li>
<li><a href="active-jobs.php"><i class="fa fa-briefcase"></i> Active Drives</a></li>
<li><a href="applications.php"><i class="fa fa-address-card-o"></i> Students
Profile</a></li>
<li class="active"><a href="companies.php"><i class="fa fa-arrow-circle-o-right"></i> Co
- Ordinators</a></li>
<li><a href="../logout.php"><i class="fa fa-arrow-circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">

<h3>Coordinators</h3>
<div class="row margin-top-20">
<div class="col-md-12">
<div class="box-body table-responsive no-padding">
<table id="example2" class="table table-hover">
<thead>

<th>Account Creator Name</th>
<th>Email</th>
<th>Phone</th>
<th>City</th>
<th>State</th>
<th>Country</th>
<th>Status</th>
<th>Delete</th>
The college placement management system
</thead>
<tbody>
<?php
$sql = "SELECT * FROM company";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
?>
<tr>



<td><?php echo $row['name']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['contactno']; ?></td>
<td><?php echo $row['city']; ?></td>
<td><?php echo $row['state']; ?></td>
<td><?php echo $row['country']; ?></td>
<td>
<?php
if ($row['active'] == '1') {
echo "Activated";
} else if ($row['active'] == '2') {
?>
<a href="reject-company.php?id=<?php echo $row['id_company']; ?>">Reject</a>
<a href="approve-company.php?id=<?php echo $row['id_company']; ?>">Approve</a>
<?php
} else if ($row['active'] == '3') {
?>
<a href="approve-company.php?id=<?php echo $row['id_company']; ?
>">Reactivate</a>
<?php
} else if ($row['active'] == '0') {
echo "Rejected";
}
?>
</td>
<td><a href="delete-company.php?id=<?php echo $row['id_company']; ?
>">Delete</a></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
The college placement management system
</div>
</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

</footer>

<div class="control-sidebar-bg"></div>

</div>

</html>
Admin Dashboard:
<?php

session_start();
The college placement management system
if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<body class="hold-transition skin-green sidebar-mini">

<?php

The college placement management system

include 'header.php';

<section id="candidates" class="content-header">

<div class="container">
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">Welcome <b>Admin</b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li class="active"><a href="dashboard.php"><i class="fa fa-dashboard"></i>
Dashboard</a></li>
<li><a href="active-jobs.php"><i class="fa fa-briefcase"></i> Active Drives</a></li>
<li><a href="applications.php"><i class="fa fa-address-card-o"></i> Students
Profile</a></li>

<li><a href="companies.php"><i class="fa fa-arrow-circle-o-right"></i> Co -
Ordinators</a></li>
<li><a href="index.php"><i class="fa fa-arrow-circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">

<h3>Placement Cell Statistics</h3>

<div class="row">
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-red"><i class="ion ion-briefcase"></i></span>
<div class="info-box-content">
<span class="info-box-text">Co-Ordinators</span>
<?php
$sql = "SELECT * FROM company WHERE active='1'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>
The college placement management system
</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-red"><i class="ion ion-briefcase"></i></span>
<div class="info-box-content">
<span class="info-box-text">Pending Coordinators Approval</span>
<?php
$sql = "SELECT * FROM company WHERE active='2'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>

</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-green"><i class="ion ion-person-stalker"></i></span>
<div class="info-box-content">
<span class="info-box-text">Registered Students</span>
<?php
$sql = "SELECT * FROM users WHERE active='1'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>
</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-green"><i class="ion ion-person-stalker"></i></span>
<div class="info-box-content">
<span class="info-box-text">Pending Students Confirmation</span>
<?php
$sql = "SELECT * FROM users WHERE active='0'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
The college placement management system
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>
</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-aqua"><i class="ion ion-person-add"></i></span>
<div class="info-box-content">
<span class="info-box-text">Total Drive Posts</span>
<?php
$sql = "SELECT * FROM job_post";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>
</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-yellow"><i class="ion ion-ios-browsers"></i></span>
<div class="info-box-content">
<span class="info-box-text">Total DRIVE Applications</span>
<?php
$sql = "SELECT * FROM apply_job_post";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$totalno = $result->num_rows;
} else {
$totalno = 0;
}
?>
<span class="info-box-number"><?php echo $totalno; ?></span>
</div>
</div>
</div>
</div>

</div>
</div>
The college placement management system
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

</div>
</footer>

<div class="control-sidebar-bg"></div>

</div>

</html>
Database php:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

The college placement management system

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';

<section id="candidates" class="content-header">

<div class="col md-13">

<a href="export.php"><button type="submit1" name='export_excel_btn' class="btn
btn-primary">Export to Excel</button></a>

The college placement management system

<button type="submit1" onclick="sortTable()" name='export_excel_btn'
style="margin-left: 8px;" class="btn btn-success">Sort Data</button>
<h3 style="text-align: center;"> Student applications for various companies</h3>
<?php

$sql1 = "SELECT distinct jobtitle FROM job_post INNER JOIN apply_job_post ON

job_post.id_jobpost=apply_job_post.id_jobpost INNER JOIN users ON
users.id_user=apply_job_post.id_user WHERE apply_job_post.id_company=2";

$result1 = $conn->query($sql1);
?>
<form method="POST">
<div class="form-group text-center option">

<select class="form-control select2 select2-hidden-accessible" style="width:
100%" tabindex="-1" aria-hidden="true" class="input" name="company">
<option value="" selected>Select Company</option>
<?php
if ($result1->num_rows > 0) {
while ($row1 = $result1->fetch_assoc()) {

?>
<option class="option1" name="option1" id="option1" value="<?php
echo $row1['jobtitle']; ?>"><?php echo $row1['jobtitle']; ?></option>
<?php
}
}
?>
</select>
<input name="submit" type="submit" value="Submit">
<form method="POST" action=""></form>

</form>

<?php

if (isset($_POST['submit'])) {

$option = mysqli_real_escape_string($conn, $_POST['company']);

// echo $_SESSION['option'];

?>

<div class="row margin-top-20">
<div class="col-md-13">
<div class="box-body table-responsive no-padding">
The college placement management system
<table id="example2" class="table table-hover">
<thead>
<th>Student Name</th>
<th>Highest Qualification</th>
<th>Skills</th>
<th>City</th>
<th>State</th>
<th>Contact No.</th>
<th>Email</th>

</thead>
<tbody>
<?php
// selecting student record via option

$sql2 = "select id_jobpost from job_post where jobtitle = '$option'";

$result2 = $conn->query($sql2);

if ($result2->num_rows > 0) {
while ($row2 = $result2->fetch_assoc()) {
$jobid = $row2['id_jobpost'];

$sql = "select * from users inner join apply_job_post on

users.id_user = apply_job_post.id_user where id_jobpost = '$jobid' ";
$_SESSION['QUERY'] = $sql;
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while ($row = $result->fetch_assoc()) {

The college placement management system

'</span>';
}
?>
</td>
<td><?php echo $row['city']; ?></td>
<td><?php echo $row['state']; ?></td>
<td><?php echo $row['contactno']; ?></td>
<td><?php echo $row['email']; ?></td>

<td><?php echo $row['hsc']; ?></td>

</tr>

<?php

}
}
}
} ?>
</tbody>

</table>
</div>
</div>
</div>

<?php

}
?>

</div>
</div>

</div>
The college placement management system
<!-- <div class="col-md- ">

</div> -->
</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin:auto;bottom: 0;

width: 100%;
height: 50px; position:absolute; background-color:#1f0a0a; color:white">
<div class="text-center">
<strong>Copyright © 2022 Placement Portal</strong> All rights
reserved.
</div>
</footer>

<div class="control-sidebar-bg"></div>

</div>

</html>

/* Make a loop that will continue until

no switching has been done: */
while (switching) {
// Start by saying: no switching is done:
switching = false;
rows = table.rows;

/* Loop through all table rows (except the

first, which contains table headers): */
for (i = 1; i < (rows.length - 1); i++) {
// Start by saying there should be no switching:
shouldSwitch = false;
/* Get the two elements you want to compare,
one from current row and one from the next: */
x = rows[i].getElementsByTagName("TD")[0];
y = rows[i + 1].getElementsByTagName("TD")[0];

// Check if the two rows should switch place:

if (x.innerHTML.toLowerCase() > y.innerHTML.toLowerCase()) {
// If so, mark as a switch and break the loop:
shouldSwitch = true;
break;
}
}

if (shouldSwitch) {
/* If a switch has been marked, make the switch
and mark that a switch has been done: */
rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
switching = true;
}
}
}
</script>
Delete company:
<?php

session_start();

if(empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}
The college placement management system
require_once("../db.php");

if(isset($_GET)) {

//Delete Company using id and redirect

$sql = "DELETE FROM company WHERE id_company='$_GET[id]'";
if($conn->query($sql)) {
header("Location: companies.php");
exit();
} else {
echo "Error";
}
}
Delete job post:
<?php

session_start();

if(empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");

if(isset($_GET)) {

$sql = "DELETE FROM job_post WHERE id_jobpost='$_GET[id]'";

if($conn->query($sql)) {
$sql1 = "DELETE FROM apply_job_post WHERE id_jobpost='$_GET[id]'";
if($conn->query($sql1)) {
}
header("Location: active-jobs.php");
exit();
} else {
echo "Error";
}
}
Delete student:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

The college placement management system

require_once("../db.php");

if (isset($_GET)) {

//Delete student using id and redirect

$sql = "DELETE FROM users WHERE id_user='$_GET[id]'";
if ($conn->query($sql)) {
header("Location: applications.php");
exit();
} else {
echo "Error";
}
}
Delete notice:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
if (isset($_GET)) {

//Delete notice using id and redirect

$sql = "DELETE FROM notice WHERE id ='$_GET[id]'";
if ($conn->query($sql)) {
header("Location: postnotice.php");
exit();
} else {
echo "Error";
}
}
Header:

<header class="header">
<nav class="navbar">
<a href="#" class="nav-logo">Placement Portal</a>
<ul class="nav-menu">
<li class="nav-item">
<a href="index.php" class="nav-link">Dashboard</a>
</li>

<li class="nav-item">
<a href="postnotice.php" class="nav-link">Post Notice</a>
</li>
<li class="nav-item">
The college placement management system
<a href="database.php" class="nav-link">Database</a>
</li>
<li class="nav-item">
<a href="placed.php" class="nav-link">Placed Students</a>
</li>
<li class="nav-item">
<a href="logout.php" class="nav-link">Log Out</a>
</li>
<li class="nav-item">
<a href="results.php" class="nav-link">Resultss</a>
</li>
</ul>

*{
margin: 0;
padding: 0;
box-sizing: border-box;
}

html {
font-size: 62.5%;
font-family: 'Roboto', sans-serif;
}

li {
list-style: none;
}

a{
text-decoration: none;
}

.header {
border-bottom: 1px solid #E2E8F0;
}
The college placement management system
.navbar {
display: flex;
justify-content: space-between;
align-items: center;
padding: 1rem 1.5rem;
background-color: #2d2a2e;
}

.hamburger {
display: none;
}

.bar {
display: block;
width: 25px;
height: 3px;
margin: 5px auto;
-webkit-transition: all 0.3s ease-in-out;
transition: all 0.3s ease-in-out;
background-color: #101010;

.nav-menu {
display: flex;
justify-content: space-between;
align-items: center;
}

.nav-item {
margin-left: 5rem;
}

.nav-link {
font-size: 1.6rem;
font-weight: 400;
color: #b3c6e0;
}

.nav-link:hover {
color: #482ff7;
}

.nav-logo {
font-size: 2.1rem;
font-weight: 500;
color: #d0cce9;
}
The college placement management system
@media only screen and (max-width: 768px) {
.nav-menu {
position: fixed;
left: -100%;
top: 5rem;
flex-direction: column;
background-color: #0b0606;
/* background-color: #482ff7; */
width: 100%;
border-radius: 10px;
text-align: center;
transition: 0.3s;
box-shadow:
0 10px 27px rgba(0, 0, 0, 0.05);
z-index: 10;

.nav-menu.active {
left: 0;
}

.nav-item {
margin: 2.5rem 0;
}

.hamburger {
display: block;
cursor: pointer;
}

// Inside the Media Query.

.hamburger.active .bar:nth-child(2) {
opacity: 0;
}

.hamburger.active .bar:nth-child(1) {
transform: translateY(8px) rotate(45deg);
}

.hamburger.active .bar:nth-child(3) {
transform: translateY(-8px) rotate(-45deg);
}
</style>

The college placement management system

hamburger.addEventListener("click", mobileMenu);

function mobileMenu() {
hamburger.classList.toggle("active");
navMenu.classList.toggle("active");
}
</script>
Index:
<?php

session_start();

if (isset($_SESSION['id_admin'])) {
header("Location: dashboard.php");
exit();
}

?>
<!DOCTYPE html>
<html>

<head>

<title>Placement Portal</title>
<link href="../img/logo.png" rel="icon">

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/iCheck/1.0.2/skins/square/blue.css">

The college placement management system

<body class="hold-transition login-page bg-gray-800 text-white">

<?php
include '../uploads/admin_header.php';
?>

<div class="login-box " id="sms">

<div class="login-logo text-white">

<a style="color:white" href="../index.php">Placement Portal</a>
</div>

<div class="bg-gray-900 text-white login-box-body large">
<p class="login-box-msg mt-7">Admin Login</p>
<style>
.large {
width: 350px;
height: 300px;
}

.small {
font-size: small;
}

#footer {
position: absolute;
bottom: 0;
width: 100%;
height: 60px;
/* Height of the footer */

@media only screen and (max-width: 768px) {

.large {
The college placement management system
margin: auto;

.small {

position: absolute;
}
</style>

<form action="checklogin.php" method="post">

<div class="form-group has-feedback">
<input type="text" class="form-control" name="username" placeholder="Username">
<span class="glyphicon glyphicon-envelope form-control-feedback"></span>
</div>
<div class="form-group has-feedback">
<input type="password" class="form-control" name="password" placeholder="Password">
<span class="glyphicon glyphicon-lock form-control-feedback"></span>
</div>
<div class="row">

<div class="col-xs-4">
<button type="submit" class="btn btn-primary btn-block btn-flat" class=" transition ease-in-out
delay-150 bg-blue-500 hover:-translate-y-1 hover:scale-110 hover:bg-indigo-500 duration-300">Sign
In</button>
</div>

</div>
<?php
//If User Failed To log in then show error message.
if (isset($_SESSION['loginError'])) {
?>
<div>
<p class="text-center">Invalid Email/Password! Try Again!</p>
</div>
<?php
unset($_SESSION['loginError']);
}
?>

</form>
</div>

</div>

<div style="margin: bottom 0px; " class=" sm:mt-48 ">

The college placement management system

<div class="pt-1 pb-2">

<li><i class="fa fa-copyright" aria-hidden="true"></i>Placement Portal @ 2022</li>

</ul>

</div>

</footer>

</div>

</body>

</html>
Logout:
<?php
session_start(); // Start the session

// Destroy all session data

session_unset();
session_destroy();

// Redirect to login page or homepage

header("Location: index.php");
The college placement management system
exit();
?>
Placed php:
<?php

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no"
name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/
bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-
awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<?php

include 'header.php';

<section id="candidates" class="content-header">

<div class="col md-4">

<h3 style="text-align: center;">Placed Students list </h3>
<h3>Filters</h3>
<input type="text" id="myInput" onkeyup="myFunction()" placeholder="Search for
names..">

<a href="export1.php"><button type="submit1" name='export_excel_btn' class="btn btn-
primary">Export to Excel</button></a>

<button type="submit1" onclick="sortTable()" name='export_excel_btn' style="margin-

left: 8px;" class="btn btn-success">Sort Data</button>
</div>

<div class="row margin-top-20">

<th style="width:20%;">Student Name</th>

<th style="width:30%;">Student Email</th>
<th style="width:20%;">Company Name</th>
<th style="width:20%;">Role</th>
<th style="width:20%;">CTC</th>

</tr>
<!-- <thead>
The college placement management system
<th>Student Name</th>
<th>Student Email</th>
<th>Company Name</th>
<th>Role</th>
<th>CTC</th>

</thead> -->
<tbody>
<?php
// selecting student record via option
// fetching placed students from placed table &user table

$sql = "select * from users inner join apply_job_post INNER JOIN job_post
where users.id_user = apply_job_post.id_user AND apply_job_post.id_jobpost = job_post.id_jobpost;;";
$_SESSION['QUERY'] = $sql;
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while ($row = $result->fetch_assoc()) {

?>
<tr>
<td><?php echo $row['firstname'] . ' ' . $row['lastname']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['jobtitle']; ?></td>
<td><?php echo $row['experience']; ?></td>
<td><?php echo $row['minimumsalary']; ?></td>

</tr>

<?php

}
}

?>
</tbody>
</table>
</div>
</div>
</div>

</div>

The college placement management system

<!-- <div class="col-md-2 ">

</div> -->
</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin:auto;bottom: 0;

width: 100%;
height: 50px; position:absolute; background-color:#1f0a0a; color:white">

</footer>

<div class="control-sidebar-bg"></div>

</div>

</html>

<script>
// function myFunction() {

// var input, filter, table, tr, td, i, txtValue;

// input = document.getElementById("myInput");
// filter = input.value.toUpperCase();
// table = document.getElementById("example2");
// tr = table.getElementsByTagName("tr");

// // Loop through all table rows, and hide those who don't match the search query
// for (i = 0; i < tr.length; i++) {

// td = tr[i].getElementsByTagName("td")[0];

// for (var j = 0; j < td.length; j++) {

// td = tr[i].getElementsByTagName("td")[j]; //1 row ke 1 column ki value hai yeh

// if (td) {
// txtValue = td.textContent || td.innerHTML;
// if (txtValue.toUpperCase().indexOf(filter) > -1) {
// tr[i].style.display = "";
The college placement management system
// } else {
// tr[i].style.display = "none";
// }
// }
// }
// }
// }

function myFunction() {
// Declare variables
var input, filter, table, tr, td, i, txtValue;
input = document.getElementById("myInput");
filter = input.value.toUpperCase();
table = document.getElementById("example2");
tr = table.getElementsByTagName("tr");

// Loop through all table rows, and hide those who don't match the search query
for (i = 0; i < tr.length; i++) {
td = tr[i].getElementsByTagName("td")[0];
if (td) {
txtValue = td.textContent || td.innerText;
if (txtValue.toUpperCase().indexOf(filter) > -1) {
tr[i].style.display = "";
} else {
tr[i].style.display = "none";
}
}
}
}
</script>

#example2 {
border-collapse: collapse;
/* Collapse borders */
width: 100%;
/* Full-width */
border: 1px solid #ddd;
/* Add a grey border */
font-size: 18px;
/* Increase font-size */
}

#example2 th,
#example2 td {
text-align: left;
/* Left-align text */
padding: 12px;
/* Add padding */
}

#example2 tr {
/* Add a bottom border to all table rows */
border-bottom: 1px solid #ddd;
}

#example2 tr.header,
#example2 tr:hover {
/* Add a grey background color to the table header and on hover */
background-color: #f1f1f1;
}
</style>
Post notice:
<?php

session_start();

require_once("../db.php");

if (isset($_POST['submit'])) {
$subject = $_POST['subject'];
$notice = $_POST['input'];
$audience = $_POST['audience'];

The college placement management system

$resumeFileName = NULL; // Default to NULL

// Check if the file is uploaded properly

if (!empty($_FILES['resume']['name'])) {
$folder_dir = "../uploads/resume/";
$base = basename($_FILES['resume']['name']);
$resumeFileType = pathinfo($base, PATHINFO_EXTENSION);
$resumeFileName = uniqid() . '.' . $resumeFileType;
$target_file = $folder_dir . $resumeFileName;

if (!move_uploaded_file($_FILES['resume']['tmp_name'], $target_file)) {
die("Error uploading file.");
}
}

// Insert data into the database

$stmt = $conn->prepare("INSERT INTO notice (subject, notice, audience) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $subject, $notice, $audience);

if ($stmt->execute()) {
echo "Notice posted successfully!";
} else {
echo "Error: " . $stmt->error;
}

$stmt->close();
}

// Don't close `$conn` here if more queries run later

<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';
?>

<div class="row">
<div class="col-xs-6 responsive">
<section>
<div class="alert alert-success alert-dismissible" style="display: none;" id="truemsg">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<h4><i class="icon fa fa-check"></i> Success!</h4>
New Notice Successfully added
</div>

<form class="centre " action="" method="POST">

<div>
<h4><strong> Post a new notice</strong></h4>
</div>
<div>

<input id="subject" placeholder="Subject" type="text" name="subject"

style="margin:auto">

</div>

<div id="file" class="form-group">

The college placement management system

<div class="form-group text-center option">

<label>Audience </label>
<select class="form-control select2 select2-hidden-accessible" style="width: 100%"
tabindex="-1" aria-hidden="true" class="input" name="audience">

<option class="option" value="All Students">All Students</option>

<option class="option" value="Co-ordinators">Co-ordinators</option>

</select>
</div>
<div class="text-center">
<button class="btn btn-primary btn-sm" id="submit" name="submit" type="
submit1">NOTIFY</button>

</div><br>
<div>
</div>

</form>

</div>
</section>
<div class="col-xs-5 responsive2 ">
<div class="box box-primary ">
<div class="box-header with-border">
<h3 class="box-title">Posted Notice</h3>
</div>

<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>Subject</th>
<th>Notice</th>

<th>Audience</th>

The college placement management system

<th>Date and Time</th>
<th>Delete</th>

</tr>
</thead>
<tbody>

<?php

$sql = "SELECT * FROM notice";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// output data of each row

while ($row = $result->fetch_assoc()) {
?>
<td><?php echo $row['subject']; ?></td>
<td><?php echo $row['notice']; ?></td>
<td><?php echo $row['audience']; ?></td>
<?php if ($row['resume'] != '') { ?>
<td><a href="../uploads/resume/<?php echo $row['resume']; ?>"
download="<?php echo 'Notice'; ?>"><i class="fa fa-file"></i></a></td>
<?php } else { ?>
<td>No Resume Uploaded</td>
<?php } ?>
<td><?php echo $row['date']; ?></td>

<td><a id="delete" href="deletenotice.php?id=<?php echo $row['id']; ?>"><i

class="fa fa-trash"></i></a></td>
</tr><?php

}
}

</tbody>
<tfoot>

</tfoot>
</table>
</div>

</div>

The college placement management system

</div>

<footer class="main-footer" style="margin:auto;margin-bottom: 0px; padding:15px;

</body>

</html>

<style>
body {

/* background-color: #bccde5;
*/
background-color: white;
}

.centre {
margin: 20px 30px 100px 20px;
text-align: center;
height: 450px;
width: 700px;
border: 2px solid black;
border-radius: 10px;
/* display: inline-grid; */
display: inline-block;

#subject {

width: 86%;

.option {
width: 30%;
margin: auto;
}

.input {
The college placement management system
height: 200px;
width: 600px;
border-radius: 5px;
background-color: white;
text-align: center;

.button {

background-color: #3e79c8;

/* Green */
border: none;
color: white;
padding: 15px 32px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 0px 10px 0px 10px;
}

@media screen and (max-width: 1447px) {

.input1 {
width: auto;
height: auto;
}

.centre {

height: 105%;
width: 105%;
margin-left: 100px;

.responsive2 {
margin: auto;
display: block;
height: 80%;
width: 80%;
margin: auto;
}

#subject {
height: 60%;
The college placement management system
width: 60%;
margin: auto;

.option {
height: 60%;
width: 60%;
margin: auto;
}

.input {
height: 80%;
width: 60%;
margin: auto;

}
</style>
Result.php:
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['roll_number']) &&
isset($_POST['semester']) && !empty($_POST['semester'])) {

$roll_number = $_POST['roll_number'];

$semester = $_POST['semester']; // Get selected semester

$file = fopen("studentdata1.csv", "r");

$header = fgetcsv($file); // Read header row

$student_data = null;

while (($row = fgetcsv($file)) !== false) {

if ($row[0] == $roll_number) { // Assuming Roll Number is in the first column

$student_data = $row;

break;

fclose($file);

The college placement management system

}

<!DOCTYPE html>

<head>

<meta name="viewport" content="width=device-width, initial-scale=1.0">

<title>Student Results</title>

<style>

body { font-family: Arial, sans-serif; }

table { width: 80%; border-collapse: collapse; margin: 20px auto; }

th, td { border: 1px solid #ddd; padding: 10px; text-align: left; }

th { background-color:rgba(255, 0, 166, 0.67); color: white; }

.container { text-align: center; margin-top: 50px; }

.input-box { padding: 10px; width: 300px; }

.btn { padding: 10px 20px; background-color: green; color: white; border: none; cursor: pointer; }

.hidden { display: none; } /* Hide semester tables by default */

</style>

</head>

<body>

<h2>Student Results</h2>

<form method="POST" onsubmit="return validateForm();">

<input type="text" name="roll_number" placeholder="Enter Roll Number" class="input-box"

required>
The college placement management system
<select name="semester" class="input-box" id="semester">

<option value="">Select Semester</option>

</select>

<button type="submit" class="btn">Get Data</button>

</form>

<?php if (isset($student_data)) { ?>

<h3>Student Details</h3>

<table>

<tr><th>Hall Ticket No</th><td><?php echo $student_data[0]; ?></td></tr>

<tr><th>Student Name</th><td><?php echo $student_data[1] . " " . $student_data[2];

?></td></tr>

<tr><th>Department</th><td><?php echo $student_data[10]; ?></td></tr>

<tr><th>Mobile</th><td><?php echo $student_data[3]; ?></td></tr>

<tr><th>Email</th><td><?php echo $student_data[4]; ?></td></tr>

<tr><th>Father Name</th><td><?php echo $student_data[5]; ?></td></tr>

<tr><th>Current Location</th><td><?php echo $student_data[6]; ?></td></tr>

<tr><th>Gender</th><td><?php echo $student_data[7]; ?></td></tr>

<tr><th>Date Of Birth</th><td><?php echo $student_data[8]; ?></td></tr>

The college placement management system
<tr><th>Aadhar Number</th><td><?php echo $student_data[9]; ?></td></tr>

<tr><th>Attendance</th><td><?php echo $student_data[17]; ?></td></tr>

</table>

<h3>Subject Grades</h3>

<table id="1-1" class="hidden">

<tr><th>1A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>

</table>

<table id="1-2" class="hidden">

<tr><th>1B Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[26]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[27]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[28]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[29]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[30]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[31]; ?></td></tr>

The college placement management system

</table>

<table id="2-1" class="hidden">

<tr><th>1A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>

</table>

<table id="2-2" class="hidden">

<tr><th>1A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>

</table>

<table id="3-1" class="hidden">

<tr><th>1B Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[26]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[27]; ?></td></tr>

The college placement management system

<tr><td>UHV</td><td><?php echo $student_data[29]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[30]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[31]; ?></td></tr>

</table>

<table id="3-2" class="hidden">

<tr><th>1A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>

</table>

<table id="4-1" class="hidden">

<tr><th>4A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[11]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[12]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[13]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[14]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[15]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[16]; ?></td></tr>

</table>

The college placement management system

<tr><th>1A Paper Code</th><th>Grade</th></tr>

<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>

<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>

<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>

<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>

<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>

<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>

</table>

</div>

document.addEventListener("DOMContentLoaded", function () {

let selectedSemester = "<?php echo $semester; ?>";

if (selectedSemester) {

document.getElementById(selectedSemester).classList.remove("hidden");

});

function validateForm() {

let semester = document.getElementById("semester").value;

if (semester === "") {

alert("Please select a semester before submitting.");

return false;

return true;

The college placement management system

}

</script>

<?php } ?>

</div>

</body>

</html>

Send mail:

<?php

//To Handle Session Variables on This Page

session_start();

//If user Not logged in then redirect them back to homepage.

//This is required if user tries to manually enter view-job-post.php in URL.

if (empty($_SESSION['id_admin'])) {

header("Location: index.php");

exit();

require_once("../db.php");

$sql = "select * from users ";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

The college placement management system

while ($row = $result->fetch_assoc()) {

//the subject

$sub = "New Notice has been posted.";

//the message

$msg = "The TPO has posted a new notice on the placement portal. Go to your profile on
placement portal to check the notice.";

//recipient email here

$str = $row['email'];

$rec = "$str";

//send email

mail($rec, $sub, $msg);

}
}

Student Data

ROLL FIRST LAST PHONE EMAIL

NUMBER NAME NAME NUMBER ID

216E1A0501 DANDU AKSHAYA 8179786695 Akshayadandu2003a@gm

216E1A0502 ANDRA ANITHA 7702853460 anitha57572@gmail.

216E1A0503 BALLINA NEERAJA 7780207800 neerajaballina@gmail

216E1A0504 BOMMIDI SUDARSHAN 7995292726 sudarshankumar66040@g

KUMAR

216E1A0505 BOTCHU BHARGAV 7389456794 botchubhargav@gmai

216E1A0506 BIRI RAMU 7997660826 biriramu@gmail.co

The college placement management system
216E1A0507 CHENGALA SIREESHA 7702672655 chengalasireesha9@gm

216E1A0508 CHIRALA VENKATESH 9100104637 venkateshchiralavenkatesh4

m
216E1A0509 CHITTURI RUPA SRI 8125631959 rupasrichitturi2@gmai

216E1A0510 DABBIRU PRIYANKA 7075226624 priyaraghav882@gma

216E1A0511 ANDALA MADHU 9014816467 andalamadhu156@gma

216E1A0513 GOLLORI PAVANI 9859265999 golloripavani@gmail

216E1A0514 YALLAPU SAI 9154625660 y.sai779@gmail.co

216E1A0515 JAGARAPU MANJUSHA 8143907155 jagarapumanjusha@gm

216E1A0516 POOJA KUMARI 9573821788 Poojasapp786@gmail

216E1A0519 KAKI BHAVANI 7780277850 k.bhavani865@gmail

216E1A0520 KAMILI ASWINI 6304443689 aswinikamili@gmail

216E1A0521 KARANAM ABHISHEK 8008541086 abhikaranam03@gmai

216E1A0523 KOPPISETTI VIJAYALAKSHM 7337039634 vsianrnuu219@gmail

216E1A0524 KORRA KUMARI 8919095588 kumarikorra83@gmai

216E1A0526 KOYYA SATHISH 7981748558 satishksatishkumar6@gm

KUMAR

216E1A0527 KURMANA PADMA VATHI 7032628074 padmakurmana7@gma

216E1A0528 MAMIDI SIREESHA 8074462683 sireeshamamidi9@gma

216E1A0530 MARLA JASHUVA SAI 6305299377 jashuvasai143@gmai

216E1A0531 MARRI SHARON 9154565304 marrisharone@gmail

216E1A0536 PANGI SANTHI 9390044060 pangisanthi08@gmail

216E1A0537 PENTAKOTA SAISURYAKIRA 8333972489 saisuryakiranpentakota7@

The college placement management system

216E1A0538 SANE ARAVIND 9989190744 sanearavind86@gmai

216E1A0539 SAVARA ANIL

216E1A0540 SINGAMPALLI BHAGYASRI 8184975251 singampallibhagyasri47@g

216E1A0541 SRUNGAVARPU NAGESWARI 6301887440 nagusrungavarapu1114@g

216E1A0543 THATIKONDHA HARATHI 9573364711 thatikondaharathi143@gm

216E1A0544 TEPPALA JEEVAN 9014171810 jeevanchaithanya4@gm

CHAITHANYA

216E1A0545 THOTA SIVAJI 8317594501 thotasivaji2021@gmai

216E1A0546 URLAPU KAVYA 9676632596 kavyaurlapu1@gmail

216E1A0548 YAGATI LIKITHA 7093940748 ylikitha2@gmail.co

226E5A0501 ADARI KEERTHIKANTH 9121480847 kkmails4u@gmail.c

226E5A0502 ANDUKURI HARIKRISHNA ADITYA SRI RAM 9440185560 andukurisriram9866@gm

226E5A0503 BEJAVADA VISHNU 7286805952 sumanthgandhi612@gm

226E5A0504 DUNGA SYAMANTH 7093654195 dunga.shyamanth225@gm

226E5A0505 DUNGA TEJAS 7702178293 dunga.tejas@gmail.c

226E5A0506 MADDALA LAVANYAPRABHA 7095540787 lavanyaprabha35@gma

226E5A0507 MADEPALLI BUJJI 8886744579 bujjimadepalli9@gma

226E5A0509 YELAMANCHILI VENKATESH 7207551413 venkyadav154@gmai

The college placement management system

Update drive:

<?php
//To Handle Session Variables on This Page
session_start();

//If user Not logged in then redirect them back to homepage.

//This is required if user tries to manually enter view-job-post.php in URL.
if (empty($_SESSION['id_jobpost'])) {
header("Location: ../index.php");
exit();
}

//Including Database Connection From db.php file to avoid rewriting in all files
require_once("../db.php");

?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

The college placement management system

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';

<section id="candidates" class="content-header">

</div>

<div class="col-md-8 bg-white padding-2">

<h2>Update Drive</h2>
<p>In this section you can change drive details.</p>
<div class="row">
<form action="updatedrive1.php" method="post" enctype="multipart/form-data">
<?php
$sql = "SELECT * FROM job_post WHERE id_jobpost='$_SESSION[id_jobpost]'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
?>
<div class="col-md-6 latest-job ">
<div class="form-group">
<label>Company Name</label>
<input type="text" class="form-control input-lg" name="companyname"
id="companyname" value="<?php echo $row['jobtitle']; ?>">
The college placement management system
</div>
<div class="form-group">
<label>Role</label>
<input type="text" class="form-control input-lg" name="role" id="role" value="<?php
echo $row['experience']; ?>">
</div>

<div class="form-group">
<label>Drive Detail</label>
<textarea class="form-control input-lg" rows="4" id="description"
name="description"><?php echo $row['description']; ?></textarea>
</div>
<div class="form-group">
<button type="submit" name="submit" id="submit" class="btn btn-flat btn-
success">Update Profile</button>
</div>
</div>
<div class="col-md-6 latest-job ">
<div class="form-group">
<label for="contactno">Eligibility</label>
<input type="text" class="form-control input-lg" id="Eligibility" name="Eligibility"
placeholder="Eligibility" value="<?php echo $row['maximumsalary']; ?>">
</div>
<div class="form-group">
<label for="city">CTC</label>
<input type="text" class="form-control input-lg" id="CTC" name="CTC" value="<?
php echo $row['minimumsalary']; ?>" placeholder="CTC">
</div>
<div class="form-group">
<label for="state">Qualification Required</label>
<input type="text" class="form-control input-lg" id="qualification"
name="qualification" placeholder="qualification" value="<?php echo $row['qualification']; ?>">
</div>

</div>
<?php
}
}
?>
</form>
</div>

</div>
</div>

The college placement management system

</div>
</div>

</section>

</div>

<footer class=" main-footer" style="margin-left: 0px;">

</footer>

<div class="control-sidebar-bg"></div>

</div>

</body>

</html>

View job post:

<?php

//To Handle Session Variables on This Page

session_start();

if (empty($_SESSION['id_admin'])) {
header("Location: ../index.php");
exit();
}
The college placement management system
//Including Database Connection From db.php file to avoid rewriting in all files
require_once("../db.php");

$sql1 = "SELECT * FROM job_post INNER JOIN company ON job_post.id_company=company.id_company

WHERE id_jobpost='$_GET[id]'";
$result1 = $conn->query($sql1);
if ($result1->num_rows > 0) {
$row = $result1->fetch_assoc();
}

?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ionicons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<body class="hold-transition skin-green sidebar-mini">

<?php
The college placement management system
include 'header.php';
?>

<section id="candidates" class="content-header">

</div>
<div class="col-md-8 bg-white padding-2">
<div class="pull-left">
<h2><b><?php echo $row['jobtitle']; ?></b></h2>
</div>
<div class="pull-right">
<a href="active-jobs.php" class="btn btn-default btn-lg btn-flat margin-top-20"><i class="fa fa-arrow-circle-
left"></i> Back</a>
</div>
<div class="clearfix"></div>
<hr>
<div>
<p><span class="margin-right-10"><i class="fa fa-location-arrow text-green"> Role: </i> <?php echo
$row['experience']; ?> </span><span class="margin-right-10"> <i class="fa fa-money text-green"> CTC:</i> <?php
echo "Rs " . $row['minimumsalary'] . " "; ?></span> <span class="margin-right-10"><i class="fa fa-calendar text-
green"> Drive Date:</i> <?php echo date("d-M-Y", strtotime($row['createdat'])); ?></span><span class="margin-
right-10"><i class="fa fa-location-calendar text-green"> Eligibility: </i> <?php echo $row['maximumsalary'] . "%"; ?>
</span></p>

</div>
<div>
<?php echo stripcslashes($row['description']); ?>
</div>
<div class="pull-right">
<a style="margin-left:2px" href="updatedrive.php?id=<?php echo $row['id_jobpost']; ?>" class="btn btn-
default btn-lg btn-flat margin-top-20"><i class="fa fa-arrow-circle-lef" "></i> Update Drive</a>
</div>

</div>
<div class=" col-md-2">

</div>
</div>
</div>
</section>
<?php
$_SESSION['id_jobpost'] = $row['id_jobpost'];
The college placement management system
?>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="control-sidebar-bg"></div>

</div>


<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/js/bootstrap.min.js"></script>

<script src="../js/adminlte.min.js"></script>
</body>
</html>
Company: Add mail:
<?php
session_start();
if(empty($_SESSION['id_company'])) {
header("Location: ../index.php");
exit();
}
require_once("../db.php");
if(isset($_POST)) {
$to = $_POST['to'];
$subject = mysqli_real_escape_string($conn, $_POST['subject']);
$message = mysqli_real_escape_string($conn, $_POST['description'
$sql = "INSERT INTO mailbox (id_fromuser, fromuser, id_touser, subject, message) VALUES
('_SESSION[id_company]', 'company', '$to', '$subject', '$message')";
if($conn->query($sql) == TRUE) {
header("Location: mailbox.php");
exit();
} else {
echo $conn->error;
}
} else {
header("Location: mailbox.php");
The college placement management system
Change password:

<script exit();
}
src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jqu
ery.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-
bootstrap/3.3.7/js/bootstrap.min.js"></script>

<script src="../js/adminlte.min.js"></script>
</body>
</html>

<?php

//To Handle Session Variables on This Page

session_start();

//If user Not logged in then redirect them back to homepage.

if (empty($_SESSION['id_company'])) {
header("Location: ../index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Placement Portal</title>

<meta content="width=device-width, initial-scale=1, maximum-
scale=1, user-scalable=no" name="viewport">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7
The college placement management system
/css/bootstrap.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/c
ss/font-awesome.min.css">

<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/ionicons/2.0.1/css/ion
icons.min.css">

<link rel="stylesheet" href="../css/AdminLTE.min.css">
<link rel="stylesheet" href="../css/_all-skins.min.css">

<link rel="stylesheet" href="../css/custom.css">

<link rel="stylesheet"
href="https://cdn.datatables.net/1.10.15/css/jquery.dataTables.min
.css">

<body class="hold-transition skin-green sidebar-mini">

<a href="index.php" class="logo logo-bg">

<span class="logo-mini"><b>J</b>P</span>

<span class="logo-lg"><b>Placement</b> Portal</span>
</a>

</ul>
</div>
</nav>
</header>

The college placement management system
<div class="content-wrapper" style="margin-left: 0px;">

<section id="candidates" class="content-header">

<div class="container">
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">Welcome <b><?php echo
$_SESSION['name']; ?></b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li><a href="index.php"><i class="fa fa-
dashboard"></i> Dashboard</a></li>
<li><a href="edit-company.php"><i class="fa fa-
tv"></i> My Company</a></li>
<li><a href="create-job-post.php"><i class="fa fa-
file-o"></i> Create Job Post</a></li>
<li><a href="my-job-post.php"><i class="fa fa-file-
o"></i> My Job Post</a></li>
<li><a href="job-applications.php"><i class="fa fa-
file-o"></i> Job Application</a></li>
<li class="active"><a href="mailbox.php"><i
class="fa fa-envelope"></i> Mailbox</a></li>
<li><a href="settings.php"><i class="fa
fa-gear"></i> Settings</a></li>
<li><a href="resume-database.php"><i class="fa fa-
user"></i> Resume Database</a></li>
<li><a href="../logout.php"><i class="fa fa-arrow-
circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">
The college placement management system
<form action="add-mail.php" method="post">
<div class="box box-primary">
<div class="box-header with-border">
<h3 class="box-title">Compose New Message</h3>
</div>

<div class="box-body">
<div class="form-group">
<select name="to" class="form-control">
<?php
$sql = "SELECT * FROM apply_job_post INNER
JOIN users ON apply_job_post.id_user=users.id_user WHERE
apply_job_post.id_company='$_SESSION[id_company]' AND
apply_job_post.status='2'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
echo '<option value="' . $row['id_user'] . '">' .
$row['firstname'] . ' ' . $row['lastname'] . '</option>';
}
}
?>
</select>
</div>
<div class="form-group">
<input class="form-control" name="subject"
placeholder="Subject:">
</div>
<div class="form-group">
<textarea class="form-control input-lg"
id="description" name="description" placeholder="Job
Description"></textarea>
</div>
</div>

The college placement management system
<div class="box-footer">
<div class="pull-right">
<button type="submit" class="btn btn-primary"><i
class="fa fa-envelope-o"></i> Send</button>
</div>
<a href="mailbox.php" class="btn btn-default"><i
class="fa fa-times"></i> Discard</a>
</div>

</div>
</form>
</div>
</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

The college placement management system

</footer>

</div>

</body>

</html>

Index php:
<?php
//To Handle Session Variables on This Page
session_start();

//If user Not logged in then redirect them back to homepage.

if (empty($_SESSION['id_company'])) {
The college placement management system
header("Location: ../index.php");
exit();
}

require_once("../db.php");
?>
<!DOCTYPE html>
<html>

The college placement management system

<body class="hold-transition skin-green sidebar-mini">

<?php

include 'header.php';
?>

<section id="candidates" class="content-header">

<div class="container">
The college placement management system
<div class="row">
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">Welcome <b><?php echo $_SESSION['name']; ?></b></h3>
</div>
<div class="box-body no-padding">
<ul class="nav nav-pills nav-stacked">
<li class="active"><a href="index.php"><i class="fa fa-dashboard"></i>
Dashboard</a></li>
<li><a href="edit-company.php"><i class="fa fa-tv"></i> Update Profile</a></li>
<li><a href="create-job-post.php"><i class="fa fa-file-o"></i> Post Drive</a></li>
<li><a href="my-job-post.php"><i class="fa fa-file-o"></i> Current Drives</a></li>
<li><a href="job-applications.php"><i class="fa fa-file-o"></i> Drive
Applications</a></li>
<li><a href="mailbox.php"><i class="fa fa-envelope"></i> Mailbox</a></li>
<li><a href="settings.php"><i class="fa fa-gear"></i> Settings</a></li>
<li><a href="resume-database.php"><i class="fa fa-user"></i> Resume Database</a></li>
<li><a href="../logout.php"><i class="fa fa-arrow-circle-o-right"></i> Logout</a></li>
</ul>
</div>
</div>
</div>
<div class="col-md-9 bg-white padding-2">

<h3>Overview</h3>
<div class="alert alert-info alert-dismissible">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<i class="icon fa fa-info"></i> In this dashboard you are able to change your account settings,
post and manage your jobs. Got a question? Do not hesitate to drop us a mail.
</div>

<div class="row">
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-red"><i class="ion ion-ios-people-outline"></i></span>
<div class="info-box-content">
<span class="info-box-text">Job Posted</span>
<?php
The college placement management system
$sql = "SELECT * FROM job_post WHERE id_company='$_SESSION[id_company]'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
$total = $result->num_rows;
} else {
$total = 0;
}

?>
<span class="info-box-number"><?php echo $total; ?></span>
</div>
</div>
</div>
<div class="col-md-6">
<div class="info-box bg-c-yellow">
<span class="info-box-icon bg-green"><i class="ion ion-ios-browsers"></i></span>
<div class="info-box-content">
<span class="info-box-text">Application For Jobs</span>
<?php
$sql = "SELECT * FROM apply_job_post WHERE
id_company='$_SESSION[id_company]'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
$total = $result->num_rows;
} else {
$total = 0;
}
?>
<span class="info-box-number"><?php echo $total; ?></span>
</div>
</div>
</div>
</div>

</div>
</div>
</div>
The college placement management system
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">
<div class="text-center">
<strong>Copyright © 2022 <a href="scsit@Davv">Placement Portal</a>.</strong> All rights
reserved.
</div>
</footer>

</div>

</html>

Resume database:

<?php

//To Handle Session Variables on This Page

session_start();

//If user Not logged in then redirect them back to homepage.

//This is required if user tries to manually enter view-job-post.php in URL.
if (empty($_SESSION['id_company'])) {
header("Location: ../index.php");
exit();
The college placement management system
}
require_once("../db.php");
?>
<!DOCTYPE html>
<html>

The college placement management system

family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>

<body class="hold-transition skin-green sidebar-mini">

<div class="wrapper">
<?php

include 'header.php';
?>

<section id="candidates" class="content-header">

if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {

$skills = $row['ug'];
$skills = explode(',', $skills);
?>
<tr>
<td><?php echo $row['firstname'] . ' ' . $row['lastname']; ?></td>
<td><?php echo $row['qualification']; ?></td>
<td>
<?php
foreach ($skills as $value) {
echo ' <span class="label label-success">' . $value . '</span>';
}
?>
</td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['contactno']; ?></td>
The college placement management system
<?php if ($row['resume'] != '') { ?>
<td><a href="../uploads/resume/<?php echo $row['resume']; ?>" download="<?php
echo $row['firstname'] . ' Resume'; ?>"><i class="fa fa-file-pdf-o"></i></a></td>
<?php } else { ?>
<td>No Resume Uploaded</td>
<?php } ?>
<td>

<?php

}
}
?>

</tbody>
</table>
</div>
</div>
</div>

</div>
</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="control-sidebar-bg"></div>
The college placement management system
</div>

</html>

<?php

session_start();

if (isset($_SESSION['id_user']) || isset($_SESSION['id_company'])) {
header("Location: index.php");
exit();

The college placement management system

}

?>
<!DOCTYPE html>
<html>

<body class="hold-transition skin-green sidebar-mini">

<?php
include 'uploads/register_page_header.php';
?>

The college placement management system

<section class="content-header">
<div class="container">
<div class="row latest-job margin-top-50 margin-bottom-20 bg-white">
<h3 class="text-center margin-bottom-20">Create Your Profile</h3>
<form method="post" id="registerCandidates" action="adduser.php" enctype="multipart/form-
data">
<div class="col-md-6 latest-job ">
<div class="form-group">
<input class="form-control input-lg" type="text" id="fname" name="fname"
placeholder="First Name *" required>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="lname" name="lname"
placeholder="Last Name *" required>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="email" name="email"
placeholder="Email *" required>
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="aboutme" name="aboutme"
placeholder="Brief intro about yourself *" required></textarea>
</div>
<div class="form-group">
<label>Date Of Birth</label>
<input class="form-control input-lg" type="date" id="dob" min="1960-01-01" max="1999-
01-31" name="dob" placeholder="Date Of Birth">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="age" name="age" placeholder="Age"
readonly>
</div>
<div class="form-group">
<label>Passing Year</label>
<input class="form-control input-lg" type="date" id="passingyear" name="passingyear"
placeholder="Passing Year">
</div>
The college placement management system
<div class="form-group">
<input class="form-control input-lg" type="text" id="qualification" name="qualification"
placeholder="Highest Qualification">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="stream" name="stream"
placeholder="Stream">
</div>
<div class="form-group checkbox">
<label><input type="checkbox"> I accept terms & conditions</label>
</div>
<div class="form-group">
<button class="btn btn-flat btn-success">Register</button>
</div>
<?php
//If User already registered with this email then show error message.
if (isset($_SESSION['registerError'])) {
?>
<div class="form-group">
<label style="color: red;">Email Already Exists! Choose A Different Email!</label>
</div>
<?php
unset($_SESSION['registerError']);
}
?>

<?php if (isset($_SESSION['uploadError'])) { ?>

</div>
<div class="col-md-6 latest-job ">
<div class="form-group">
<input class="form-control input-lg" type="password" id="password" name="password"
placeholder="Password *" required>
</div>
The college placement management system
<div class="form-group">
<input class="form-control input-lg" type="password" id="cpassword" name="cpassword"
placeholder="Confirm Password *" required>
</div>
<div id="passwordError" class="btn btn-flat btn-danger hide-me">
Password Mismatch!!
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="contactno" name="contactno"
minlength="10" maxlength="10" onkeypress="return validatePhone(event);" placeholder="Phone
Number">
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="address" name="address"
placeholder="Address"></textarea>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="city" name="city" placeholder="City">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="state" name="state"
placeholder="State">
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="skills" name="skills"
placeholder="Enter Skills"></textarea>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="designation" name="designation"
placeholder="Designation">
</div>

<div class="form-group">
<label style="color: red;">File Format PDF Only!</label>
<input type="file" name="resume" class="btn btn-flat btn-danger" required>
</div>
</div>
</form>

</div>
The college placement management system
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="control-sidebar-bg"></div>

</div>

//event.keycode will return unicode for characters and numbers like a, b, c, 5 etc.
//event.which will return key for mouse events and other events like ctrl alt etc.
var key = window.event ? event.keyCode : event.which;

if (event.keyCode == 8 || event.keyCode == 46 || event.keyCode == 37 || event.keyCode == 39) {

The college placement management system

// 8 means Backspace
//46 means Delete
// 37 means left arrow
// 39 means right arrow
return true;
} else if (key < 48 || key > 57) {
// 48-57 is 0-9 numbers on your keyboard.
return false;
} else return true;
}
</script>

if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {

age--;
}

$('#age').val(age);
});
</script>
<script>
$("#registerCandidates").on("submit", function(e) {
e.preventDefault();
if ($('#password').val() != $('#cpassword').val()) {
$('#passwordError').show();
} else {
$(this).unbind('submit').submit();
}
});
</script>
</body>

The college placement management system

</html>

<?php

session_start();

if (isset($_SESSION['id_user']) || isset($_SESSION['id_company'])) {
header("Location: index.php");
exit();
}

?>
<!DOCTYPE html>
<html>

The college placement management system

<link rel="stylesheet" href="https://fonts.googleapis.com/css?
family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
</head>

<body class="hold-transition skin-green sidebar-mini">

<?php
include 'uploads/register_page_header.php';
?>

<div class="wrapper">
<div class=" content-wrapper" style="margin-left: 0px;">

<section class="content-header">
<div class="container">
<div class="row latest-job margin-top-50 margin-bottom-20 bg-white">
<h3 class="text-center margin-bottom-20">Create Your Profile</h3>
<form method="post" id="registerCandidates" action="adduser.php" enctype="multipart/form-
data">
<div class="col-md-6 latest-job ">
<div class="form-group">
<input class="form-control input-lg" type="text" id="fname" name="fname"
placeholder="First Name *" required>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="lname" name="lname"
placeholder="Last Name *" required>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="email" name="email"
placeholder="Email *" required>
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="aboutme" name="aboutme"
placeholder="Brief intro about yourself *" required></textarea>
</div>
<div class="form-group">
<label>Date Of Birth</label>
<input class="form-control input-lg" type="date" id="dob" min="1960-01-01" max="1999-
The college placement management system
01-31" name="dob" placeholder="Date Of Birth">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="age" name="age" placeholder="Age"
readonly>
</div>
<div class="form-group">
<label>Passing Year</label>
<input class="form-control input-lg" type="date" id="passingyear" name="passingyear"
placeholder="Passing Year">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="qualification" name="qualification"
placeholder="Highest Qualification">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="stream" name="stream"
placeholder="Stream">
</div>
<div class="form-group checkbox">
<label><input type="checkbox"> I accept terms & conditions</label>
</div>
<div class="form-group">
<button class="btn btn-flat btn-success">Register</button>
</div>
<?php
//If User already registered with this email then show error message.
if (isset($_SESSION['registerError'])) {
?>
<div class="form-group">
<label style="color: red;">Email Already Exists! Choose A Different Email!</label>
</div>
<?php
unset($_SESSION['registerError']);
}
?>

<?php if (isset($_SESSION['uploadError'])) { ?>

The college placement management system

</div>
<div class="col-md-6 latest-job ">
<div class="form-group">
<input class="form-control input-lg" type="password" id="password" name="password"
placeholder="Password *" required>
</div>
<div class="form-group">
<input class="form-control input-lg" type="password" id="cpassword" name="cpassword"
placeholder="Confirm Password *" required>
</div>
<div id="passwordError" class="btn btn-flat btn-danger hide-me">
Password Mismatch!!
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="contactno" name="contactno"
minlength="10" maxlength="10" onkeypress="return validatePhone(event);" placeholder="Phone
Number">
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="address" name="address"
placeholder="Address"></textarea>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="city" name="city" placeholder="City">
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="state" name="state"
placeholder="State">
</div>
<div class="form-group">
<textarea class="form-control input-lg" rows="4" id="skills" name="skills"
placeholder="Enter Skills"></textarea>
</div>
<div class="form-group">
<input class="form-control input-lg" type="text" id="designation" name="designation"
The college placement management system
placeholder="Designation">
</div>

<div class="form-group">
<label style="color: red;">File Format PDF Only!</label>
<input type="file" name="resume" class="btn btn-flat btn-danger" required>
</div>
</div>
</form>

</div>
</div>
</section>

</div>

<footer class="main-footer" style="margin-left: 0px;">

<div class="control-sidebar-bg"></div>

</div>

The college placement management system

<script src="js/adminlte.min.js"></script>

if (event.keyCode == 8 || event.keyCode == 46 || event.keyCode == 37 || event.keyCode == 39) {

if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {

age--;
}

$('#age').val(age);
});
</script>
<script>

The college placement management system

$("#registerCandidates").on("submit", function(e) {
e.preventDefault();
if ($('#password').val() != $('#cpassword').val()) {
$('#passwordError').show();
} else {
$(this).unbind('submit').submit();
}
});
</script>
</body>

</html>

Result :

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['roll_number']) &&
isset($_POST['semester']) && !empty($_POST['semester'])) {
$roll_number = $_POST['roll_number'];
$semester = $_POST['semester']; // Get selected semester
$file = fopen("studentdata1.csv", "r");
$header = fgetcsv($file); // Read header row
$student_data = null;

while (($row = fgetcsv($file)) !== false) {

if ($row[0] == $roll_number) { // Assuming Roll Number is in the first column
$student_data = $row;
break;
}
}
fclose($file);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
The college placement management system
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Student Results</title>
<style>
body { font-family: Arial, sans-serif; }
table { width: 80%; border-collapse: collapse; margin: 20px auto; }
th, td { border: 1px solid #ddd; padding: 10px; text-align: left; }
th { background-color:rgba(255, 0, 166, 0.67); color: white; }
.container { text-align: center; margin-top: 50px; }
.input-box { padding: 10px; width: 300px; }
.btn { padding: 10px 20px; background-color: green; color: white; border: none; cursor: pointer; }
.hidden { display: none; } /* Hide semester tables by default */
</style>
</head>
<body>
<img src="assets/img/logo.png">

<section id="hero-animated" class="hero-animated d-flex align-items-center">

<div class="container">
<h2>Student Results</h2>
<form method="POST" onsubmit="return validateForm();">
<input type="text" name="roll_number" placeholder="Enter Roll Number" class="input-box"
required>
<select name="semester" class="input-box" id="semester">
<option value="">Select Semester</option>
<option value="1-1">1-1</option>
<option value="1-2">1-2</option>
<option value="2-1">2-1</option>
<option value="2-2">2-2</option>
<option value="3-1">3-1</option>
<option value="3-2">3-2</option>
<option value="4-1">4-1</option>
<option value="4-2">4-2</option>
</select>
<button type="submit" class="btn">Get Data</button>
</form>
The college placement management system
<?php if (isset($student_data)) { ?>
<h3>Student Details</h3>
<table>
<tr><th>Hall Ticket No</th><td><?php echo $student_data[0]; ?></td></tr>
<tr><th>Student Name</th><td><?php echo $student_data[1] . " " . $student_data[2];
?></td></tr>
<tr><th>Department</th><td><?php echo $student_data[10]; ?></td></tr>
<tr><th>Mobile</th><td><?php echo $student_data[3]; ?></td></tr>
<tr><th>Email</th><td><?php echo $student_data[4]; ?></td></tr>
<tr><th>Father Name</th><td><?php echo $student_data[5]; ?></td></tr>
<tr><th>Current Location</th><td><?php echo $student_data[6]; ?></td></tr>
<tr><th>Gender</th><td><?php echo $student_data[7]; ?></td></tr>
<tr><th>Date Of Birth</th><td><?php echo $student_data[8]; ?></td></tr>
<tr><th>Aadhar Number</th><td><?php echo $student_data[9]; ?></td></tr>
<tr><th>Attendance</th><td><?php echo $student_data[17]; ?></td></tr>
</table>

<div id="results">
<h3>Subject Grades</h3>

<table id="1-1" class="hidden">
<tr><th>1A Paper Code</th><th>Grade</th></tr>
<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>
<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>
<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>
<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>
<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>
<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>
</table>

<table id="1-2" class="hidden">

<tr><th>1B Paper Code</th><th>Grade</th></tr>
<tr><td>CC</td><td><?php echo $student_data[26]; ?></td></tr>
<tr><td>DL</td><td><?php echo $student_data[27]; ?></td></tr>
<tr><td>BC</td><td><?php echo $student_data[28]; ?></td></tr>
<tr><td>UHV</td><td><?php echo $student_data[29]; ?></td></tr>
<tr><td>IOT</td><td><?php echo $student_data[30]; ?></td></tr>
The college placement management system
<tr><td>SCT</td><td><?php echo $student_data[31]; ?></td></tr>
</table>

<table id="2-1" class="hidden">

<tr><th>1A Paper Code</th><th>Grade</th></tr>
<tr><td>CC</td><td><?php echo $student_data[20]; ?></td></tr>
<tr><td>DL</td><td><?php echo $student_data[21]; ?></td></tr>
<tr><td>BC</td><td><?php echo $student_data[22]; ?></td></tr>
<tr><td>UHV</td><td><?php echo $student_data[23]; ?></td></tr>
<tr><td>IOT</td><td><?php echo $student_data[24]; ?></td></tr>
<tr><td>SCT</td><td><?php echo $student_data[25]; ?></td></tr>
</table>

<table id="2-2" class="hidden">

<table id="3-1" class="hidden">

<tr><th>1B Paper Code</th><th>Grade</th></tr>
<tr><td>CC</td><td><?php echo $student_data[26]; ?></td></tr>
<tr><td>DL</td><td><?php echo $student_data[27]; ?></td></tr>
<tr><td>BC</td><td><?php echo $student_data[28]; ?></td></tr>
<tr><td>UHV</td><td><?php echo $student_data[29]; ?></td></tr>
<tr><td>IOT</td><td><?php echo $student_data[30]; ?></td></tr>
<tr><td>SCT</td><td><?php echo $student_data[31]; ?></td></tr>
</table>

<table id="3-2" class="hidden">

The college placement management system

<table id="4-1" class="hidden">

<tr><th>4A Paper Code</th><th>Grade</th></tr>
<tr><td>CC</td><td><?php echo $student_data[11]; ?></td></tr>
<tr><td>DL</td><td><?php echo $student_data[12]; ?></td></tr>
<tr><td>BC</td><td><?php echo $student_data[13]; ?></td></tr>
<tr><td>UHV</td><td><?php echo $student_data[14]; ?></td></tr>
<tr><td>IOT</td><td><?php echo $student_data[15]; ?></td></tr>
<tr><td>SCT</td><td><?php echo $student_data[16]; ?></td></tr>
</table>

<table id="4-2" class="hidden">

function validateForm() {
let semester = document.getElementById("semester").value;
if (semester === "") {
alert("Please select a semester before submitting.");

The college placement management system

return false;
}
return true;
}
</script>
<?php } ?>

</div>

</body>
</html>

Contact page:

<!DOCTYPE html>
<html lang="en">

<meta content="width=device-width, initial-scale=1.0" name="viewport">

<title>Placement Portal</title>
<meta content="" name="description">
<meta content="" name="keywords">

<link href="img/logo.png" rel="icon">
<link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">

<link rel="preconnect" href="https://fonts.googleapis.com">
<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
<link href="https://fonts.googleapis.com/css2?
family=Open+Sans:ital,wght@0,300;0,400;0,500;0,600;0,700;1,300;1,400;1,500;1,600;1,700&family=
Poppins:ital,wght@0,300;0,400;0,500;0,600;0,700;1,300;1,400;1,500;1,600;1,700&family=Source+San
s+Pro:ital,wght@0,300;0,400;0,600;0,700;1,300;1,400;1,600;1,700&display=swap" rel="stylesheet">

<link href="assets/css/variables.css" rel="stylesheet">

<body>

<?php

include 'php/header.php'

<section id="contact" class="contact">
<div class="container">

<div class="section-header">
<h2><strong>Contact Us</strong></h2>

The college placement management system

<p>GIITS</p>
</div>

</div>

<div class="row gy-5 gx-lg-5">

<div class="info">
<h3>Get in touch</h3>
<p>PlACEMENT CELL</p>

<div class="info-item d-flex">

<i class="bi bi-geo-alt flex-shrink-0"></i>
<div>
<h4>Location:</h4>
<p>Giits Institute of Information Technology, A 10, A Block, Block A, Industrial
Area, Sector 62, aganampidi, Andhra Pradesh 531001.</p>
</div>
</div>

<div class="info-item d-flex">

<i class="bi bi-envelope flex-shrink-0"></i>
<div>
<h4>Email:</h4>
<p>codestomp@gmail.com</p>
</div>
</div>
The college placement management system
<div class="info-item d-flex">
<i class="bi bi-phone flex-shrink-0"></i>
<div>
<h4>Call:</h4>
<p>9821023521</p>
</div>
</div>

</div>

<div class="col-lg-8">
<form action="forms/contact.php" method="post" role="form" class="php-email-form">
<div class="row">
<div class="col-md-6 form-group">
<input type="text" name="name" class="form-control" id="name"
placeholder="Your Name" required>
</div>
<div class="col-md-6 form-group mt-3 mt-md-0">
<input type="email" class="form-control" name="email" id="email"
placeholder="Your Email" required>
</div>
</div>
<div class="form-group mt-3">
<input type="text" class="form-control" name="subject" id="subject"
placeholder="Subject" required>
</div>
<div class="form-group mt-3">
<textarea class="form-control" name="message" placeholder="Message"
required></textarea>
</div>
<div class="my-3">
<div class="loading">Loading</div>
<div class="error-message"></div>
<div class="sent-message">Your message has been sent. Thank you!</div>
</div>
<div class="text-center"><button type="submit">Send Message</button></div>

The college placement management system

</form>
</div>

</div>

</div>
</section>

<?php?>
include 'php/footer.php';

</body>
</html>

The college placement management system

Testing phase

The college placement management system

TESTING PHASE

The testing phase of a Placement Management System, focus on verifying functionality, user experience, security, and
performance, including unit, integration, and user acceptance testing, along with security audits and performance testing
1. Functionality Testing:
 Unit Testing: Test individual components or modules of the system in isolation to ensure they function as expected.
 Integration Testing: Verify that different modules or components work together seamlessly.
 System Testing: Test the entire system as a whole to ensure it meets all requirements.
 User Acceptance Testing (UAT): Involve end-users (placement officers, students, companies) to validate the system's
 usability and functionality in real-world scenarios.
2. User Experience (UX) Testing:
 Usability Testing: Evaluate the ease of use and intuitiveness of the system's interface and workflows.
 Accessibility Testing: Ensure the system is accessible to users with disabilities.
3. Security Testing:
 Security Audits: Conduct thorough security assessments to identify potential vulnerabilities.
 Penetration Testing: Simulate real-world attacks to test the system's security strength.
4. Performance Testing:
 Load Testing: Evaluate the system's ability to handle expected traffic and workload.
 Stress Testing: Determine the system's behavior under extreme conditions.
 Performance Monitoring: Track key performance indicators (KPIs) to identify bottlenecks and areas for optimization.
5. Data Integrity:
 Data Validation: Ensure that data entered into the system is accurate and valid.
 Data Backup and Recovery: Test the system's ability to recover data in case of failure.
6. Defect Management:
 Defect Tracking: Document and track all identified defects, assigning priorities and severity levels.
 Defect Resolution: Ensure that defects are fixed and retested to verify resolution.
7. Regression Testing:
 Regression Testing: Re-run existing tests after code changes to ensure that new changes haven't introduced any

regressions.

The college placement management system

Implementation

The college placement management system

IMPLEMENTATION
1. Project Management & Monitoring:
 Implementation Plan:
Have a detailed plan outlining tasks, timelines, resources, and responsibilities.
 Monitoring & Control:
Continuously track progress against the plan, identify potential issues, and take corrective actions.
 Risk Management:
Identify and mitigate potential risks that could derail the project.
 Communication:
Maintain regular communication with stakeholders, including updates on progress, challenges, and decisions.
 Stakeholder Engagement:
Keep stakeholders informed and involved throughout the implementation process.
 Testing & Quality Assurance:
Thoroughly test the system to ensure it functions as expected and meets quality standards.
2. Data Management:
 Data Migration: Plan and execute the migration of existing data into the new system.
 Data Integrity: Ensure the accuracy and completeness of data within the system.
 Data Security: Implement measures to protect sensitive data from unauthorized access.
 Data Backup & Recovery: Establish procedures for backing up and recovering data in case of system failures.
3. System Configuration & Customization:
 Configuration:
Configure the system according to the specific needs and requirements of the placement cell.
 Customization:
Tailor the system to meet unique requirements, such as specific reporting needs or integration with other systems.
4. User Training & Support:
 User Training: Provide comprehensive training to users on how to use the system effectively.
 Documentation: Develop clear and concise documentation for users to refer to.
 Support: Establish a system for providing ongoing support to users.
5. System Integration:
 Integration with other systems:
Ensure seamless integration with other relevant systems, such as the student information system or the HR system.
 API integration:
If applicable, ensure that the system can be integrated with other systems using

The college placement management system

Maintenance

The college placement management system

MAINTAINANCE

The maintaining system functionality, addressing bugs and security issues, updating student and company data, and
ensuring smooth operation for users.
Here's a more detailed breakdown:
1. System Functionality & Performance:
Bug Fixing:
Address any reported bugs or errors that compromise the system's functionality.
Security Updates:
Implement necessary security patches and updates to protect the system and user data.
Performance Optimization:
Continuously monitor and optimize system performance to ensure quick and efficient operation.
Interface Updates:
Keep the user interface up-to-date and user-friendly, ensuring a smooth experience for all users.
2. Data Management:
Student Data Updates:
Maintain accurate and up-to-date student profiles, including academic records, resumes, and placement status.
Company Data Updates:
Keep company information, including contact details, job openings, and placement criteria, current and accurate.
Data Backup and Recovery:
Implement robust data backup and recovery procedures to prevent data loss.
Data Security:
Ensure the security and confidentiality of student and company data through appropriate access controls and
encryption.
3. User Support and Training:
User Feedback:
Actively solicit and address user feedback to improve the system and user experience.
Training Materials:
Provide comprehensive training materials and support to help users effectively utilize the system.
Documentation:
Maintain up-to-date documentation for the system, including user manuals and technical specifications.
4. System Monitoring and Reporting:
Performance Monitoring:
The college placement management system
Continuously monitor system performance and identify areas for improvement.
Reporting:
Generate reports on system usage, placement trends, and other relevant metrics.
Alerting:
Implement alerting mechanisms to notify administrators of critical issues or event

The college placement management system

The college placement management system
The college placement management system
The college placement management system
The college placement management system
17
1
17
2
51
52
53
54

PMS Project Report
No ratings yet
PMS Project Report
45 pages
Placement Management System BCA Project
No ratings yet
Placement Management System BCA Project
17 pages
CRM Projects Using PHP and MySQL
No ratings yet
CRM Projects Using PHP and MySQL
8 pages
College Placement System-1
No ratings yet
College Placement System-1
21 pages
Mani Project
No ratings yet
Mani Project
68 pages
Project T
No ratings yet
Project T
17 pages
Placement Management System For Campus Recruitment
No ratings yet
Placement Management System For Campus Recruitment
6 pages
Campus Recruitment Management System
No ratings yet
Campus Recruitment Management System
6 pages
College Placement Management System
No ratings yet
College Placement Management System
19 pages
Final Doc Both
No ratings yet
Final Doc Both
36 pages
Project Report
No ratings yet
Project Report
50 pages
Final Doc Project of Training and Placement
100% (1)
Final Doc Project of Training and Placement
60 pages
Placement Portal Project Report
No ratings yet
Placement Portal Project Report
49 pages
Android Spms
No ratings yet
Android Spms
5 pages
Sri - Dr.Gangadhara Rao Kancharla: IV Semester Mini-Project IN
No ratings yet
Sri - Dr.Gangadhara Rao Kancharla: IV Semester Mini-Project IN
16 pages
Basepaper PMSFCR
No ratings yet
Basepaper PMSFCR
3 pages
Campus Placement System Guide
No ratings yet
Campus Placement System Guide
14 pages
Campus Recruitment and Placement System: Rajnish Tripathi, Raghvendra Singh Ms. Jaweria Usmani
No ratings yet
Campus Recruitment and Placement System: Rajnish Tripathi, Raghvendra Singh Ms. Jaweria Usmani
6 pages
Training and Placement Cell Management System.
No ratings yet
Training and Placement Cell Management System.
73 pages
B.Tech Placement System Report
No ratings yet
B.Tech Placement System Report
17 pages
Campus Recruitment System Is A Web Application Software
No ratings yet
Campus Recruitment System Is A Web Application Software
57 pages
Project Report - Placement Management
No ratings yet
Project Report - Placement Management
21 pages
Placement Report With Code
No ratings yet
Placement Report With Code
86 pages
Cse - A 2
No ratings yet
Cse - A 2
22 pages
Ads Mini Project Report - Organized
No ratings yet
Ads Mini Project Report - Organized
72 pages
Seminar Report: "Campus Recruitment System
No ratings yet
Seminar Report: "Campus Recruitment System
9 pages
Group No.17 Final Blackbook
No ratings yet
Group No.17 Final Blackbook
55 pages
Web Based Placement Management System: Anjali.V #, Jeyalakshmi - PR, Anbubala.R, Sri Mathura Devi.g, Ranjini.V
No ratings yet
Web Based Placement Management System: Anjali.V #, Jeyalakshmi - PR, Anbubala.R, Sri Mathura Devi.g, Ranjini.V
4 pages
Training and Placement Cell Abstract
100% (1)
Training and Placement Cell Abstract
5 pages
Asha Mini Project
No ratings yet
Asha Mini Project
71 pages
Student Placement Automation Framework
No ratings yet
Student Placement Automation Framework
60 pages
Vaishnavi04 Paper
No ratings yet
Vaishnavi04 Paper
5 pages
T&P Project Report
No ratings yet
T&P Project Report
25 pages
College Training and Placement System Project Report.
No ratings yet
College Training and Placement System Project Report.
50 pages
Automation of Placement: Submitted by
No ratings yet
Automation of Placement: Submitted by
40 pages
Subhankita Pattanayak - Placement Management System
No ratings yet
Subhankita Pattanayak - Placement Management System
82 pages
Placement Application For Department of Commerce With Computer Applications (Navigator)
No ratings yet
Placement Application For Department of Commerce With Computer Applications (Navigator)
7 pages
Student Placement Cell
No ratings yet
Student Placement Cell
123 pages
Pooja 1
No ratings yet
Pooja 1
34 pages
College Placement Management System
No ratings yet
College Placement Management System
2 pages
Campus Recruitment Uddeshyaa 231210 195621
No ratings yet
Campus Recruitment Uddeshyaa 231210 195621
41 pages
Project Synopsis
No ratings yet
Project Synopsis
5 pages
Placement Management System: A Mini Project Report ON
100% (1)
Placement Management System: A Mini Project Report ON
35 pages
Campus Recruitment Management System
No ratings yet
Campus Recruitment Management System
46 pages
Blackbook Group
No ratings yet
Blackbook Group
82 pages
Final DBMS Report
No ratings yet
Final DBMS Report
59 pages
Training and Placement Cell Mangement System Project Report.
No ratings yet
Training and Placement Cell Mangement System Project Report.
74 pages
Campus Recruitment System 1
No ratings yet
Campus Recruitment System 1
14 pages
Placement Portal Management System
No ratings yet
Placement Portal Management System
28 pages
Abhi Abstract
No ratings yet
Abhi Abstract
2 pages
Seminar Report: "Campus Recruitment System
No ratings yet
Seminar Report: "Campus Recruitment System
11 pages
2.Dbms Project Header
No ratings yet
2.Dbms Project Header
4 pages
PBL Report Example
No ratings yet
PBL Report Example
28 pages
Submitted: Project Management and Finance
No ratings yet
Submitted: Project Management and Finance
8 pages
Placement Management System
100% (2)
Placement Management System
47 pages
Dor - 23 09 2022 - WQ1 223 - Idc 143 2
No ratings yet
Dor - 23 09 2022 - WQ1 223 - Idc 143 2
1 page
Escalate Privileges Via Token Manipulation
No ratings yet
Escalate Privileges Via Token Manipulation
1 page
Active VCs
No ratings yet
Active VCs
11 pages
Dental Color Matching Review
No ratings yet
Dental Color Matching Review
16 pages
Specs DuraDiagnost 452299104071.pdf?nodeid 10787196&vernum - 2
0% (1)
Specs DuraDiagnost 452299104071.pdf?nodeid 10787196&vernum - 2
24 pages
IOGP 544 - Barrier Definition in Brief Explanation: Compilation Slide by Alvin Alfiyansyah
No ratings yet
IOGP 544 - Barrier Definition in Brief Explanation: Compilation Slide by Alvin Alfiyansyah
6 pages
Pass 5755 20-12-24
No ratings yet
Pass 5755 20-12-24
1 page
RKNL-G (15-25 Ton)
No ratings yet
RKNL-G (15-25 Ton)
64 pages
Unit 1-1
No ratings yet
Unit 1-1
2 pages
Tank Quotation 27-11-2023 v1
No ratings yet
Tank Quotation 27-11-2023 v1
4 pages
Research Paper On Programmable Logic Controller
No ratings yet
Research Paper On Programmable Logic Controller
5 pages
Pakistan Studies (O1)
No ratings yet
Pakistan Studies (O1)
11 pages
7M-2 Plate Heat Exchanger
No ratings yet
7M-2 Plate Heat Exchanger
18 pages
Tubular Heaters
No ratings yet
Tubular Heaters
13 pages
Data Sheet 6ES7134-6TD00-0CA1: General Information
No ratings yet
Data Sheet 6ES7134-6TD00-0CA1: General Information
4 pages
Symbolic Reasoning Cha 7
90% (10)
Symbolic Reasoning Cha 7
13 pages
Acidizing 5
No ratings yet
Acidizing 5
4 pages
?????????????????K by TrHPhuc?.AccessibilityPunctuationGroup
No ratings yet
?????????????????K by TrHPhuc?.AccessibilityPunctuationGroup
142 pages
Rise of AI
No ratings yet
Rise of AI
7 pages
Hydraulic Compressor for Power Lines
No ratings yet
Hydraulic Compressor for Power Lines
11 pages
Ur p2 Jan 2021 Ul
No ratings yet
Ur p2 Jan 2021 Ul
41 pages
cn250 PDF
No ratings yet
cn250 PDF
384 pages
Generator Synchronizing Check Protective Function ANSI 25
No ratings yet
Generator Synchronizing Check Protective Function ANSI 25
5 pages
Michelin X Works d2 - Product Sheet - en (1) - 2021
No ratings yet
Michelin X Works d2 - Product Sheet - en (1) - 2021
2 pages
Price List 5-8 (2025-05-08 05 - 43 - 18)
No ratings yet
Price List 5-8 (2025-05-08 05 - 43 - 18)
1 page
A Theory of Generic Interpreters
No ratings yet
A Theory of Generic Interpreters
14 pages
Application of SVM and ANN For Intrusion Detection: Wun-Hwa Chen, Sheng-Hsun Hsu, Hwang-Pin Shen
No ratings yet
Application of SVM and ANN For Intrusion Detection: Wun-Hwa Chen, Sheng-Hsun Hsu, Hwang-Pin Shen
18 pages
TRP 5000
No ratings yet
TRP 5000
112 pages
Foxit PDF Editor - Quick Guide
No ratings yet
Foxit PDF Editor - Quick Guide
6 pages
VTU Result 2022
No ratings yet
VTU Result 2022
2 pages