Final Doc Both
Final Doc Both
PROJECT REPORT
ON
Submitted By
Mr.Gavhane Vikas Navnath
Mr.Landge Tejas Dilip
Guided By
2023-2024
INDEX
Sr.No. Title
1. Acknowledgement.
2. Introduction
• Problem statement
• Objective of the System
4. Implementation details
-Requirement Analysis
5. System Design
-Data Dictionary
-Entity Relationship Diagram
-system Model using OOSE
6. Coding
7. Input-Outputs Screens and Reports
8. Testing
9. Advantages and Future Enhancement
10. Bibliography and Reference
ACKNOWLEDGEMENT
Yours Sincerely,
Shete Chaitnya Sunil
Shelke Ganesh Jayram
(Computer Science)
ABSTRACT
Admin table-
Sr.no Data Field Data Type Size Constraints
1 Admin_id int 20 Primary key
2 Admin_Password varchar 10 Not Null
3 Admin_email varchar 10 Not Null
4 Admin_phoneno Int 10 Foreign key
Company table-
Sr.no Data Field Data Type Size Contraints
1 Company_id int 10 Primary key
2 Company_Name varchar 40 Not Null
3 Company_phoneno Int 10 Foreign key
4 Company_Address varchar 20- Not Null
5 Company_description varchar 30 Not Null
Advertise table-
Sr.no Data Field Data Type Size Contraints
1 Adv_id Int 30 Primary key
2 Adv_Date Varchar 10 Not NulL
3 Company_id Int 50 Foreign key
4 Min_qualification Varchar 50 Not Null
5 Min_Experience Varchar 50 Not Null
6 SkillSet Varchar 50 Not Null
7 Last_date Varchar 50 Not Null
8 No_of_post Varchar 50 Not Null
9 Package_offered Varchar 50 Not Null
Response table-
Sr.no Data Feild Data Type Size Constraints
1 Response_id int 20 Primarykey
2 Adv_id int 30 Foreign key
3 Stud_id int 10 Foreign key
4 Date varchar 20 Not Null
ER-Diagram:-
M
1 MAN
ADMIN AGE COMPANY
M
STUDENT RESP ADVERTISE
OND
Use Case Diagram :-
Registration
login
Post job
Manage Account
Send Mail
Admin
Update Profile
Delete Profile
Company
Logout
Class Diagram :-
Admin Company
+Admin_id:int +Comp_id:int
+User-name:var +Comp_name:var
+Email:String * +Comp_add:var
+Pass:String +comp_Con.no:var
+Post_adv() +Post_job()
+Send_mail() +Send_mail()
+Manage_stud() +Update_profile()
+Manage_comp()
+Update_profile()
* *
Student Advertise
+Stud_id:int +Adv_id:int
+Stud-name:varchar +Adv-Date:varchar
+Stud_pass:String +Last_Date:String
+Stud_con.no:String * * +Comp_id:varchar
+Stud_Email:varchar
+Apply_job() +Add()
+Update_profile() +Update()
+Delete_profile () +Search()
Activity Diagram for user :-
Chea
k
login
Invalid
valid
Register
Create profile
View Adv
End
Activity Diagram for Admin:-
Start
login
Chea
ck
Invalid
login
Id/pa
ss
valid
Post_advertise
Send mail
End
Object diagram:-
A:Admin C:Company
+Admin_id:int +Comp_id:int
1 * +Comp_name:var
+User-name:var
+Email:String +Comp_add:var
+Pass:String +comp_Con.no:var
*
* *
S:Student A:Advertise
+Stud_id:int +Adv_id:int
+Stud-name:varchar * * +Adv-Date:varchar
+Stud_pass:String +Last_Date:String
+Stud_con.no:String +Comp_id:varchar
+Stud_Email:varchar
Component Diagram:-
Student.php
Registration.html
Placement
management
Database
system Current job.php
Company.html
Edu Details.php
Coding:-
Login.php
<?php
include "includes/header.php";
if(isset($_SESSION['admin'])){
header("Location: dashboard.php");
}
if(isset($_SESSION['name'])&&isset($_SESSION['email'])){
header("Location: profile.php");
}
$set_value = 0;
$error = '0';
if(isset($_REQUEST['email'])&&isset($_REQUEST['pass'])){
$email = trim($_REQUEST['email']);
$pass = trim($_REQUEST['pass']);
if($email=="admin@gmail.com"&&$pass=="admin"){
$_SESSION['admin'] = true;
header("Location: dashboard.php");
}
$pass = md5(trim($_REQUEST['pass']));
$sql = "SELECT *
FROM users
WHERE user_email='$email'
AND user_pass='$pass'";
$result = mysqli_query($con, $sql);
$num_rows = mysqli_num_rows($result);
if($num_rows>0){
$row = mysqli_fetch_array($result);
$_SESSION['id'] = $row['user_id'];
$_SESSION['name'] = $row['user_name'];
$_SESSION['email'] = $row['user_email'];
header("Location: home.php");
} else{
$set_value = 1;
$error = "Invalid Email or Password";
}
}
?>
<div class="col-md-9 main">
<!-- login-page -->
<div class="login">
<div class="login-grids">
<div class="col-md-6 log">
<h3 class="tittle" id = "signin">Sign In <i
class="glyphicon glyphicon-lock"></i></h3>
<p id="login_instructions" style="display:
block">Welcome, please enter the following to continue.</p>
<?php
if($set_value==1){
echo '<div id="error" style="display: block;">
<div class="alert alert-danger" role="alert"">
<i class="glyphicon glyphicon-lock"></i>
<strong>Error! : </strong> <span
id="error_message">'.$error.'</span>
</div>
</div>';
}
?>
<div id = "form-area" style="display: block">
<form id = "form" method="post"
action="login.php">
<h5>Email:</h5>
<input type="email" name="email" value=""
id="input-email" placeholder="Enter Your Email ID" required>
<h5>Password:</h5>
<input type="password" name="pass" value=""
id="input-pass" placeholder="Enter Your Password" required>
<input type="submit" value="Login" id="input-
submit" style="display: block">
</form>
<a href="#">Forgot Password ?</a>
</div>
</div>
<div class="col-md-6 login-right">
<h3 class="tittle">Why you should have to register with us
<i class="glyphicon glyphicon-file"></i></h3>
<p>By creating an account with our site, you will be able to
move through the recruitment process faster,
view and apply to various companies by yourself and
many more.</p>
<a href="registration.php" class="hvr-bounce-to-bottom
button">Create An Account</a>
</div>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- //login-page -->
<div class="clearfix"> </div>
<?php
include "includes/footer.php";
?>
Student.php
<?php
include "includes/header.php";
$set_value = 1;
$error = '0';
if(isset($_GET['id'])){
$id = trim($_GET['id']);
$sql = "SELECT *
FROM users,profile
WHERE user_id='$id' AND user_id=uid";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_array($result);
$name = $row['user_name'];
$email = $row['user_email'];
if($row['resume']=="")
$resume = 'dr.pdf';
else
$resume = $row['resume'];
if($row['profile_image']=="")
$profile_image = 'co.png';
else
$profile_image = $row['profile_image'];
if($row['mobile']=="")
$mobile = 'Incomplete profile';
else
$mobile = $row['mobile'];
if($row['dob']=="")
$dob = 'Incomplete profile';
else
$dob = $row['dob'];
if($row['ssc_marks']==0)
$ssc_marks = 'Incomplete profile';
else
$ssc_marks = $row['ssc_marks'];
if($row['hsc_marks']==0)
$hsc_marks = 'Incomplete profile';
else
$hsc_marks = $row['hsc_marks'];
if($row['graduation']=="")
$graduation = 'Incomplete profile';
else
$graduation = $row['graduation'];
if($row['graduation_discipline']=="")
$graduation_discipline = 'Incomplete profile';
else
$graduation_discipline = $row['graduation_discipline'];
if($row['graduation_marks']==0)
$graduation_marks = 'Incomplete profile';
else
$graduation_marks = $row['graduation_marks'];
if($row['post_graduation']=="")
$post_graduation = '-';
else
$post_graduation = $row['post_graduation'];
if($row['post_graduation_discipline']=="")
$post_graduation_discipline = '-';
else
$post_graduation_discipline =
$row['post_graduation_discipline'];
if($row['post_graduation_marks']==0)
$post_graduation_marks = '-';
else
$post_graduation_marks = $row['post_graduation_marks'];
if($row['gender']=="")
$gender = 'Incomplete profile';
else
$gender = $row['gender'];
}
?>
<div class="col-md-12 main" style="padding-top: 20px;">
<!-- login-page -->
<div class="col-md-3" >
<center>
<img src="image_uploads/<?php echo $profile_image; ?>"
width="150px" class="img-responsive" alt="profile-Image">
</center>
</div>
<div class="col-md-5">
<div class="outer">
<div class="middle">
<div class="inner">
<h1><?php echo $name; ?></h1>
<p><?php echo $email; ?></p>
<br>
<div class="col-md-6">
<h4><a href="resume_uploads/<?php echo
$resume; ?>" target="_blank"><u><i class="glyphicon glyphicon-
file"></i>View Resume</u></a></h4>
</div>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>
</div>
<div class="col-md-12 main" style="padding-top: 20px;">
<div class="col-md-1">
</div>
<div class="col-md-8"">
<h4>Personal Detail</h4>
<style>
table {
border-collapse: collapse;
width: 100%;
}
th, td {
text-align: left;
padding: 8px;
}
tr:nth-child(even){background-color: #f2f2f2}
th {
background-color: rgba(18, 149, 201, 0.69);
color: white;
}
</style>
<table border="3px" width="100%">
<tr>
<th>Name</th>
<td><?php echo $name; ?></td>
</tr>
<tr>
<th>Email</th>
<td><?php echo $email; ?></td>
</tr>
<tr>
<th>Mobile No.</th>
<td><?php echo $mobile; ?></td>
</tr>
<tr>
<th>Date Of Birth</th>
<td><?php echo $dob; ?></td>
</tr>
<tr>
<th>Gender</th>
<td><?php echo $gender; ?></td>
</tr>
</table>
<br>
<h4>Educational Detail</h4>
<table border="3px" width="100%">
<tr>
<th>SSC marks</th>
<td><?php echo $ssc_marks; ?></td>
</tr>
<tr>
<th>HSC Marks</th>
<td><?php echo $hsc_marks; ?></td>
</tr>
<tr>
<th>Graduation</th>
<td><?php echo $graduation; ?></td>
</tr>
<tr>
<th>     Graduation
Discipline</th>
<td><?php echo $graduation_discipline; ?></td>
</tr>
<tr>
<th>     In Graduation (% or
cgpa)</th>
<td><?php echo $graduation_marks; ?></td>
</tr>
<tr>
<th>Post Graduation (Optional)</th>
<td><?php echo $post_graduation; ?></td>
</tr>
<tr>
<th>     Post Graduation
Discipline</th>
<td><?php echo $post_graduation_discipline; ?></td>
</tr>
<tr>
<th>     In Post Graduation
(% or cgpa)</th>
<td><?php echo $post_graduation_marks; ?></td>
</tr>
</table>
<br><br>
</div>
<div class="clearfix"></div>
<div class="col-md-1"></div>
<div class="col-md-10">
<h4>Companies that are enrolled</h4>
<?php
$sql = "SELECT * FROM company
WHERE company_id IN
(
SELECT company_id
FROM drive
WHERE drive_id IN
(
SELECT drive_id
FROM enrolled_students
WHERE user_id='$id'
)
)";
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_assoc($result)){
$id = $row['company_id'];
$name = $row['company_name'];
$branch = $row['company_branch'];
$url = $row['company_url'];
echo '
<div class="editor-pics">
<div class="col-md-10 item-details"
style="border: #14bcd5 solid 1px; padding: 10px">
<h4 class="inner two"><a
href="view_company.php?id='.$id.'">'.$name.'</a>
</h4>
<h5> Branch:
'.$branch.'   
<a href="http://'.$url.'"
target="_blank">'.$url.'</a>
</h5>
</div>
</div><br><br>
';
}
?>
</div>
<div class="col-md-1"></div>
<div class="clearfix"></div>
</div>
</div>
<!-- //login-page -->
<div class="clearfix"> </div>
Company.html:-
<?php
if(isset($_GET['name'])&&isset($_GET['branch'])&&isset($_GET['sa
lary'])&&isset($_GET['date'])) {
//Set the Content Type
header('Content-type: image/jpeg');
}
Input-Outputs Screens and Reports:-
1.login:-
2.Registration:-
3.Company Details:-
4.student details:-
5.logout:-
Testing-
System Testing
The goal of the system testing process was to determine all faults in
our project .The program was subjected to a set of test inputs and
many explanations were made and based on these explanations it will
be decided whether the program behaves as expected or not. Our
Project went through two levels of testing.
1. Unit testing
2. Integration testing
UNIT TESTING
• Unit testing is commenced when a unit has been created and
effectively reviewed .In order to test a single module we need to
provide a complete environment i.e. besides the section we would
require.
• The procedures belonging to other units that the unit under test
calls.
• Non local data structures that module accesses.
• A procedure to call the functions of the unit under test with
appropriate parameters.
1. Test for the admin module
• Testing admin login form-This form is used for log in of
administrator of the system. In this form we enter the username
and password if both are correct administration page will open
otherwise if any of data is wrong it will get redirected back to the
login page and again ask the details.
INTEGRATION TESTING
In the Integration testing we test various combination of the project
module by providing the input.
The primary objective is to test the module interfaces in order to
confirm that no errors are occurring when one module invokes the
other module.
Advantages:-
• Placement Management System manages student
information in the college with regards to placement.
• It has the facility of maintaining the details of the student
,there by reducing the manual work.
• It gives the accurate data details of student or company to
the user.
• The system provides less time consumption.
• The user can register & upload details easily.
On-line resources –
https://www.w3resource.com
https://www.w3schools.com
http://php.net/
https://www.tutorialspoint.com
https://www.postgresql.org/
https://html.com/
https://www.javatpoint.com
Books:
1. Programming PHP By Rasmus Lerdorf and Kevin
Tatroe, O'Reilly publication
2. Beginning PHP 5 , Wrox publication
3. PHP web services, Wrox publication
4. AJAX Black Book, Kogent solution
5. Mastering PHP , BPB Publication
6. PHP cookbook, O'Reilly publication