Gecko [ rampurhatcollege.ac.in ]

Name	Size	Permission
biodata	[ DIR ]	drwxrwxrwx
ckeditor	[ DIR ]	drwxrwxrwx
coaching_news	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxrwxrwx
fonts	[ DIR ]	drwxrwxrwx
gallery	[ DIR ]	drwxrwxrwx
images	[ DIR ]	drwxrwxrwx
magazine	[ DIR ]	drwxrwxrwx
message	[ DIR ]	drwxrwxrwx
news	[ DIR ]	drwxrwxrwx
notice	[ DIR ]	drwxrwxrwx
old_site	[ DIR ]	drwxrwxrwx
profile	[ DIR ]	drwxrwxrwx
recruit_news	[ DIR ]	drwxrwxrwx
script	[ DIR ]	drwxrwxrwx
tech_news	[ DIR ]	drwxrwxrwx
tech_slide	[ DIR ]	drwxrwxrwx
workshop	[ DIR ]	drwxrwxrwx
.htaccess	245 B	-rw-rw-rw-
.mad-root	0 B	-rw-rw-rw-
.user.ini	254 B	-rw-rw-rw-
academic_calendar.php	2.12 KB	-rw-rw-rw-
addon_course.php	2.6 KB	-rw-rw-rw-
admin_login.php	3.97 KB	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
alumni_association.php	2.11 KB	-rw-rw-rw-
anti_ragging_cell.php	2.2 KB	-rw-rw-rw-
aqar.php	2.03 KB	-rw-rw-rw-
auditorium.php	2.17 KB	-rw-rw-rw-
cancel_coachingntc.php	331 B	-rw-rw-rw-
cancel_news.php	331 B	-rw-rw-rw-
cancel_notice.php	325 B	-rw-rw-rw-
cancel_recruitntc.php	330 B	-rw-rw-rw-
cancel_technews.php	335 B	-rw-rw-rw-
canteen.php	2.15 KB	-rw-rw-rw-
ckupload.php	1.54 KB	-rw-rw-rw-
class_routine.php	2.12 KB	-rw-rw-rw-
coaching_counseling_notice.php	1.71 KB	-rw-rw-rw-
common_room.php	2.17 KB	-rw-rw-rw-
config.php	1.47 KB	-rw-rw-rw-
contact_us.php	2.05 KB	-rw-rw-rw-
course_outcome.php	2.13 KB	-rw-rw-rw-
cultural_activities.php	2.12 KB	-rw-rw-rw-
delete_gallery.php	313 B	-rw-rw-rw-
delete_gb.php	342 B	-rw-rw-rw-
delete_profile.php	325 B	-rw-rw-rw-
delete_slide.php	556 B	-rw-rw-rw-
delete_staff.php	335 B	-rw-rw-rw-
delete_tech_slide.php	319 B	-rw-rw-rw-
department.php	4.23 KB	-rw-rw-rw-
dept_content.php	4.3 KB	-rw-rw-rw-
dept_profile.php	35.61 KB	-rw-rw-rw-
e_module.php	2.08 KB	-rw-rw-rw-
educational_tour.php	2.15 KB	-rw-rw-rw-
equal_opportunity_cell.php	2.21 KB	-rw-rw-rw-
fetch_user.php	416 B	-rw-rw-rw-
footer.php	4.14 KB	-rw-rw-rw-
generator.php	2.16 KB	-rw-rw-rw-
get_gb.php	449 B	-rw-rw-rw-
get_profile.php	863 B	-rw-rw-rw-
get_slide.php	448 B	-rw-rw-rw-
get_staff.php	536 B	-rw-rw-rw-
google8de2cdcb81ec195c.html	53 B	-rw-rw-rw-
governing_body.php	1.34 KB	-rw-rw-rw-
grievance_redressal_cell.php	2.21 KB	-rw-rw-rw-
header.php	16.1 KB	-rw-rw-rw-
history_of_the_college.php	2.13 KB	-rw-rw-rw-
home.php	16.75 KB	-rw-rw-rw-
index.php	34.41 KB	-rw-rw-rw-
international_seminar_geograph...	3.69 KB	-rw-rw-rw-
internet_wifi.php	2.17 KB	-rw-rw-rw-
iqac.php	2.06 KB	-rw-rw-rw-
library_at_a_glance.php	2.12 KB	-rw-rw-rw-
library_staff.php	2.12 KB	-rw-rw-rw-
logout.php	101 B	-rw-rw-rw-
magazine_geography.php	976 B	-rw-rw-rw-
manage_gallery.php	18.5 KB	-rw-rw-rw-
manage_gb.php	21.03 KB	-rw-rw-rw-
manage_slide.php	21.72 KB	-rw-rw-rw-
manage_tech_slide.php	18.51 KB	-rw-rw-rw-
manage_user.php	23.71 KB	-rw-rw-rw-
mission_vision_objectives.php	2.18 KB	-rw-rw-rw-
nad_digilocker.php	2.02 KB	-rw-rw-rw-
nirf.php	2.01 KB	-rw-rw-rw-
non_teaching_staff.php	1.37 KB	-rw-rw-rw-
notice_board.php	6.17 KB	-rw-rw-rw-
nss.php	2.06 KB	-rw-rw-rw-
online_admission_notice_info_2...	2.19 KB	-rw-rw-rw-
organization.php	2.12 KB	-rw-rw-rw-
pg_course.php	2.07 KB	-rw-rw-rw-
photo_gallery.php	5.44 KB	-rw-rw-rw-
play_ground.php	2.15 KB	-rw-rw-rw-
principal_desk.php	2.14 KB	-rw-rw-rw-
prospectus.php	2.1 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-
recruitment_notice.php	1.57 KB	-rw-rw-rw-
regional_science_tech_congress...	5.66 KB	-rw-rw-rw-
rti.php	1.84 KB	-rw-rw-rw-
safe_drinking_water.php	2.19 KB	-rw-rw-rw-
safety_first_aid.php	2.22 KB	-rw-rw-rw-
scholarship_stipend.php	2.2 KB	-rw-rw-rw-
sports_games.php	2.13 KB	-rw-rw-rw-
ssr.php	2 KB	-rw-rw-rw-
staff_profile.php	29.89 KB	-rw-rw-rw-
structural_modeling_amos.php	1.59 KB	-rw-rw-rw-
student_union.php	2.13 KB	-rw-rw-rw-
students_fair.php	2.11 KB	-rw-rw-rw-
study_center.php	2.06 KB	-rw-rw-rw-
sub_committees.php	2.15 KB	-rw-rw-rw-
ug_course.php	2.09 KB	-rw-rw-rw-
upload_coaching_counseling_not...	20.14 KB	-rw-rw-rw-
upload_news.php	20.39 KB	-rw-rw-rw-
upload_notice.php	21.09 KB	-rw-rw-rw-
upload_recruitment_notice.php	20.08 KB	-rw-rw-rw-
upload_science_tech_notice.php	20.11 KB	-rw-rw-rw-
vishaka_cell.php	2.18 KB	-rw-rw-rw-
web.config	233 B	-rw-rw-rw-
welcome22222.html	4.83 KB	-rw-rw-rw-

