0% found this document useful (0 votes)

64 views39 pages

College Placement System Files Overview

The document appears to be a table of contents or index for PHP files related to a college placement system. It lists over 25 PHP file names with brief descriptions. The files include ones for student login, admin login, creating jobs, applying for jobs, updating results, and more. The README at the bottom provides instructions on setting up the files and database in a local XAMPP environment.

Uploaded by

Man

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)

64 views39 pages

College Placement System Files Overview

Uploaded by

Man

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

main.php
admdash.php
adminlogin.php
AdminJobResult.php
applyjob.php
check.php
checkers.php
chngpwd.php
CreateJob.php
dispStuList.php
logout.php
NewUser.php
saveAppJob.php
savedata.php
savepwd.php
saveresult.php
saveStu.php
saveuser.php
showdata.php
studash.php
studetails.php
stulogin.php
style.css
placementdb.sql

[Link].....................................................................................................................................................2
[Link]...............................................................................................................................................4
[Link]...........................................................................................................................................6
[Link]....................................................................................................................................7
[Link]................................................................................................................................................8
[Link]....................................................................................................................................................9
[Link].............................................................................................................................................10
[Link].............................................................................................................................................12
[Link]...........................................................................................................................................13
[Link]..........................................................................................................................................15
[Link].................................................................................................................................................17
[Link].............................................................................................................................................18
[Link]........................................................................................................................................19
[Link].............................................................................................................................................20
[Link].............................................................................................................................................22
[Link]...........................................................................................................................................23
[Link]...............................................................................................................................................24
[Link].............................................................................................................................................26
[Link]............................................................................................................................................27
[Link]...............................................................................................................................................29
[Link]............................................................................................................................................31
[Link]...............................................................................................................................................33
[Link].....................................................................................................................................................34
[Link]........................................................................................................................................38

NOTE: Create the files with the names mentioned in a folder in xampp/htdocs
and run [Link]

Create data base in mySQL from [Link] file

[Link]
<html>
<head>

</head>
<body>
<link href="[Link]" rel="stylesheet" type="text/css">
<div class="container">
<div class="top-menu">
College Placement System
</div>
<div class="login-menu">
<a href="[Link]">Student Login</a>&nbsp&nbsp<a href="[Link]">Admin
Login</a>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
</div>
<?php
$con=mysqli_connect("localhost","root","","placementdb");
$qry="select * from placement_tbl where expDate>'".date("Y-m-d")."'";

$run=mysqli_query($con,$qry);
while ($rows=mysqli_fetch_array($run))
{
echo "<div class=\"jobbox\">";
echo "<h3>".$rows['JobID'].". ".$rows['JobDesc']."</h3>"." <p><font color=red> Last
Date for Applying :".$rows['ExpDate']."</font></p>" ;
echo "<b>Company:</b>".$rows['CompanyName']."<br>";
echo "<b>Location:</b>".$rows['Location']."<br>";
echo "<b>Date of Interview:</b>".$rows['InterviewDate']."<br>";
echo "<b>Stream:</b>".$rows['Stream']."&nbsp&nbsp&nbsp&nbsp&nbsp <b>Salary
Package:</b>".$rows['SalPackage']."<br>";
echo "<b>Qualification:</b>".$rows['Qualification']."&nbsp&nbsp&nbsp&nbsp&nbsp
<b>Other Requirements:</b>".$rows['OtherReq']."<br>";
echo "</div>";
}

?>
</div>
</body>
</html>
[Link]
<html>
<head>
<script src="[Link]
<script>
$(document).ready(function(){
$("#newJob").click(function(){
$("#contents").load("[Link]");
});
$("#newUser").click(function(){
$("#contents").load("[Link]");
});

$("#ChangePwd").click(function(){
$("#contents").load("[Link]");
});
$("#UpdateRes").click(function(){
$("#contents").load("[Link]");
});
});
</script>
</head>
<body>
<link href="[Link]" rel="stylesheet" type="text/css">
<div class="container">
<div class="top-menu">
College Placement System
</div>
<div class="login-menu">
<a href="[Link]"><?php session_start(); echo $_SESSION['username'];?
>&nbspLogout</a>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
</div>
<div class="clearfix">
<div class="left-menu">
<div class="listItem"><a id="newJob" href="#"> Create a New Job</a></div>
<div class="listItem"><a id="newUser" href="#"> Add a New user</a></div>
<div class="listItem"><a id="ChangePwd" href="#">Change password</div>
<div class="listItem"><a id="UpdateRes" href="#">Update Result</div>
</div>
<div class="dataform" ">
<div class="form-data" id="contents" style=" box-shadow: 10px 10px lightgrey;">

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

</body>
</html>
[Link]
<html>
<body>
<link href="[Link]" rel="stylesheet" type="text/css">
<div class="container">
<div class="top-menu">
College Placement System
</div>
<form method="post" action="[Link]">
<div class="loginblock"><center>
<font style="font-size:20px; font-weight:bold;"> Admin Login</font><br><br><br><br>
User Name:<input type="string" name="uname"><br><br>
Password:<input type="password" name="pwd"><br><br>
<input type="hidden" name="usertype" value="A">
<input type="submit" name="submit" name="submit"><br><br><br></center>
</div>
</form>
</div>
</body>
</html>
[Link]
<html>
<body>
<form method = "post" action="[Link]" >
<table align="center" border="1" width="100%">

