|
Server IP : 103.191.208.227 / Your IP : 18.118.252.85 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/mhmsfzcs/vflyorions.com/admin/assets/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!DOCTYPE html>
<html lang="en">
<head>
</head>
<script src="tinymce/tinymce.min.js"></script>
<script src="script.js"></script>
</html>
<?php
include 'db.php';
include 'header.php';
include 'sidebar.php';
$image='';
if (isset($_POST['change']))
{
$id=$_POST['id'];
$heading=$_POST['heading'];
$role=$_POST['role'];
$salary=$_POST['salary'];
$schedule=$_POST['schedule'];
$education=$_POST['education'];
$experience=$_POST['experience'];
$language=$_POST['language'];
$hour=$_POST['hour'];
// $image=$_POST['image'];
// $oldimage=$_POST['oldimage'];
// if (isset($_FILES['newimage']['name'])&&($_FILES['newimage']['name']!="")){
// $newimage=$_FILES['newimage']['name'];
// // unlink($oldimage);
// $destinationfile='assets/course_image/'.$newimage;
// move_uploaded_file($_FILES['newimage']['tmp_name'], $destinationfile);
// }
// else{
// $newimage=$oldimage;
// }
$insert2 = $conn->prepare("UPDATE `career` SET `heading`=?,`role`=?,`salary`=?,`schedule`=?,`education`=?,`experience`=?,`language`=?,`hour`=? WHERE id=?" );
$insert2->bind_param("sssssssss",$heading,$role,$salary,$schedule,$education,$experience,$language,$hour,$id);
$res=$insert2->execute();
if($res)
{
$_SESSION['status']="Updated Successfully";
$_SESSION['status_code']="success";
}
else
{
// $_SESSION['status']="Oops something went wrong!!";
// $_SESSION['status_code']="error";
}
}
if(isset($_GET['delete']))
{
$ad=$_GET['delete'];
$query=$conn->prepare("delete from career where id =?");
$query->bind_param("s",$ad);
$res=$query->execute();
if($res)
{
$_SESSION['status']="User Deleted Successfully";
$_SESSION['status_code']="success";
}
else
{
$_SESSION['status']="Oops something went wrong!!";
$_SEESION['status_code']="error";
}
}
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0">Dashboard</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="card">
<div class="card-header">
<h3 class="card-title">Manage courses</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>Sr. No.</th>
<th>Heading</th>
<th>Role & Responsibility</th>
<th>Salary</th>
<th>Schedule</th>
<th>Education</th>
<th>Experience</th>
<th>Language</th>
<th>Part Time Hours</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$que="SELECT * From career";
$r=$conn->query($que);
$sr=1;
while($row=$r->fetch_assoc())
{
$id=$row['id'];
?>
<tr>
<td><?php echo $sr;?></td>
<td><?php echo $row['heading'];?></td>
<td><?php echo $row['role'];?></td>
<td><?php echo $row['salary'];?></td>
<td><?php echo $row['schedule'];?></td>
<td><?php echo $row['education'];?></td>
<td><?php echo $row['experience'];?></td>
<td><?php echo $row['language'];?></td>
<td><?php echo $row['hour'];?></td>
<td><a href="manage_career.php?delete=<?= $row['id']; ?>" onclick="return confirm('Are you sure to delete?')" class="btn btn-danger">Delete</a>
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#modal-default<?php echo $id;?>" data-id="<?php echo $id; ?>">
<i class="mdi mdi-pencil label-icon"></i>Edit
</button>
</td>
</tr>
<div class="modal fade" id="modal-default<?php echo $id;?>">
<?php
$uquery = "SELECT * from career WHERE id='$id'";
$result2=$conn->query($uquery);
while($row5=$result2->fetch_assoc())
{
?>
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Edit</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form method="post" enctype="multipart/form-data">
<div class="card-body">
<div class="row">
<div class="col-sm-12">
<div class="form-group">
<label>Heading </label>
<input type="text" data-pristine-required-message="Please Enter a Heading" name="heading" class="form-control" value="<?php echo $row5['heading'];?>" />
<input type="hidden" name="id" class="form-control" value="<?php echo $row5['id'];?>">
</div>
<div class="form-group">
<label>Role & Responsibility </label>
<!--<input type="text" data-pristine-required-message="Please Enter a Role & Responsibility" name="role" class="form-control" />-->
<textarea class="form-control" name="role" id="default" value="<?php echo $row5['role'];?>" ></textarea>
</div>
<div class="form-group">
<label>Salary </label>
<input type="text" data-pristine-required-message="Please Enter a Salary" name="salary" class="form-control" value="<?php echo $row5['salary'];?>" />
</div>
<div class="form-group">
<label>Schedule </label>
<input type="text" data-pristine-required-message="Please Enter a Schedule" name="schedule" class="form-control" value="<?php echo $row5['schedule'];?>" />
</div>
<div class="form-group">
<label>Education </label>
<input type="text" data-pristine-required-message="Please Enter a Education" name="education" class="form-control" value="<?php echo $row5['education'];?>" />
</div>
<div class="form-group">
<label>Experience </label>
<input type="text" data-pristine-required-message="Please Enter a Experience" name="experience" class="form-control" value="<?php echo $row5['experience'];?>" />
</div>
<div class="form-group">
<label>Language </label>
<input type="text" data-pristine-required-message="Please Enter a Language" name="language" class="form-control" value="<?php echo $row5['language'];?>" />
</div>
<div class="form-group">
<label>Part Time Hours </label>
<input type="text" data-pristine-required-message="Please Enter a Hours" name="hour" class="form-control" value="<?php echo $row5['hour'];?>" />
</div>
<!--<div class="form-group">-->
<!-- <label>Image </span></label>-->
<!-- <input type="hidden" class="form-control" id="exampleInputdob" name="oldimage" placeholder="Image" value="<?php // echo $row5['image'];?>">-->
<!-- <input type="file" class="form-control" id="exampleInputdob" name="newimage" placeholder="Image">-->
<!-- <img src="<?php //echo('assets/course_image')."/".$row5['image'];?>" width="100" class="img-thumbnail" >-->
<!--</div>-->
</div>
</div>
</div>
<!-- /.card-body -->
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" name="change" class="btn btn-primary">Save changes</button>
</div>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
<?php } ?>
</div>
<?php
$sr=$sr+1;}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.row -->
</div><!--/. container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
<!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#site").change(function()
{
var site_id=$(this).val();
var post_id = 'id='+ site_id;
$.ajax
({
type: "POST",
url: "fetch.php",
data: post_id,
cache: false,
success: function(cities)
{
$("#cp").html(cities);
}
});
});
});
</script> -->
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<?php if(isset($_SESSION['status']) && $_SESSION['status']!='') { ?>
<script>
new swal({
title: "<?php echo $_SESSION['status'];?>",
//text: "You clicked the button!",
icon: "<?php echo $_SESSION['status_code'];?>",
button: "OK",
}).then(function() {
window.location = "manage_career.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<?php include 'footer.php'; ?>