Code Editor : staff_profile.php

<?php
session_start();
if (!isset($_SESSION['RPHC']) && empty($_SESSION['RPHC'])) {
	header("location: admin_login.php");
	exit();
}
require_once "config.php";
?>
<!DOCTYPE html>
<html lang="en">

<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	<meta http-equiv="x-ua-compatible" content="ie=edge">
	<title>Manage Non Teaching Staff : Rampurhat College</title>
	<meta name="keywords" content="" />
	<meta name="description" content="" />
	
	<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />
	<link href="css/font-awesome.css" rel="stylesheet" type="text/css" />
	<link href="css/mdb.min.css" rel="stylesheet" type="text/css" />
	<link href="css/bootnavbar.css" rel="stylesheet" type="text/css" />
	<link href="css/classic.css" rel="stylesheet" type="text/css" />
	<link href="css/classic.date.css" rel="stylesheet" type="text/css" />
	<link href="https://cdn.datatables.net/1.11.4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
	<link href="css/styles.css" rel="stylesheet" type="text/css" />
	<style type="text/css">
		.modal-dialog {
			margin-top: 2.5% !important;
		}
	</style>
</head>

</div>
		</div>
		<div class="row">
			<div class="col-sm-12 m-0">
				<nav class="navbar navbar-expand-lg navbar-default navbar-dark">
					
					<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#basicExampleNav" aria-controls="basicExampleNav" aria-expanded="false" aria-label="Toggle navigation">
						<span class="navbar-toggler-icon"></span>
					</button>
					
					<div class="collapse navbar-collapse" id="basicExampleNav">
						
						<ul class="navbar-nav m-auto">
							<li class="nav-item">
								<a class="nav-link" href="home.php">Home
									<span class="sr-only">(current)</span>
								</a>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Admin</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
									<li><a class="dropdown-item" href="./manage_user.php">Manage Users</a></li>
									<li><a class="dropdown-item" href="./dept_profile.php">Add Dept. Profile</a></li>
									<li><a class="dropdown-item" href="./staff_profile.php">Add Non-Teaching Staff</a></li>
									<li><a class="dropdown-item" href="./manage_gb.php">Manage Governing Body</a></li>
									<li><a class="dropdown-item" href="./upload_notice.php">Manage Notice/Tender</a></li>
									<li><a class="dropdown-item" href="./upload_news.php">Manage Latest News</a></li>
									<li><a class="dropdown-item" href="./manage_slide.php">Manage Front Slides</a></li>
									<li><a class="dropdown-item" href="./manage_gallery.php">Manage Photo Gallery</a></li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">About Us</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
									<li><a class="dropdown-item" href="./history_of_the_college.php">History of the College</a></li>
									<li><a class="dropdown-item" href="./mission_vision_objectives.php">Mission, Vision &amp; Objectives</a></li>
									<li><a class="dropdown-item" href="./organization.php">Organization</a></li>
									<li><a class="dropdown-item" href="./governing_body.php">Governing Body</a></li>
									<li><a class="dropdown-item" href="./sub_committees.php">Sub-Committees &amp; Cells</a></li>
									<li><a class="dropdown-item" href="./iqac.php">IQAC</a></li>
									<li><a class="dropdown-item" href="./non_teaching_staff.php">Non-Teaching Staff</a></li>
									<li><a class="dropdown-item" href="./alumni_association.php">Alumni Association</a></li>
									<li><a class="dropdown-item" href="./student_union.php">Students' Union</a></li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Departments</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown1">
									<li class="nav-item dropdown">
										<a class="dropdown-item dropdown-toggle" href="#" id="navbarDropdown2" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Science</a>
										<ul class="dropdown-menu" aria-labelledby="navbarDropdown2">
											<li><a class="dropdown-item" href="#">Botany</a></li>
											<li><a class="dropdown-item" href="#">Chemistry</a></li>
											<li><a class="dropdown-item" href="#">Computer Science</a></li>
											<li><a class="dropdown-item" href="#">Mathematics</a></li>
											<li><a class="dropdown-item" href="#">Physics</a></li>
											<li><a class="dropdown-item" href="#">Zoology</a></li>
										</ul>
									</li>
									<li class="nav-item dropdown">
										<a class="dropdown-item dropdown-toggle" href="#" id="navbarDropdown2" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Arts</a>
										<ul class="dropdown-menu" aria-labelledby="navbarDropdown2">
											<li><a class="dropdown-item" href="#">Bengali</a></li>
											<li><a class="dropdown-item" href="#">Economics</a></li>
											<li><a class="dropdown-item" href="#">Education</a></li>
											<li><a class="dropdown-item" href="#">English</a></li>
											<li><a class="dropdown-item" href="#">Geography</a></li>
											<li><a class="dropdown-item" href="#">History</a></li>
											<li><a class="dropdown-item" href="#">Music</a></li>
											<li><a class="dropdown-item" href="#">Philosophy</a></li>
											<li><a class="dropdown-item" href="#">Physical Education</a></li>
											<li><a class="dropdown-item" href="#">Political Science</a></li>
											<li><a class="dropdown-item" href="#">Sanskrit</a></li>
										</ul>
									</li>
									<li><a class="dropdown-item" href="#">Commerce</a></li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Academic</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
									<li><a class="dropdown-item" href="./ug_course.php">Undergraduate</a></li>
									<li><a class="dropdown-item" href="./pg_course.php">Postgraduate</a></li>
									<li><a class="dropdown-item" href="./prospectus.php">Prospectus</a></li>
									<li><a class="dropdown-item" href="./course_outcome.php">Course Outcome</a></li>
									<li><a class="dropdown-item" href="./academic_calendar.php">Academic Calendar</a></li>
									<li><a class="dropdown-item" href="./class_routine.php">Class Routine</a></li>
									<li><a class="dropdown-item" href="./e_module.php">E-Module</a></li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Library</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
									<li><a class="dropdown-item" href="./library_at_a_glance.php">Library at a Glance</a></li>
									<li><a class="dropdown-item" href="./library_staff.php">Library Staff</a></li>
									<li><a class="dropdown-item" href="#">OPAC</a></li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Facilities</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown1">
									<li class="nav-item dropdown">
										<a class="dropdown-item dropdown-toggle" href="#" id="navbarDropdown2" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Student Service Cells</a>
										<ul class="dropdown-menu" aria-labelledby="navbarDropdown2">
											<li><a class="dropdown-item" href="./vishaka_cell.php">Vishaka Cell</a></li>
											<li><a class="dropdown-item" href="./anti_ragging_cell.php">Anti-Ragging Cell</a></li>
											<li><a class="dropdown-item" href="./equal_opportunity_cell.php">Equal Opportunity Cell</a></li>
											<li><a class="dropdown-item" href="./grievance_redressal_cell.php">Grievance Redressal Cell</a></li>
										</ul>
									</li>
									<li class="nav-item dropdown">
										<a class="dropdown-item dropdown-toggle" href="#" id="navbarDropdown2" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Academic</a>
										<ul class="dropdown-menu" aria-labelledby="navbarDropdown2">
											<li><a class="dropdown-item" href="./internet_wifi.php">Internet &amp; Wifi</a></li>
											<li><a class="dropdown-item" href="./educational_tour.php">Educational Tour</a></li>
											<li><a class="dropdown-item" href="./scholarship_stipend.php">Scholarship &amp; Stipend</a></li>
										</ul>
									</li>
									<li class="nav-item dropdown">
										<a class="dropdown-item dropdown-toggle" href="#" id="navbarDropdown2" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Infrastructural</a>
										<ul class="dropdown-menu" aria-labelledby="navbarDropdown2">
											<li><a class="dropdown-item" href="./auditorium.php">Auditorium</a></li>
											<li><a class="dropdown-item" href="./common_room.php">Common Room</a></li>
											<li><a class="dropdown-item" href="./play_ground.php">Play Ground</a></li>
											<li><a class="dropdown-item" href="./generator.php">Generator</a></li>
											<li><a class="dropdown-item" href="./safe_drinking_water.php">Safe Drinking Water</a></li>
											<li><a class="dropdown-item" href="./safety_first_aid.php">Safety, First Aid &amp; Doctor on Call</a></li>
											<li><a class="dropdown-item" href="./canteen.php">Canteen</a></li>
										</ul>
									</li>
								</ul>
							</li>
							<li class="nav-item dropdown">
								<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Activities</a>
								<ul class="dropdown-menu" aria-labelledby="navbarDropdown">
									<li><a class="dropdown-item" href="./nss.php">NSS</a></li>
									<li><a class="dropdown-item" href="./sports_games.php">Sports &amp; Games</a></li>
									<li><a class="dropdown-item" href="./cultural_activities.php">Cultural Activities</a></li>
									<li><a class="dropdown-item" href="./students_fair.php">Students' Fair</a></li>
								</ul>
							</li>
							<li class="nav-item">
								<a class="nav-link" href="#">Study Centre</a>
							</li>
							<li class="nav-item">
								<a class="nav-link" href="#">Gallery</a>
							</li>
							<li class="nav-item">
								<a class="nav-link" href="./contact_us.php">Contact Us</a>
							</li>
						</ul>
					</div>
					
				</nav>
				
			</div>
		</div>
	</div>

