%PDF- %GIF98; %PNG;
Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_7c8ed5ef/admin/manage_multimedia/ |
Upload File : |
<?php
error_reporting(0);
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
// Sidebar strat
include('../include/sidebar.php');
// Sidebar wrap
$id=$_GET['id'];
?>
<!-- [ Main Content ] start -->
<section class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-light text-white fw-bold btn-sm btn-round"><i class="feather icon-edit"></i> Add | Edit | Multimedia </button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<div class="col-md-12">
<div class="card">
<!-- <div class="card-header d-flex justify-content-between">
</div> -->
<div class="card-body">
<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<i class="feather icon-thumbs-up text-success"></i> <strong class="text-dark">'.$_SESSION['message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']);
?>
<?php if(isset($_SESSION['img_error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['img_error'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['img_error']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM multimedia_tbl WHERE id='$id'"));
?>
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title">Title</label>
<input type="text" name="title" class="form-control" value="<?=$fetQuery['title']?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Type">Type Sale</label>
<select class="form-select" name="sale_type">
<option disabled selected>Please select Sale</option>
<!-- <option value="1" </?=($fetQuery['sale_type']=='1')?'selected':'';?>>Everyone</option> -->
<option value="2" <?=($fetQuery['sale_type']=='2')?'selected':'';?>>Free</option>
<option value="3" <?=($fetQuery['sale_type']=='3')?'selected':'';?>>For sale</option>
</select>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="Content">Content</label>
<textarea name="content" id="editor1" rows="3" class="form-control"><?=$fetQuery['content']?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image1">Main Image</label>
<input type="file" name="image1" id="picture" class="form-control">
<p id="error1" style="display:none; color:#FF0000;">
Invalid File Format! File Format Must Be JPG , JPEG , PNG , Webp , MP4 , MKV , OGG , Webm.
</p>
<p id="error2" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
</div>
<?php
if ($id!='') {
echo'<img class="mt-1" src="'.$base_url.'images/Upload/multimedia/'.$fetQuery['image1'].'" style="width:140px; height: 100px;">';
}
?>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image1">Image</label>
<input type="file" name="image2" id="picture1" class="form-control">
<p id="error3" style="display:none; color:#FF0000;">
Invalid File Format! File Format Must Be JPG , JPEG , PNG , Webp , MP4 , MKV , OGG , Webm.
</p>
<p id="error4" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
</div>
<?php
if ($id!='') {
echo'<img class="mt-1" src="'.$base_url.'images/Upload/multimedia/'.$fetQuery['image2'].'" style="width:140px; height: 100px;">';
}
?>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Price">Price</label>
<input type="number" name="price" class="form-control" value="<?=$fetQuery['price']?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="status">Status</label>
<select class="form-select" name="status">
<option disabled selected>Please select status</option>
<option value="1" <?=($fetQuery['status']=='1')?'selected':'';?>>Show</option>
<option value="0" <?=($fetQuery['status']=='0')?'selected':'';?>>Hide</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<?php
if(($id!='')){
echo'<input type="submit" name="update" class="btn btn-success" value="Update">';
}else{
echo'<input type="submit" name="add" class="btn btn-success" value="Add">';
}
?>
<a class="text-white btn btn-dark" href="show.php?page=multi">Back</a>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<!-- Insert data start --->
<?php
if(isset($_POST['add'])){
$title = $_POST['title'];
$sale_type = $_POST['sale_type'];
$content = $_POST['content'];
$price = $_POST['price'];
$status = $_POST['status'];
$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));
$file_name1=$_FILES['image2']['name'];
$file_tmp1=$_FILES['image2']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image2']['name'])));
$addQry=mysqli_query($conn,"INSERT `multimedia_tbl` SET
`cat_id`='2',
`title`='$title',
`sale_type`='$sale_type',
`content`='$content',
`price`='$price',
`status`='$status'")or die(mysqli_error($conn));
$ido = mysqli_insert_id($conn);
$slug = create_url($title).$ido;
mysqli_query($conn,"UPDATE `multimedia_tbl` SET `slug`='$slug' WHERE id='$ido'")or die(mysqli_error($conn));
if(!empty($file_name)){
$random_number = rand();
$new_file_name = $random_number.'.'.$file_ext;
$file_path="../../images/Upload/multimedia/".$new_file_name;
move_uploaded_file($file_tmp,$file_path);
$addQry=mysqli_query($conn,"UPDATE `multimedia_tbl` SET `image1`='$new_file_name' WHERE id='$ido'")or die(mysqli_error($conn));
}
if(!empty($file_name1)){
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/multimedia/".$new_file_name1;
move_uploaded_file($file_tmp1,$file_path1);
$addQry=mysqli_query($conn,"UPDATE `multimedia_tbl` SET `image2`='$new_file_name1' WHERE id='$ido'")or die(mysqli_error($conn));
}
if($addQry){
echo "<script>window.location='show.php?page=multi';</script>";
$_SESSION['message']="Record Insertted successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$title = $_POST['title'];
$sale_type = $_POST['sale_type'];
$content = $_POST['content'];
$price = $_POST['price'];
$status = $_POST['status'];
$slug = create_url($title).$id;
$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));
$file_name1=$_FILES['image2']['name'];
$file_tmp1=$_FILES['image2']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image2']['name'])));
if(!empty($file_name)){
$random_number = rand();
$new_file_name = $random_number.'.'.$file_ext;
$file_path="../../images/Upload/multimedia/".$new_file_name;
move_uploaded_file($file_tmp,$file_path);
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `multimedia_tbl` WHERE id='$id'"));
$dlt_path="../../images/Upload/multimedia/".$dlt['image1'];
unlink($dlt_path);
$sql="UPDATE `multimedia_tbl` SET `image1`='$new_file_name' WHERE id='$id'";
$query=mysqli_query($conn,$sql);
}
if(!empty($file_name1)){
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/multimedia/".$new_file_name1;
move_uploaded_file($file_tmp1,$file_path1);
$dlt1=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `multimedia_tbl` WHERE id='$id'"));
$dlt_path1="../../images/Upload/multimedia/".$dlt1['image2'];
unlink($dlt_path1);
$sql1="UPDATE `multimedia_tbl` SET `image2`='$new_file_name1' WHERE id='$id'";
$query1=mysqli_query($conn,$sql1);
}
$editQry=mysqli_query($conn,"UPDATE `multimedia_tbl` SET
`cat_id`='2',
`title`='$title',
`sale_type`='$sale_type',
`content`='$content',
`price`='$price',
`slug`='$slug',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=multi';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->