<th colspan="2"> Update Job Result</th>

<tr>
<td><div class="labl">Job: </div></td>
<td>
<?php
$con=mysqli_connect("localhost","root","","placementdb");
$qry="select JobID, JobDesc from placement_tbl";
$run=mysqli_query($con,$qry);
echo '<select name="jid">';
while ($rows=mysqli_fetch_array($run))
{

echo "<option value=".$rows['JobID'].">".$rows['JobDesc']."</option>";

}
?>

</td>
</tr>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Students Applied" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-
shadow: 2px 2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<html>
<body>
<form method = "post" action="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Apply for a Job</th>

echo "<option value=".$rows['JobID'].">".$rows['JobDesc']."</option>";

}
?>

</td>
</tr>
<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"
value="Save Details" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow:
2px 2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<form method="get">
<?php
$conn = mysqli_connect("localhost", "root", "","placementDB");

$sql = "SELECT password from users where username='".$_POST["uname"]."'";

$un=$_POST["uname"];

$retval = mysqli_query( $conn, $sql );

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

{
if ($row['password']==$_POST["pwd"])
{
echo "login successful<br> ";
session_start();
$_SESSION['username']=$un;
if ($_POST['usertype']=="S")
header('refresh:0;url=[Link]
$un);
else
header('refresh:0;url=[Link]
$un);
}
else
{
echo "<script>alert('username or password incorrect');</script>";
if ($_POST['usertype']=="S")
header('refresh:0;url=[Link]
else
header('refresh:0;url=[Link]
}
}

mysqli_close($conn);
?>
</form>
[Link]

<table border="1" width="100%">

<tr>
<th>Job Name</th>
<th>Company Name</th>
<th> Date of Interview</th>
<th>Result</th>
</tr>
<?php
$con=mysqli_connect("localhost","root","","placementdb");

session_start();
$un=$_SESSION['username'];

$qry="select [Link] , [Link],Qualified, [Link] from JobApply_tbl s, Placement_tbl j

where [Link]=[Link] and [Link]='$un'";
//echo $qry;
$i=1;
$recset=mysqli_query($con,$qry);
while ($row=mysqli_fetch_array($recset))
{
if ($i%2==0)
{
echo "<tr bgcolor='#B7F7F2'><td>";
}
else
{
echo "<tr bgcolor='#6BF5F1'><td>";
}
$i++;
echo $row["JobDesc"];
echo "</td>";
echo "<td>";
echo $row["CompanyName"];
echo "</td>";
echo "<td>";
echo $row["InterviewDate"];
echo "</td>";
echo "<td>";
if ($row["Qualified"]==1)
echo 'Selected';
else
echo 'Not Selected';
echo "</td></tr>";
}

?>
</table>
[Link]
<html>
<body>
<form method = "post" action="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Change Password</th>

<tr>
<td><div class="labl">Old Password: </div></td>
<td><input type="password" name="oldpwd" ></td>
</tr>
<tr>
<td><div class="labl">New Password: </div></td>
<td><input type="password" name="newpwd" ></td>
</tr>
<tr>
<td><div class="labl">Confirm New Password: </div></td>
<td><input type="password" name="cnewpwd" ></td>
</tr>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Save Details" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow:
2px 2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<html>
<body>
<form method = "post" action ="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Add a New Job for Placement </th>

<tr>
<td><div class="labl">Job ID: </div></td>
<td><input type="string" name="JobID"></td>
</tr>
<tr>
<td><div class="labl">Job Description: </div></td>
<td><input type="string" name="JobDesc"></td>
</tr>
<tr>
<td><div class="labl">Company Name: </div></td>
<td><input type="string" name="Company" style="width:400px;height:50px"></td>
</tr>
<tr>
<td><div class="labl">Post Date: </div></td>
<td><input type="date" name="PostDate" value=<?php echo date('d-m-y');?>> </td>
</tr>
<tr>
<td><div class="labl">Interview Date: </div></td>
<td><input type="date" name="Interdate"> </td>
</tr>
<tr>
<td><div class="labl">Job Expiry Date: </div></td>
<td><input type="date" name="expDate" value=<?php echo date('d-m-y');?>> </td>
</tr>
<tr>
<td><div class="labl">Stream: </div></td>
<td> <select name="strm">
<option value="Comp Science">Computer Science</option>
<option value="Science">Science</option>
<option value="Commerce">Commerce</option>
<option value="Business Administration">Business Administration</option>
<option value="Arts">Arts</option>
</select>
</td></tr>
<tr>
<td><div class="labl">Qualification: </div></td>
<td><select name="Qual">
<option value="Graduation">Graduation</option>
<option value="Masters">Master</option>
<option value="Post Graduate Diploma">Post Graduate Diploma</option>
<option value="Certificate">Certificate</option>
<option value="PhD">PhD</option>
<option value="MPhil">MPhil</option>
</select>
</td></tr>
<tr>
<td><div class="labl">Other Requirements: </div></td>
<td><input type="string" name="oreq" > </td>
</tr>
<tr>
<td><div class="labl">Salary Package: </div></td>
<td><input type="string" name="salPack" width="300px"></td>
</tr>
<tr>
<td><div class="labl">Location: </div></td>
<td><input type="string" name="Loc" > </td>
</tr>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Save Job" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow: 2px
2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<html>
<body>
<form method = "post" action ="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Add a New Job for Placement </th>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Save Job" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow: 2px
2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<?php
session_start();
session_destroy();
//echo "<script>alert('Logout successful');</script>";
header('refresh:0;url=[Link]
?>
[Link]
<html>
<body>
<form method = "post" action="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Add a New User</th>

<tr>
<td><div class="labl">User Name: </div></td>
<td><input type="string" name="username" ></td>
</tr>
<tr>
<td><div class="labl">Password: </div></td>
<td><input type="password" name="password" ></td>
</tr>
<tr>
<td><div class="labl">User Type: </div></td>
<td><input type="radio" name="userType" value="admin"> Admin<input type="radio"
name="userType" value="student">Student

</td>
</tr>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Save Details" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow:
2px 2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<?php
$con=mysqli_connect("localhost","root","","placementdb");
session_start();
$sid=$_SESSION['username'];
$jid=$_POST['jid'];
$qry="insert into jobapply_tbl (StuID, JobID) values ('$sid',$jid)";

if (mysqli_query($con,$qry)==true)
{

echo "<script>alert('Data saved');</script>";

header('refresh:0;url=[Link]
}
else
{

echo "<script>alert('could not save data');</script>";

header('refresh:0;url=[Link]
}

?>
[Link]
<?php
if(isset($_POST['submit']))
{

$con=mysqli_connect("localhost","root","","placementdb");

if ( !empty($_POST["JobDesc"]) and !empty($_POST["Company"]) and !empty($_POST["PostDate"])

and !empty( $_POST["Interdate"]) and !empty($_POST["strm"]) and !empty($_POST["Qual"])
and !empty($_POST["oreq"])
and !empty($_POST["salPack"]) and !empty($_POST["Loc"]) )
{
session_start();
$un=$_SESSION['username'];
$jd=$_POST["JobDesc"];
$cmp=$_POST["Company"];
$pd=$_POST["PostDate"];
$idt=$_POST["Interdate"];
$exdt=$_POST["expDate"];
$strm=$_POST["strm"];
$Qual=$_POST["Qual"];
$oreq=$_POST["oreq"];
$SalPack=$_POST["salPack"];
$Loc=$_POST["Loc"];

$qry="select max(JobID) as maxid from placement_tbl";

$run=mysqli_query($con,$qry);
while ($rows=mysqli_fetch_array($run))
{
$jid=$rows[0];
}

$qry="insert into placement_tbl values

($jid+1,'$jd','$cmp','$pd','$idt','$exdt','$strm','$Qual','$oreq','$SalPack','$Loc')";

if (mysqli_query($con,$qry)==true)
{
//echo $qry;
echo "<script>alert('Data saved');</script>";
header('refresh:0;url=[Link]
uname='.$un);
}
else
{
//echo $qry;
echo "<script>alert('could not save data');</script>";
header('refresh:0;url=[Link]
$un);
}
}
else
{
echo "<script>alert('fields cannot be left empty');</script>";
header('refresh:0;url=[Link]
}
}
?>
[Link]
<?php
$con=mysqli_connect("localhost","root","","placementdb");
session_start();
$sid=$_SESSION['username'];
$opwd=$_POST['oldpwd'];
$npwd=$_POST['newpwd'];
$cnpwd=$_POST['cnewpwd'];
if ($npwd!=$cnpwd)
{
echo "<script>alert('password do not match');</script>";
header('refresh:0;url=[Link]
}
else
{
$qry="update users set password='$npwd' where username='$sid'" ;

if (mysqli_query($con,$qry)==true)
{

echo "<script>alert('password updated');</script>";

header('refresh:0;url=[Link]
}
else
{
echo $qry;
echo "<script>alert('could not update password');</script>";
header('refresh:0;url=[Link]
}
}

?>
[Link]
<?php
if(isset($_POST['submit']))
{

$con=mysqli_connect("localhost","root","","placementdb");

session_start();
$un=$_SESSION['username'];
$jid=$_POST["jobid"];
$res=$_POST["result"];

foreach ($res as $r )
{
$qry="update jobapply_tbl set qualified=1 where JobID='$jid' and StuID='$r'";
$a=mysqli_query($con,$qry);
}

if ($a==true)
{
//echo $qry;
echo "<script>alert('Data saved');</script>";
header('refresh:0;url=[Link]
uname='.$un);
}
else
{
//echo $qry;
echo "<script>alert('could not save data');</script>";
header('refresh:0;url=[Link]
$un);
}
}

?>
[Link]
<?php
if(isset($_POST['submit']))
{

$con=mysqli_connect("localhost","root","","placementdb");

if (!empty( $_POST["rollno"]) and !empty($_POST["stuname"]))

{
$rno=(integer)$_POST["rollno"];
$snam=$_POST["stuname"];
$fnam=$_POST["fname"];
$dob=$_POST["dob"];
$ph=$_POST["contno"];
$email=$_POST["email"];
$strm=$_POST["strm"];
$cors=$_POST["course"];
$scor=(float)$_POST["score"];
$areaInt=$_POST["AreaInt"];
session_start();
$un=$_SESSION['username'];

$qry="insert into stureg_tbl values ('$un',$rno,'$snam','$fnam','$dob','$ph','$email','$strm','$cors',

$scor,'$areaInt')";

if (mysqli_query($con,$qry)==true)
{

echo "<script>alert('Data saved');</script>";

header('refresh:0;url=[Link]
}
else
{

echo "<script>alert('could not save data');</script>";

header('refresh:0;url=[Link]
$un);
}
}
else
{
echo "<script>alert('fields cannot be left empty');</script>";
header('refresh:0;url=[Link]
$un);
}
}
?>
[Link]
<?php
$con=mysqli_connect("localhost","root","","placementdb");
session_start();
$un=$_POST['username'];
$pwd=$_POST['password'];
$utype=$_POST['userType'];

$qry="Insert into users (username,password,usertype) values ('$un','$pwd','$utype')" ;

if (mysqli_query($con,$qry)==true)
{

echo "<script>alert('New User Created');</script>";

header('refresh:0;url=[Link]
}
else
{
echo "<script>alert('could not update password');</script>";
header('refresh:0;url=[Link]
}

?>
[Link]
<form method = "post" action ="[Link]" >
<table border="1">
<tr>
<th>User name</th>
<th>Student ID</th>
<th>student Name</th>
<th>Result</th>
</tr>
<?php
$con=mysqli_connect("localhost","root","","placementdb");
if(isset($_POST['submit']))
{
$jid=$_POST['jid'];

$qry="select [Link], [Link],StuName from stureg_tbl s, jobapply_tbl j where [Link]=[Link]

and [Link]='$jid'";
//echo $qry;
$i=1;
$recset=mysqli_query($con,$qry);
while ($row=mysqli_fetch_array($recset))
{
if ($i%2==0)
{
echo "<tr bgcolor='#ffccff'><td>";
}
else
{
echo "<tr bgcolor='#ff99ff'><td>";
}
$i++;
echo $row["userName"];
echo "</td>";
echo "<td>";
echo $row["StuID"];
echo "</td>";
echo "<td>";
echo $row["StuName"];
echo "</td>";
echo "<td>";
$key=$row["userName"];
echo '<input type="checkbox" name="result[]" value="'.$key.'"';
echo "</td></tr>";
}
}
echo '<input type="hidden" name="jobid" value="'.$jid.'">';
?>
<th colspan="4" style="background-color:#0055CC;" > <input type = "submit" name = "submit"
value="Save result" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow:
2px 2px 4px orange;" > </th>
</table>
</form>
[Link]
<html>
<head>
<script src="[Link]
<script>
$(document).ready(function(){

$("#stuDetails").click(function(){
$("#contents").load("[Link]");
});

$("#ApplyJob").click(function(){
$("#contents").load("[Link]");
});
$("#CheckRes").click(function(){
$("#contents").load("[Link]");
});

$("#ChangePwd").click(function(){
$("#contents").load("[Link]");
});
});
</script>
</head>
<body>
<link href="[Link]" rel="stylesheet" type="text/css">
<div class="container">
<div class="top-menu">
College Placement System
</div>
<div class="login-menu">
<?php
session_start();
$un=$_SESSION["username"];
echo '<a href="[Link]">'.$un.'&nbspLogout</a>&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp';
?>

</div>
<div class="clearfix">
<div class="left-menu">
<div class="listItem"><a id="stuDetails" href="#">Enter Your Details</a></div>
<div class="listItem"><a id="ApplyJob" href="#">Apply for a Job</a></div>
<div class="listItem"><a id="CheckRes" href="#">Check Interview Result</a></div>
<div class="listItem"><a id="ChangePwd" href="#">Change password</a></div>
</div>

<div class="dataform" ">

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

</body>
</html>
[Link]
<html>
<body>
<form method = "post" action="[Link]">
<table align="center" border="1" width="70%">

<th colspan="2"> Add Your Details </th>

<tr>
<td><div class="labl">StudentID/Roll No: </div></td>
<td><input type="string" name="rollno"></td>
</tr>
<tr>
<td><div class="labl">Name: </div></td>
<td><input type="string" name="stuname"></td>
</tr>
<tr>
<td><div class="labl">Father's Name: </div></td>
<td><input type="string" name="fname" ></td>
</tr>
<tr>
<td><div class="labl">Date of Birth: </div></td>
<td><input type="date" name="dob" value=<?php echo date('Y-m-d H:i:s');?></td>
</tr>
<tr>
<td><div class="labl">Contact Number: </div></td>
<td><input type="string" name="contno" ></td>
</tr>
<tr>
<td><div class="labl">Email ID: </div></td>
<td><input type="string" name="email" ></td>
</tr>
<tr>
<td><div class="labl">Stream: </div></td>
<td> <select name="strm">
<option value="Comp Science">Computer Science</option>
<option value="Science">Science</option>
<option value="Commerce">Commerce</option>
<option value="Business Administration">Business Administration</option>
<option value="Arts">Arts</option>
</select>
</td></tr>
<tr>
<td><div class="labl">Course: </div></td>
<td><select name="course">
<option value="BCA">BCA</option>
<option value="[Link].">[Link].</option>
<option value="PGDCA">PGDCA</option>
<option value="PGDMC">PGDMC</option>
<option value="BBA">BBA</option>
<option value="BCOM">BCOM</option>
<option value="BA">BA</option>
<option value="MCOM">MCOM</option>
<option value="[Link].">[Link].</option>
</select>
</td></tr>

<td><div class="labl">last Score in %age: </div></td>

<td><input type="float" name="score"> </td>
</tr>
<tr>
<td><div class="labl">Area of Interest: </div></td>
<td><input type="string" name="AreaInt" > </td>
</tr>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

value="Save Details" style="font-size:16px;font-weight:bold; padding:5px;color: #0055CC; text-shadow:
2px 2px 4px orange;" > </th>
</table>

</form>
</body>
</html>
[Link]
<html>
<link href="[Link]" rel="stylesheet" type="text/css">
<body>
<form method="post" action="[Link]">
<div class="container">
<div class="top-menu">
College Placement System
</div>
<div class="loginblock"><center>
<font style="font-size:20px; font-weight:bold;"> Student Login</font><br><br><br><br>
User Name:<input type="string" name="uname"><br><br>
Password:<input type="password" name="pwd"><br><br>
<input type="hidden" name="usertype" value="S">
<input type="submit" name="submit" name="submit"><br><br><br></center>
</div>
</div>
</form>
</body>
</html>
[Link]
.container
{
background-color: #ffffff;
width:100%;
height:100%;
}
.clearfix::after {
content: "";
clear: both;
display: table;
}
.left-menu
{
width:15%;
height:90%;
background-color: #99BBBB;
padding-top:10px;
padding-left:10px;
padding-right:0px;
float: left;
border: 2px solid #005544;
}
.top-menu
{
width:100%;
height:5%;
background-color: #FF6622;
float:top;
text-align:center;
font-family:verdana;
font-size:24;
text-transform:float;
font-weight: bold;
padding-top:10px;
text-shadow: 1px 1px #dddddd;
}
.listItem
{
font-family:verdana;
font-size:14;
text-transform:float;
font-weight: bold;
padding-top:10px;
padding-bottom:10px;
background-color:#99BBCC;
border-bottom: 4px solid #0055CC;
}

.dataform
{
width:80%;
height:90%;
font-family:verdana;
font-size:12;
padding-top:10px;
padding-bottom:10px;
padding-left:5px;
background-color:#ffffff;
border: 2px solid #005544;
float: right;
}
.form-data
{
width:90%;
height:80%;
border: 2px solid #ffffff;
background-color: #99dddd;
padding-top:10px;
padding-bottom:10px;
padding-left:5px;
margin-top: 50px;
margin-bottom: 50px;
margin-right: 50px;
margin-left: 50px;
}

.labl
{
font-family:verdana;
font-size:14;
font-weight: bold;
}
table
{
margin-top: 50px;
border-color:#99aaaa;
border-collapse: collapse;
}
tr{
height: 50px;
}
th
{
text-align:center;
padding: 10px;
background-color:#ddddee;
}
td {
text-align: left;
}
.jobbox
{
width:60%;
height:200px;
border: 2px solid ;
background-color: #ffffff;
padding-top:5px;
padding-bottom:5px;
padding-left:5px;
margin-top: 20px;
margin-bottom: 20px;
border-color:#99aaaa;
border-collapse: collapse;
margin-left: 20%;
border-style: ridge;
border-width: 2px 10px 4px 20px;
}
.login-menu
{
width:100%;
height:2%;
background-color: #1111cc;
float:top;
text-align:right;
font-family:verdana;
font-size:12;
padding-top:10px;
padding-bottom:10px;

color: #FFffff;
}
a:link {
color: white;
}

/* visited link */
a:visited {
color: white;
}

/* mouse over link */

a:hover {
color: yellow;
}

.loginblock
{
width:20%;
height:200px;
border: 2px solid ;
background-color: #ffffff;
padding:30px 30px 30px 30px;
margin-top: 10%;
border-color:#33aaaa;
border-collapse: collapse;
margin-left: 35%;
border-style: ridge;
border-width: 2px 10px 4px 20px;
text-align:center;
font-family:verdana;
font-size:16px;
}
[Link]
-- phpMyAdmin SQL Dump
-- version [Link]
-- [Link]
--
-- Host: [Link]
-- Generation Time: Aug 28, 2019 at 06:35 PM
-- Server version: 10.1.32-MariaDB
-- PHP Version: 7.2.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `placementdb`
--

-- --------------------------------------------------------

--
-- Table structure for table `jobapply_tbl`
--

CREATE TABLE `jobapply_tbl` (

`StuID` varchar(40) NOT NULL,
`JobID` int(11) NOT NULL,
`Qualified` int(11) NOT NULL,
`Remarks` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------
--
-- Table structure for table `placement_tbl`
--

CREATE TABLE `placement_tbl` (

`JobID` int(11) NOT NULL,
`JobDesc` varchar(300) NOT NULL,
`CompanyName` varchar(300) NOT NULL,
`PostDate` date NOT NULL,
ÌnterviewDate` date NOT NULL,
ÈxpDate` date NOT NULL,
`Stream` varchar(20) NOT NULL,
`Qualification` varchar(25) NOT NULL,
ÒtherReq` varchar(300) NOT NULL,
`SalPackage` varchar(20) NOT NULL,
`Location` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `stureg_tbl`
--

CREATE TABLE `stureg_tbl` (

`userName` varchar(40) NOT NULL,
`StuID` int(11) NOT NULL,
`StuName` varchar(50) NOT NULL,
`StuFName` varchar(50) NOT NULL,
`StuDOB` date NOT NULL,
`ContactNo` varchar(15) NOT NULL,
`StuEmail` varchar(50) NOT NULL,
`Stream` varchar(40) NOT NULL,
`Course` varchar(10) NOT NULL,
`LastScore` float NOT NULL,
`AreaOfInterest` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (

`username` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`usertype` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
COMMIT;

/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Contents
main.php............................................................................................................

main.php
<html>
<head>
</head>
<body>
<link href="style.css" rel="stylesheet" type="text/css">
<div class="container">
<div c

admdash.php
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script>
$

<div class="dataform" ">
<div class="form-data" id="contents" style=" box-shadow: 10px 10px lightgrey;">
</div>
</div>
</div>

adminlogin.php
<html>
<body>
<link href="style.css" rel="stylesheet" type="text/css">
<div class="container">
<div class="top

AdmnJobResult.php
<html>
<body>
<form method = "post" action="dispStuList.php" >
<table align="center" border="1" width

applyjob.php
<html>
<body>
<form method = "post" action="saveAppJob.php">
<table align="center" border="1" width="70%"

check.php
<form method="get">
<?php
$conn = mysqli_connect("localhost", "root", "","placementDB");
$sql = "SELECT password fr

checkers.php
<table border="1" width="100%">
<tr>
<th>Job Name</th>
<th>Company Name</th>
<th> Date of Interview</th>
<th>Res

if ($row["Qualified"]==1)
echo 'Selected';
else
echo 'Not Selected';
echo "</td></tr>";
}

?>
</table>

1fichier.com Cloud Storage Services
No ratings yet
1fichier.com Cloud Storage Services
5 pages
Advanced Penetration Testing Course
No ratings yet
Advanced Penetration Testing Course
10 pages
XAMPP MySQL Backup and Restore Guide
No ratings yet
XAMPP MySQL Backup and Restore Guide
8 pages
FlashcatUSB User's Guide Overview
No ratings yet
FlashcatUSB User's Guide Overview
39 pages
PHP MySQL Integration Guide
No ratings yet
PHP MySQL Integration Guide
44 pages
PHP User Authentication Tutorial
No ratings yet
PHP User Authentication Tutorial
68 pages
Download Management Interface
No ratings yet
Download Management Interface
3 pages
Build Web Apps with Bootstrap & AngularJS
No ratings yet
Build Web Apps with Bootstrap & AngularJS
17 pages
Regex Replace System
No ratings yet
Regex Replace System
86 pages
Digital HUMINT and Email Reputation Tools
No ratings yet
Digital HUMINT and Email Reputation Tools
6 pages
Notepad Pranks to Fool Friends
No ratings yet
Notepad Pranks to Fool Friends
12 pages
PHP 7
No ratings yet
PHP 7
11 pages
MySQL PDO Scripting with PHP Guide
No ratings yet
MySQL PDO Scripting with PHP Guide
11 pages
Simple PHP Guestbook Tutorial
No ratings yet
Simple PHP Guestbook Tutorial
9 pages
HTML Book
No ratings yet
HTML Book
199 pages
Resource Links for Document Access
No ratings yet
Resource Links for Document Access
2 pages
PHP Native Login Project Structure
No ratings yet
PHP Native Login Project Structure
10 pages
Price Match Policy Overview
No ratings yet
Price Match Policy Overview
78 pages
Top 50 Telegram Bots for Various Uses
No ratings yet
Top 50 Telegram Bots for Various Uses
2 pages
Acquia Drupal Developer Certification Guide
No ratings yet
Acquia Drupal Developer Certification Guide
4 pages
JavaScript Code Volume 1 by Christopher Topalian - 2nd Edition
No ratings yet
JavaScript Code Volume 1 by Christopher Topalian - 2nd Edition
600 pages
Notepad++ Shortcut Keys Guide
No ratings yet
Notepad++ Shortcut Keys Guide
1 page
Web Development Tools: Information & Communication Technology - 2006
No ratings yet
Web Development Tools: Information & Communication Technology - 2006
52 pages
My PHP Generator
100% (1)
My PHP Generator
284 pages
Advantages and Features of MySQL
No ratings yet
Advantages and Features of MySQL
9 pages
PHP File Upload Tutorial and Example
No ratings yet
PHP File Upload Tutorial and Example
4 pages
JavaScript Snake Game Setup Guide
No ratings yet
JavaScript Snake Game Setup Guide
5 pages
Altcademy Web Development Syllabus
No ratings yet
Altcademy Web Development Syllabus
46 pages
PhpWord Features and Usage Guide
No ratings yet
PhpWord Features and Usage Guide
49 pages
PHP Image Gallery App Source Code
No ratings yet
PHP Image Gallery App Source Code
17 pages
PHP PDO Database Connection Guide
No ratings yet
PHP PDO Database Connection Guide
22 pages
PHP Compatibility for WordPress 2023
No ratings yet
PHP Compatibility for WordPress 2023
19 pages
Citra Camera Image Formation Basics
No ratings yet
Citra Camera Image Formation Basics
28 pages
Bootstrap 5: Responsive Web Design Guide
No ratings yet
Bootstrap 5: Responsive Web Design Guide
28 pages
60 Laravel Quick Tips for Developers
No ratings yet
60 Laravel Quick Tips for Developers
24 pages
Drupal 8 User Guide
No ratings yet
Drupal 8 User Guide
224 pages
Drush Command Reference Guide
No ratings yet
Drush Command Reference Guide
2 pages
Understanding PHP PDO Basics
No ratings yet
Understanding PHP PDO Basics
13 pages
Learn PHP: A Beginner's Guide
No ratings yet
Learn PHP: A Beginner's Guide
66 pages
Image Upload with JSP and Servlet
50% (2)
Image Upload with JSP and Servlet
4 pages
HTML and CSS Practice Exercises Guide
No ratings yet
HTML and CSS Practice Exercises Guide
2 pages
Premiere Pro & After Effects Courses
No ratings yet
Premiere Pro & After Effects Courses
3 pages
Sqlite PHP: Installation
No ratings yet
Sqlite PHP: Installation
8 pages
The Twig Book: Generated On December 9, 2014
No ratings yet
The Twig Book: Generated On December 9, 2014
168 pages
Drupal 6 Translation Cheat Sheet
No ratings yet
Drupal 6 Translation Cheat Sheet
1 page
Installing Joomla on Windows XP
100% (22)
Installing Joomla on Windows XP
100 pages
Free Java Programming Courses on Udemy
No ratings yet
Free Java Programming Courses on Udemy
10 pages
Google Chrome Basics & Shortcuts Guide
No ratings yet
Google Chrome Basics & Shortcuts Guide
2 pages
JavaScript Basics: Functions, Objects, and More
No ratings yet
JavaScript Basics: Functions, Objects, and More
20 pages
Campus Recruitment Admin Dashboard
No ratings yet
Campus Recruitment Admin Dashboard
42 pages
Job Application Tracker Setup Guide
No ratings yet
Job Application Tracker Setup Guide
11 pages
Latest Job Listings and Details
No ratings yet
Latest Job Listings and Details
17 pages
CRUD Operations for Employee Management
No ratings yet
CRUD Operations for Employee Management
21 pages
Easy Made PHP - (Tobe Used)
No ratings yet
Easy Made PHP - (Tobe Used)
18 pages
Server and Database Interaction Programs
No ratings yet
Server and Database Interaction Programs
24 pages
PHP Database Management Practices
No ratings yet
PHP Database Management Practices
13 pages
Academic Staff Promotion System
No ratings yet
Academic Staff Promotion System
69 pages
PHP MySQL CRUD Operations Guide
No ratings yet
PHP MySQL CRUD Operations Guide
36 pages
PHP Student Database Management
No ratings yet
PHP Student Database Management
11 pages
Boeing's Competitive Strategies Analysis
100% (1)
Boeing's Competitive Strategies Analysis
11 pages
Bulk SMS Service Business Proposal
33% (3)
Bulk SMS Service Business Proposal
9 pages
Equipment Maintenance Checklist Guide
100% (1)
Equipment Maintenance Checklist Guide
3 pages
Grayson v Little: Architect's Duty of Care
No ratings yet
Grayson v Little: Architect's Duty of Care
15 pages
Maharashtra MIDC Water Supply Pipeline Tender
No ratings yet
Maharashtra MIDC Water Supply Pipeline Tender
101 pages
Understanding Translation Exposure Methods
No ratings yet
Understanding Translation Exposure Methods
31 pages
Financial Accounting Overview FA/F3
No ratings yet
Financial Accounting Overview FA/F3
95 pages
Overview of FACT Operations and Structure
No ratings yet
Overview of FACT Operations and Structure
12 pages
Strategic Management for Global Competition
100% (3)
Strategic Management for Global Competition
6 pages
Affidavit of Undertaking for Construction
67% (3)
Affidavit of Undertaking for Construction
3 pages
Technology's Impact on Laziness
No ratings yet
Technology's Impact on Laziness
3 pages
Portfolio Analysis and Investment Returns
No ratings yet
Portfolio Analysis and Investment Returns
13 pages
Integrating Performance and Risk Management
No ratings yet
Integrating Performance and Risk Management
3 pages
Handling Open Data Extraction Errors
No ratings yet
Handling Open Data Extraction Errors
4 pages
Management Education and HRM Overview
No ratings yet
Management Education and HRM Overview
80 pages
UK Non-Alcoholic Beer Drinkers Insights
No ratings yet
UK Non-Alcoholic Beer Drinkers Insights
30 pages
Monreal Masbate LGU Cashbook Report
No ratings yet
Monreal Masbate LGU Cashbook Report
6 pages
Commodum Groceries Invoice Details
No ratings yet
Commodum Groceries Invoice Details
2 pages
Process Safety Incidents Overview
No ratings yet
Process Safety Incidents Overview
1 page
Managing Organizational Change: 3rd Edition
No ratings yet
Managing Organizational Change: 3rd Edition
10 pages
Internet Business Model Selection Guide
No ratings yet
Internet Business Model Selection Guide
3 pages
SAP HANA Administration and Monitoring PDF
100% (2)
SAP HANA Administration and Monitoring PDF
100 pages
EBSCO-FullText-02 08 2026
No ratings yet
EBSCO-FullText-02 08 2026
16 pages
Goal Programming Techniques Explained
No ratings yet
Goal Programming Techniques Explained
31 pages
Tax Invoice for Faizan - July 2025
No ratings yet
Tax Invoice for Faizan - July 2025
3 pages
Management Trainee - Marketing & Sales
No ratings yet
Management Trainee - Marketing & Sales
2 pages
Acc Report Atr 72-500 PDF
100% (1)
Acc Report Atr 72-500 PDF
15 pages
Microsoft 2015 Attention Span Study
No ratings yet
Microsoft 2015 Attention Span Study
52 pages
Bull Trun Technical Analysis Scanner
No ratings yet
Bull Trun Technical Analysis Scanner
2 pages
Meat Refrigeration and Quality Insights
100% (8)
Meat Refrigeration and Quality Insights
16 pages

College Placement System Files Overview

Uploaded by

College Placement System Files Overview

Uploaded by

Contents

Create data base in mySQL from [Link] file

<th colspan="2"> Update Job Result</th>

echo "<option value=".$rows['JobID'].">".$rows['JobDesc']."</option>";

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

<th colspan="2"> Apply for a Job</th>

echo "<option value=".$rows['JobID'].">".$rows['JobDesc']."</option>";

$sql = "SELECT password from users where username='".$_POST["uname"]."'";

$retval = mysqli_query( $conn, $sql );

while($row = mysqli_fetch_array($retval, MYSQLI_ASSOC))

<table border="1" width="100%">

$qry="select [Link] , [Link],Qualified, [Link] from JobApply_tbl s, Placement_tbl j

<th colspan="2"> Change Password</th>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

<th colspan="2"> Add a New Job for Placement </th>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

<th colspan="2"> Add a New Job for Placement </th>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

<th colspan="2"> Add a New User</th>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

echo "<script>alert('Data saved');</script>";

echo "<script>alert('could not save data');</script>";

if ( !empty($_POST["JobDesc"]) and !empty($_POST["Company"]) and !empty($_POST["PostDate"])

$qry="select max(JobID) as maxid from placement_tbl";

$qry="insert into placement_tbl values

echo "<script>alert('password updated');</script>";

if (!empty( $_POST["rollno"]) and !empty($_POST["stuname"]))

$qry="insert into stureg_tbl values ('$un',$rno,'$snam','$fnam','$dob','$ph','$email','$strm','$cors',

echo "<script>alert('Data saved');</script>";

echo "<script>alert('could not save data');</script>";

$qry="Insert into users (username,password,usertype) values ('$un','$pwd','$utype')" ;

echo "<script>alert('New User Created');</script>";

$qry="select [Link], [Link],StuName from stureg_tbl s, jobapply_tbl j where [Link]=[Link]

<div class="dataform" ">

<th colspan="2"> Add Your Details </th>

<td><div class="labl">last Score in %age: </div></td>

<th colspan="2" style="background-color:#0055CC;" > <input type = "submit" name = "submit"

/* mouse over link */

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

CREATE TABLE `jobapply_tbl` (

CREATE TABLE `placement_tbl` (

CREATE TABLE `stureg_tbl` (

CREATE TABLE `users` (

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

You might also like

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;

/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;