<div class="container-fluid text-center my-2">
		<div class="row">
			<div class="col-sm-12">
				<div class="card implnk-card mb-2" style="min-height: 380px; height: auto;">
					<div class="card-header pt-1 pb-0">
						<h4 class="text-right">
							<span style="vertical-align: middle;">Welcome <?php if (isset($_SESSION['RPHC'])) echo $_SESSION['RPHC']; ?></span>
							<a href="./logout.php" class="btn btn-warning btn-sm">Logout</a>
						</h4>
					</div>
					<div class="card-body text-left">
						<h3 class="text-warning">Manage Office Staff</h3>
						<hr />
						<button type="button" class="btn btn-info btn-md" data-toggle="modal" data-target="#myModal"><i class="fa fa-user"></i> Add Staff</button>
						<button type="button" class="btn btn-default btn-md" onclick="javascript:document.location.href='home.php';">Back</button>
						<?php
						$record = execSelect("SELECT * FROM office_staff ORDER BY serial_no");
						if (rowCount($record) > 0) {
							$c = 1;
						?>
							<div class="table-responsive">
								<table id="staffTab" class="table table-striped table-bordered" width="100%" cellspacing="0" style="text-align:center;">
									<thead>
										<tr>
											<th class="text-center">PHOTO</th>
											<th class="text-center">NAME</th>
											<th class="text-center">DESIGNATION</th>
											
											<th class="text-center">ACTION</th>
										</tr>
									</thead>
									<tbody>
										<?php
										while ($rows = getRows($record)) {
										?>
											<tr>
												<td width="125" height="125"><img src="<?php echo $rows['photo']; ?>" width="125" height="125" /></td>
												<td style="vertical-align:middle;"><?php echo $rows['name']; ?></td>
												<td style="vertical-align:middle;"><?php echo $rows['designation']; ?></td>
												
												<td style="vertical-align:middle;">
													<a href="javascript:void(0);" class="btn btn-info btn-md" onClick="javascript:editUser(<?php echo $rows['id'] ?>);">
														<i class="fa fa-edit"></i>&nbsp;&nbsp;Edit</a>
													&nbsp;&nbsp;
													<a href="javascript:void(0);" class="btn btn-danger btn-md" onclick="javascript:confirmDelete(<?php echo $rows['id'] ?>);">
														<i class="fa fa-times"></i>&nbsp;&nbsp;Delete</a>
												</td>
											</tr>
										<?php
										}
										?>
									</tbody>
								</table>
							</div>
						<?php
						}
						mysqli_free_result($record);
						?>
					</div>
				</div>
			</div>
		</div>
	</div>

