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/public_html/website_7c8ed5ef/admin/manage_testimonial/ |
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
?>
<!-- Update user data wrap --->
<!-- [ 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 btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Update Review</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 review_tbl WHERE id='1'"));
?>
<form method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title">Title</label>
<input type="text" class="form-control" name="title" value="<?=$fetQuery['title']?>" required>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image">Image</label><br>
<input type="file" class="form-control" name="image" id="picture" value="<?=$fetQuery['image']?>">
<p id="error1" style="display:none; color:#FF0000;">
Invalid Image Format! Image Format Must Be JPG, JPEG, PNG or Webp.
</p>
<p id="error2" style="display:none; color:#FF0000;">
Maximum File Size Limit is 5MB.
</p>
</div>
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery['image']?>" style="width: 120px; height: 90px;"><br>
</div>
<div class="col-md-12">
<label class="form-label" for="Content">Heading footer</label>
<div class="form-group d-flex gap-2">
<input class="form-control" type="text" name="heading" value="<?=$fetQuery['heading']?>"><input class="form-control" type="text" name="heading1" value="<?=$fetQuery['heading1']?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image1_1</label>
<input type="file" class="form-control" name="image1_1">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image1_1"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image1_2</label>
<input type="file" class="form-control" name="image1_2">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image1_2"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image2_1</label>
<input type="file" class="form-control" name="image2_1">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image2_1"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image2_2</label>
<input type="file" class="form-control" name="image2_2">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image2_2"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image3_1</label></label>
<input type="file" class="form-control" name="image3_1">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image3_1"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image3_2</label>
<input type="file" class="form-control" name="image3_2">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image3_2"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image4_1</label>
<input type="file" class="form-control" name="image4_1">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image4_1"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Goal">image4_2</label>
<input type="file" class="form-control" name="image4_2">
<img src="<?=$base_url?>images/Upload/Testimonial/<?=$fetQuery["image4_2"];?>" style="width: 120px; height: 90px; margin: 10px;"/>
</div>
</div>
<div class="col-md-12 ">
<div class="form-group">
<div class="row" id="input-container">
<div class="col-lg-5">
<h4>about1_atb</h4>
<textarea name="about1_atb" class="form-control" id="about1_atb"><?=$fetQuery["about1_atb"];?></textarea>
</div>
<div class="col-lg-5">
<h4>title1_atb</h4>
<input type="text" name="title1_atb" class="form-control" id="title1_atb" value="<?=$fetQuery["title1_atb"];?>">
</div>
<div class="col-lg-5">
<h4>position1_atb</h4>
<input type="text" name="position1_atb" class="form-control" id="position1_atb" value="<?=$fetQuery["position1_atb"];?>">
</div>
<div class="col-lg-2 mt-4">
<a id="myButton" class="bg-success form-control text-center text-white fw-bold mt-1 mb-2">Add More</a>
</div>
</div>
</div>
<!-- Muliple Product images color etc start edit --->
<?php
$attribute=mysqli_query($conn,"SELECT * FROM `review_atb_tbl`");
if(mysqli_num_rows($attribute)>0){ ?>
<?php
$Atb=mysqli_query($conn,"SELECT * FROM `review_atb_tbl`");
while($row=mysqli_fetch_array($Atb)){ ?>
<div class="form-group input-element data-item">
<input type="hidden" name="id_editatb[]" class="form-control" required value="<?=$row['id']?>" >
<div class="row">
<div class="col-lg-6">
<h4>about_atb</h4>
<textarea name="about_atb[]" class="form-control" id="about_atb"><?=$row["about_atb"];?></textarea>
</div>
<div class="col-lg-6">
<h4>title_atb</h4>
<input type="text" name="title_atb[]" class="form-control" id="title_atb" value="<?=$row["title_atb"];?>">
</div>
<div class="col-lg-6">
<h4>position_atb</h4>
<input type="text" name="position_atb[]" class="form-control" id="position_atb" value="<?=$row["position_atb"];?>">
</div>
<div class="col-lg-2 mt-4">
<a class="bg-danger form-control text-center text-white fw-bold delete-btn" data-id="<?=$row['id']?>">Remove</a>
</div>
</div>
</div>
<?php } ;?>
<?php } else { ?>
<?php } ?>
<!-- Muliple Product images color etc wrap edit --->
</div>
</div>
<div class="row">
<div class="col-md-6">
<input type="submit" name="submit" class="btn btn-danger" id="submit" value="Update">
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$("#myButton").click(function() {
$.ajax({
url: "insert_input.php",
success: function(html) {
$("#input-container").append(html);
}
});
});
});
$(document).on("click", ".remove-input", function() {
$(this).closest(".input-element").remove();
});
$(document).ready(function() {
$('.delete-btn').on('click', function() {
var itemId = $(this).data('id');
var deleteButton = $(this);
$.ajax({
url: 'delete_product.php',
method: 'POST',
data: { id: itemId },
success: function(response) {
// Handle the response from the server
console.log(response);
// Remove the deleted data from the DOM
deleteButton.closest('.data-item').remove();
},
error: function(xhr, status, error) {
// Handle the error
console.log(error);
}
});
});
});
</script>
<!-- Upadte user data start --->
<?php
if(isset($_POST['submit'])){
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$heading=$_POST['heading'];
$heading=str_replace("'", "\'", $heading);
$heading1=$_POST['heading1'];
$heading1=str_replace("'", "\'", $heading1);
$title1_atb=$_POST['title1_atb'];
$title1_atb=str_replace("'", "\'", $title1_atb);
$position1_atb=$_POST['position1_atb'];
$position1_atb=str_replace("'", "\'", $position1_atb);
$about1_atb=$_POST['about1_atb'];
$about1_atb=str_replace("'", "\'", $about1_atb);
$file_name=$_FILES['image']['name'];
$file_tmp=$_FILES['image']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image']['name'])));
$file_name1=$_FILES['image1_1']['name'];
$file_tmp1=$_FILES['image1_1']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image1_1']['name'])));
$file_name2=$_FILES['image1_2']['name'];
$file_tmp2=$_FILES['image1_2']['tmp_name'];
$file_ext2=strtolower(end(explode('.',$_FILES['image1_2']['name'])));
$file_name3=$_FILES['image2_1']['name'];
$file_tmp3=$_FILES['image2_1']['tmp_name'];
$file_ext3=strtolower(end(explode('.',$_FILES['image2_1']['name'])));
$file_name4=$_FILES['image2_2']['name'];
$file_tmp4=$_FILES['image2_2']['tmp_name'];
$file_ext4=strtolower(end(explode('.',$_FILES['image2_2']['name'])));
$file_name5=$_FILES['image3_1']['name'];
$file_tmp5=$_FILES['image3_1']['tmp_name'];
$file_ext5=strtolower(end(explode('.',$_FILES['image3_1']['name'])));
$file_name6=$_FILES['image3_2']['name'];
$file_tmp6=$_FILES['image3_2']['tmp_name'];
$file_ext6=strtolower(end(explode('.',$_FILES['image3_2']['name'])));
$file_name7=$_FILES['image4_1']['name'];
$file_tmp7=$_FILES['image4_1']['tmp_name'];
$file_ext7=strtolower(end(explode('.',$_FILES['image4_1']['name'])));
$file_name8=$_FILES['image4_2']['name'];
$file_tmp8=$_FILES['image4_2']['tmp_name'];
$file_ext8=strtolower(end(explode('.',$_FILES['image4_2']['name'])));
if(!empty($file_name)){
$random_number = rand();
$new_file_name = $random_number.'.'.$file_ext;
$file_path="../../images/Upload/Testimonial/".$new_file_name;
$img_path=substr($file_path,6);
move_uploaded_file($file_tmp,$file_path);
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path="../../images/Upload/Testimonial/".$dlt['image'];
unlink($dlt_path);
mysqli_query($conn,"UPDATE `review_tbl` SET `image`='$new_file_name' WHERE id='1'");
}
if(!empty($file_name1)){
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/Testimonial/".$new_file_name1;
$img_path1=substr($file_path1,6);
move_uploaded_file($file_tmp1,$file_path1);
$dlt1=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path1="../../images/Upload/Testimonial/".$dlt1['image1_1'];
unlink($dlt_path1);
mysqli_query($conn,"UPDATE `review_tbl` SET `image1_1`='$new_file_name1' WHERE id='1'");
}
if(!empty($file_name2)){
$random_number2 = rand();
$new_file_name2 = $random_number2.'.'.$file_ext2;
$file_path2="../../images/Upload/Testimonial/".$new_file_name2;
$img_path2=substr($file_path2,6);
move_uploaded_file($file_tmp2,$file_path2);
$dlt2=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path2="../../images/Upload/Testimonial/".$dlt2['image1_2'];
unlink($dlt_path2);
mysqli_query($conn,"UPDATE `review_tbl` SET `image1_2`='$new_file_name2' WHERE id='1'");
}
if(!empty($file_name3)){
$random_number3 = rand();
$new_file_name3 = $random_number3.'.'.$file_ext3;
$file_path3="../../images/Upload/Testimonial/".$new_file_name3;
$img_path3=substr($file_path3,6);
move_uploaded_file($file_tmp3,$file_path3);
$dlt3=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path3="../../images/Upload/Testimonial/".$dlt3['image2_1'];
unlink($dlt_path3);
mysqli_query($conn,"UPDATE `review_tbl` SET `image2_1`='$new_file_name3' WHERE id='1'");
}
if(!empty($file_name4)){
$random_number4 = rand();
$new_file_name4 = $random_number4.'.'.$file_ext4;
$file_path4="../../images/Upload/Testimonial/".$new_file_name4;
$img_path4=substr($file_path4,6);
move_uploaded_file($file_tmp4,$file_path4);
$dlt4=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path4="../../images/Upload/Testimonial/".$dlt2['image2_2'];
unlink($dlt_path4);
mysqli_query($conn,"UPDATE `review_tbl` SET `image2_2`='$new_file_name4' WHERE id='1'");
}
if(!empty($file_name5)){
$random_number5 = rand();
$new_file_name5 = $random_number5.'.'.$file_ext5;
$file_path5="../../images/Upload/Testimonial/".$new_file_name5;
$img_path5=substr($file_path5,6);
move_uploaded_file($file_tmp5,$file_path5);
$dlt5=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path5="../../images/Upload/Testimonial/".$dlt2['image3_1'];
unlink($dlt_path2);
mysqli_query($conn,"UPDATE `review_tbl` SET `image3_1`='$new_file_name5' WHERE id='1'");
}
if(!empty($file_name6)){
$random_number6 = rand();
$new_file_name6 = $random_number6.'.'.$file_ext6;
$file_path6="../../images/Upload/Testimonial/".$new_file_name6;
$img_path6=substr($file_path6,6);
move_uploaded_file($file_tmp6,$file_path6);
$dlt6=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path6="../../images/Upload/Testimonial/".$dlt6['image3_2'];
unlink($dlt_path6);
mysqli_query($conn,"UPDATE `review_tbl` SET `image3_2`='$new_file_name6' WHERE id='1'");
}
if(!empty($file_name7)){
$random_number7 = rand();
$new_file_name7 = $random_number7.'.'.$file_ext7;
$file_path7="../../images/Upload/Testimonial/".$new_file_name7;
$img_path7=substr($file_path7,6);
move_uploaded_file($file_tmp7,$file_path7);
$dlt7=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path7="../../images/Upload/Testimonial/".$dlt7['image4_1'];
unlink($dlt_path7);
mysqli_query($conn,"UPDATE `review_tbl` SET `image4_1`='$new_file_name7' WHERE id='1'");
}
if(!empty($file_name8)){
$random_number8 = rand();
$new_file_name8 = $random_number8.'.'.$file_ext8;
$file_path8="../../images/Upload/Testimonial/".$new_file_name8;
$img_path8=substr($file_path8,8);
move_uploaded_file($file_tmp8,$file_path8);
$dlt8=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `review_tbl` WHERE id='1'"));
$dlt_path8="../../images/Upload/Testimonial/".$dlt8['image4_2'];
unlink($dlt_path8);
mysqli_query($conn,"UPDATE `review_tbl` SET `image4_2`='$new_file_name8' WHERE id='1'");
}
$updateQry=mysqli_query($conn,"UPDATE `review_tbl` SET
`title`='$title',
`heading`='$heading',
`heading1`='$heading1',
`title1_atb`='$title1_atb',
`position1_atb`='$position1_atb',
`about1_atb`='$about1_atb' WHERE `id`= '1'")or die(mysqli_error($conn));
// Handle updates to about_image_tbl
if (isset($_POST['id_editatb']) && is_array($_POST['id_editatb'])) {
foreach ($_POST['id_editatb'] as $key => $id_editatb) {
// Update the title
$about_atb = mysqli_real_escape_string($conn, $_POST['about_atb'][$key]);
$title_atb = mysqli_real_escape_string($conn, $_POST['title_atb'][$key]);
$position_atb = mysqli_real_escape_string($conn, $_POST['position_atb'][$key]);
$updateTitleQuery = "UPDATE `review_atb_tbl` SET `about_atb` = '$about_atb',`title_atb` = '$title_atb',`position_atb` = '$position_atb' WHERE id = '$id_editatb'";
mysqli_query($conn, $updateTitleQuery);
}
}
// Handle adding new content to about_image_tbl
// Check if form is submitted and data is available
if (isset($_POST['about_atb']) && is_array($_POST['about_atb'])) {
foreach ($_POST['about_atb'] as $key => $val) {
$about_atb = mysqli_real_escape_string($conn, $_POST['about_atb'][$key]);
$title_atb = mysqli_real_escape_string($conn, $_POST['title_atb'][$key]);
$position_atb = mysqli_real_escape_string($conn, $_POST['position_atb'][$key]);
$insertQuery = "INSERT INTO `review_atb_tbl` (`about_atb`, `title_atb`,`position_atb`) VALUES ('$about_atb', '$title_atb','$position_atb')";
if (!mysqli_query($conn, $insertQuery)) {
die("Error inserting new image: " . mysqli_error($conn));
}
}
}
if($updateQry){
echo "<script>window.location='show.php?page=test';</script>";
$_SESSION['message']="Profile configuration updated successfully";
}
}
?>