<footer class="container-fluid text-center">
		<div class="row">
			<div class="col-sm-4 my-auto">
				<h6 class="h6-responsive white-text">
					Rampurhat College
				</h6>
			</div>
			<div class="col-sm-4 my-auto">
			</div>
			<div class="col-sm-4 my-auto">
				<ul class="social-network social-circle">
					<li><a href="#" class="icoFacebook" title="Facebook"><i class="fa fa-facebook"></i></a></li>
					<li><a href="#" class="icoGoogle" title="Youtube" target="_blank"><i class="fa fa-youtube"></i></a></li>
				</ul>
			</div>
		</div>
	</footer>

<div class="modal fade" id="myModal" role="dialog" tabindex="-1" aria-hidden="true" data-backdrop="static" data-keyboard="false">
		<div class="modal-dialog cascading-modal" role="document">
			<div class="modal-content">
				<div class="modal-header primary-color white-text">
					<h4 class="title"><i class="fa fa-plus"></i> ADD NEW STAFF</h4>
					<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
						<span aria-hidden="true">x</span>
					</button>
				</div>
				<div class="modal-body">
					<form id="addProfile" method="post" enctype="multipart/form-data" autocomplete="off" onsubmit="return validate();">

<label for="serial">Serial No:</label>
						<input type="text" class="form-control form-control-sm" id="serial" name="serial" />

<br />

<!-- <label for="qualification">Qualification:</label>
						<input type="text" class="form-control form-control-sm" id="qualification" name="qualification" placeholder="Qualification" />

<label for="designation">Designation:</label>
						<input type="text" class="form-control form-control-sm" id="designation" name="designation" placeholder="Designation" />

<!--<label for="mobile">Mobile No.:</label>
                    <input type="text" class="form-control form-control-sm" id="mobile" name="mobile" placeholder="Mobile No." />

<br/>

<label for="email">Email Id:</label>
                    <input type="text" class="form-control form-control-sm" id="email" name="email" placeholder="Email Id" />

<label for="photo">Upload Photo:<br />
							<font size="-2" color="#FF6600">(Max. Photo size accepted is 30 KB)</font>
						</label>
						<input type="file" class="form-control form-control-sm" id="photo" name="photo" style="height:auto;" />

<!--<br/>

<label class="control-label col-sm-5" for="biodata">Upload Biodata:<br/>
                        <font size="-2" color="#FF6600">(Only pdf &amp; word files are allowed. Max. file size accepted is 4 MB)</font>
                    </label>
                    <input type="file" class="form-control form-control-sm" id="biodata" name="biodata" style="height:auto;" />-->

<div class="text-center mt-4 mb-2">
							<button type="submit" class="btn btn-success btn-md" name="add" value="Add">Submit</button>&nbsp;&nbsp;
							<button type="reset" class="btn btn-info btn-md">Clear</button>
						</div>
					</form>
				</div>
			</div>
		</div>
	</div>

<div class="modal fade" id="editModal" role="dialog" tabindex="-1" aria-hidden="true" data-backdrop="static" data-keyboard="false">
		<div class="modal-dialog cascading-modal" role="document">
			<div class="modal-content">
				<div class="modal-header primary-color white-text">
					<h4 class="title"><i class="fa fa-edit"></i> EDIT STAFF</h4>
					<button type="button" class="close waves-effect waves-light" data-dismiss="modal" aria-label="Close">
						<span aria-hidden="true">x</span>
					</button>
				</div>
				<div class="modal-body">
					<form id="editProfile" method="post" autocomplete="off" enctype="multipart/form-data" onsubmit="return check();">
						<input type="hidden" id="eId" name="eId" />
	
						<label for="eserial">Serial No:</label>
						<input type="text" class="form-control form-control-sm" id="eserial" name="eserial" />

<br />

<!-- <label for="equalification">Qualification:</label>
						<input type="text" class="form-control form-control-sm" id="equalification" name="equalification" />

<label for="edesignation">Designation:</label>
						<input type="text" class="form-control form-control-sm" id="edesignation" name="edesignation" />

<br />
						
						<!--<label for="emobile">Mobile No.:</label>
                    <input type="text" class="form-control form-control-sm" id="emobile" name="emobile" />

<br/>

<label for="edemail">Email Id:</label>
                    <input type="text" class="form-control form-control-sm" id="edemail" name="edemail" />

<div id="img" style="display:none;">
							<label>Old Photo:</label>
							<img id="oldPhoto" width="80" height="89" />
						</div>

<br />

<label for="ephoto">Upload/Change Photo:<br />
							<font size="-2" color="#FF6600">(Max. Photo size accepted is 30 KB)</font>
						</label>
						<input type="file" class="form-control form-control-sm" id="ephoto" name="ephoto" style="height:auto;" />

<!--<br/>

<label class="control-label col-sm-5" for="ebiodata">Upload Biodata:<br/>
                        <font size="-2" color="#FF6600">(Only pdf &amp; word files are allowed<br/>Max. file size accepted is 4 MB)</font>
                    </label>
                    <input type="file" class="form-control" id="ebiodata" name="ebiodata" style="height:auto;" />-->

<div class="text-center mt-4 mb-2">
							<button type="submit" class="btn btn-success btn-md" name="update" value="Update">Update</button>
						</div>
					</form>
				</div>
			</div>
		</div>
	</div>

<div class="modal fade" id="deleteModal" role="dialog" tabindex="-1" aria-hidden="true" data-backdrop="static" data-keyboard="false">
		<div class="modal-dialog">
			<div class="modal-content">
				<div class="modal-header">
					
					<h4 class="modal-title"><strong>DELETE STAFF</strong></h4>
				</div>
				<div class="modal-body">
					<p>Do You Want to Realy Delete this Profile ?</p>
				</div>
				<div class="modal-footer">
					<button type="button" class="btn btn-default btn-md" data-dismiss="modal">Cancel</button>
					<span id='deleteButton'></span>
				</div>
			</div>
		</div>
	</div>

<script src="script/jquery-3.4.1.min.js" type="text/javascript"></script>
	<script type="text/javascript" src="script/popper.min.js"></script>
	<script src="script/bootstrap.min.js" type="text/javascript"></script>
	<script type="text/javascript" src="script/mdb.min.js"></script>
	<script type="text/javascript" src="script/bootnavbar.js"></script>
	<script type="text/javascript" src="script/picker.js"></script>
	<script type="text/javascript" src="script/picker.date.js"></script>
	<script type="text/javascript" src="https://cdn.datatables.net/1.11.4/js/jquery.dataTables.min.js"></script>
	<script type="text/javascript" src="https://cdn.datatables.net/1.11.4/js/dataTables.bootstrap4.min.js"></script>
	<script type="text/javascript">
		$(document).ready(function() {
			if ($("#staffTab").length) {
				$('#staffTab').DataTable({
					"ordering": false,
					"lengthMenu": [
						[10, 20, 40, 60, 80, 100],
						[10, 20, 40, 60, 80, 100]
					]
				});
			}
		});

function confirmDelete(cid) {
			$('#deleteModal').modal();
			$('#deleteButton').html('<a class="btn btn-danger btn-md" onclick="deleteProfile(' + cid + ')">Delete</a>');
		}

function deleteProfile(cid) {
			$.ajax({
				type: "POST",
				dataType: "json",
				url: "delete_staff.php",
				data: {
					pid: cid
				},
				success: function(d) {
					if (d.status == "success") {
						document.location.href = "staff_profile.php";
					}
				}
			});
		}
	</script>
</body>

</html>
<?php
if (isset($_POST['add']) && $_POST['add'] == "Add") {
	$serial = stripslashes($_POST['serial']);
	$serial = filterInput($serial);
	
	$name = stripslashes($_POST['name']);
	$name = filterInput($name);

// $qualification = stripslashes($_POST['qualification']);
	// $qualification = filterInput($qualification);

$designation = stripslashes($_POST['designation']);
	$designation = filterInput($designation);

$location = "";

if (is_uploaded_file($_FILES["photo"]["tmp_name"])) {
		$location = "profile/" . $name . "_" . $_FILES["photo"]["name"];
	}

$sql = "INSERT INTO office_staff (name, serial_no, designation, photo)
			VALUES ('$name', '$serial', '$designation', '$location')";

$result = execInsert($sql);
	if ($result) {
		if (!empty($location)) {
			move_uploaded_file($_FILES["photo"]["tmp_name"], $location);
		}
		echo "<script>alert('Staff profile successfully added');</script>";
	} else {
		echo "<script>alert('Internal problem occurs! Try again later');</script>";
	}
	echo "<script>document.location.href='staff_profile.php';</script>";
}

if (isset($_POST['update']) && $_POST['update'] == "Update") {
	$id = $_POST['eId'];

$serial = stripslashes($_POST['eserial']);
	$serial = filterInput($serial);
	
	$name = stripslashes($_POST['ename']);
	$name = filterInput($name);

// $qualification = stripslashes($_POST['equalification']);
	// $qualification = filterInput($qualification);

$designation = stripslashes($_POST['edesignation']);
	$designation = filterInput($designation);

$location = "";
	$file_qry = execSelect("SELECT photo FROM office_staff WHERE id='$id'");
	$resp = getRows($file_qry);
	$photo = $resp['photo'];
	mysqli_free_result($file_qry);

if (is_uploaded_file($_FILES["ephoto"]["tmp_name"])) {
		$location = "profile/" . $name . "_" . $_FILES["ephoto"]["name"];
		if (file_exists($photo)) {
			unlink($photo);
		}
	}

if ($location != "") {
		$sql = "UPDATE office_staff SET name='$name', serial_no='$serial', designation='$designation', photo='$location' ";
	} else {
		$sql = "UPDATE office_staff SET name='$name', serial_no='$serial', designation='$designation' ";
	}
	$sql .= " where id='$id'";

$result = execUpdate($sql);
	if ($result) {
		if (!empty($location)) {
			move_uploaded_file($_FILES["ephoto"]["tmp_name"], $location);
		}
		echo "<script>alert('Staff profile successfully updated');</script>";
	} else {
		echo "<script>alert('Internal problem occurs! Try again later');</script>";
	}
	echo "<script>document.location.href='staff_profile.php';</script>";
}
?>

${this.title}

Code Editor : staff_profile.php