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_6031bb72/admin/manage_services/ |
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-dark text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Add | Edit | Services | </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> <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 services_tbl WHERE id='$id'"));
?>
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">
<div class="row">
<div class="text-center bg-primary text-white fs-2 mb-3">Services Section</div>
<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="<?php if($id!=''){echo $fetQuery['title'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title Arabic">Title Arabic</label>
<input type="text" name="title_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['title_ar'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading">Heading</label>
<input type="text" name="heading" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading Arabic">Heading Arabic</label>
<input type="text" name="heading_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading_ar'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Content">Content</label>
<textarea name="content" id="editor1"><?php if($id!=''){echo $fetQuery['content'];} ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Content Arabic">Content Arabic</label>
<textarea name="content_ar" id="editor2"><?php if($id!=''){echo $fetQuery['content_ar'];} ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading 1">Heading 1</label>
<input type="text" name="heading1" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading1'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading 1 Arabic">Heading 1 Arabic</label>
<input type="text" name="heading1_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading1_ar'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Content">Content</label>
<textarea name="content1" id="editor3"><?php if($id!=''){echo $fetQuery['content1'];} ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Content Arabic">Content Arabic</label>
<textarea name="content1_ar" id="editor4"><?php if($id!=''){echo $fetQuery['content1_ar'];} ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image1">Image 1</label>
<input type="file" name="image1" class="form-control" accept="image/*">
</div>
<?php
if(($id!='')){
echo'<img src="'.$base_url.'images/Upload/services/'.$fetQuery['image1'].'" class="my-2" style="width:100px;">';
}
?>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image2">Image 2</label>
<input type="file" name="image2" class="form-control" accept="image/*">
</div>
<?php
if(($id!='')){
echo'<img src="'.$base_url.'images/Upload/services/'.$fetQuery['image2'].'" class="my-2" style="width:100px;">';
}
?>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image3">Image 3</label>
<input type="file" name="image3" class="form-control" accept="image/*">
</div>
<?php
if(($id!='')){
echo'<img src="'.$base_url.'images/Upload/services/'.$fetQuery['image3'].'" class="my-2" style="width:100px;">';
}
?>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="icon">Icon</label>
<input type="file" name="icon" class="form-control" accept="image/*">
</div>
<?php
if(($id!='')){
echo'<img src="'.$base_url.'images/Upload/services/'.$fetQuery['icon'].'" class="my-2" style="width:100px;">';
}
?>
</div>
<div class="text-center bg-primary text-white fs-2 mb-3">FAQ Section</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title 1">Title 1</label>
<input type="text" name="title1" class="form-control" value="<?php if($id!=''){echo $fetQuery['title1'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title 1 Arabic">Title 1 Arabic</label>
<input type="text" name="title1_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['title1_ar'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading 2">Heading 2</label>
<input type="text" name="heading2" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading2'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Heading 2 Arabic">Heading 2 Arabic</label>
<input type="text" name="heading2_ar" class="form-control" value="<?php if($id!=''){echo $fetQuery['heading2_ar'];} ?>">
</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="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-secondary" href="show.php?page=serv">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 = str_replace("'", "\'", $_POST['title']);
$title_ar = str_replace("'", "\'", $_POST['title_ar']);
$heading = str_replace("'", "\'", $_POST['heading']);
$heading_ar = str_replace("'", "\'", $_POST['heading_ar']);
$content = str_replace("'", "\'", $_POST['content']);
$content_ar = str_replace("'", "\'", $_POST['content_ar']);
$title1 = str_replace("'", "\'", $_POST['title1']);
$title1_ar = str_replace("'", "\'", $_POST['title1_ar']);
$heading1 = str_replace("'", "\'", $_POST['heading1']);
$heading1_ar = str_replace("'", "\'", $_POST['heading1_ar']);
$content1 = str_replace("'", "\'", $_POST['content1']);
$content1_ar = str_replace("'", "\'", $_POST['content1_ar']);
$heading2 = str_replace("'", "\'", $_POST['heading2']);
$heading2_ar = str_replace("'", "\'", $_POST['heading2_ar']);
$status = str_replace("'", "\'", $_POST['status']);
$slug=create_url($title);
$file_name1=$_FILES['image1']['name'];
$file_name2=$_FILES['image2']['name'];
$file_name3=$_FILES['image3']['name'];
$file_name4=$_FILES['icon']['name'];
$addQry=mysqli_query($conn,
"INSERT `services_tbl` SET
`title` = '$title',
`title_ar` = '$title_ar',
`heading` = '$heading',
`heading_ar` = '$heading_ar',
`heading1` = '$heading1',
`heading1_ar` = '$heading1_ar',
`content` = '$content',
`content_ar` = '$content_ar',
`title1` = '$title1',
`title1_ar` = '$title1_ar',
`heading2` = '$heading2',
`heading2_ar` = '$heading2_ar',
`content1` = '$content1',
`content1_ar` = '$content1_ar',
`slug`='$slug',
`status`='$status'")or die(mysqli_error($conn));
$ido=mysqli_insert_id($conn);
if(!empty($file_name1)){
$file_tmp1=$_FILES['image1']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image1']['name'])));
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/services/".$new_file_name1;
move_uploaded_file($file_tmp1,$file_path1);
mysqli_query($conn,"UPDATE `services_tbl` SET `image1`='$new_file_name1' WHERE id='$ido'");
}
if(!empty($file_name2)){
$file_tmp2=$_FILES['image2']['tmp_name'];
$file_ext2=strtolower(end(explode('.',$_FILES['image2']['name'])));
$random_number2 = rand();
$new_file_name2 = $random_number2.'.'.$file_ext2;
$file_path2="../../images/Upload/services/".$new_file_name2;
move_uploaded_file($file_tmp2,$file_path2);
mysqli_query($conn,"UPDATE `services_tbl` SET `image2`='$new_file_name2' WHERE id='$ido'");
}
if(!empty($file_name3)){
$file_tmp3=$_FILES['image3']['tmp_name'];
$file_ext3=strtolower(end(explode('.',$_FILES['image3']['name'])));
$random_number3 = rand();
$new_file_name3 = $random_number3.'.'.$file_ext3;
$file_path3="../../images/Upload/services/".$new_file_name3;
move_uploaded_file($file_tmp3,$file_path3);
mysqli_query($conn,"UPDATE `services_tbl` SET `image3`='$new_file_name3' WHERE id='$ido'");
}
if(!empty($file_name4)){
$file_tmp4=$_FILES['icon']['tmp_name'];
$file_ext4=strtolower(end(explode('.',$_FILES['icon']['name'])));
$random_number4 = rand();
$new_file_name4 = $random_number4.'.'.$file_ext4;
$file_path4="../../images/Upload/services/".$new_file_name4;
move_uploaded_file($file_tmp4,$file_path4);
mysqli_query($conn,"UPDATE `services_tbl` SET `icon`='$new_file_name4' WHERE id='$ido'");
}
if($addQry){
echo "<script>window.location='show.php?page=serv';</script>";
$_SESSION['message']="Record Added successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$title = str_replace("'", "\'", $_POST['title']);
$title_ar = str_replace("'", "\'", $_POST['title_ar']);
$heading = str_replace("'", "\'", $_POST['heading']);
$heading_ar = str_replace("'", "\'", $_POST['heading_ar']);
$heading1 = str_replace("'", "\'", $_POST['heading1']);
$heading1_ar = str_replace("'", "\'", $_POST['heading1_ar']);
$content = str_replace("'", "\'", $_POST['content']);
$content_ar = str_replace("'", "\'", $_POST['content_ar']);
$title1 = str_replace("'", "\'", $_POST['title1']);
$title1_ar = str_replace("'", "\'", $_POST['title1_ar']);
$heading2 = str_replace("'", "\'", $_POST['heading2']);
$heading2_ar = str_replace("'", "\'", $_POST['heading2_ar']);
$content1 = str_replace("'", "\'", $_POST['content1']);
$content1_ar = str_replace("'", "\'", $_POST['content1_ar']);
$status = str_replace("'", "\'", $_POST['status']);
$slug=create_url($title);
$file_name1=$_FILES['image1']['name'];
$file_name2=$_FILES['image2']['name'];
$file_name3=$_FILES['image3']['name'];
$file_name4=$_FILES['icon']['name'];
if(!empty($file_name1)){
$file_tmp1=$_FILES['image1']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image1']['name'])));
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/services/".$new_file_name1;
$dlt1=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `services_tbl` WHERE id='$id'"));
$dlt_path1="../../images/Upload/services/".$dlt1['image1'];
unlink($dlt_path1);
mysqli_query($conn,"UPDATE `services_tbl` SET `image1`='$new_file_name1' WHERE id='$id'");
move_uploaded_file($file_tmp1,$file_path1);
}
if(!empty($file_name2)){
$file_tmp2=$_FILES['image2']['tmp_name'];
$file_ext2=strtolower(end(explode('.',$_FILES['image2']['name'])));
$random_number2 = rand();
$new_file_name2 = $random_number2.'.'.$file_ext2;
$file_path2="../../images/Upload/services/".$new_file_name2;
$dlt2=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `services_tbl` WHERE id='$id'"));
$dlt_path2="../../images/Upload/services/".$dlt2['image2'];
unlink($dlt_path2);
mysqli_query($conn,"UPDATE `services_tbl` SET `image2`='$new_file_name2' WHERE id='$id'");
move_uploaded_file($file_tmp2,$file_path2);
}
if(!empty($file_name3)){
$file_tmp3=$_FILES['image3']['tmp_name'];
$file_ext3=strtolower(end(explode('.',$_FILES['image3']['name'])));
$random_number3 = rand();
$new_file_name3 = $random_number3.'.'.$file_ext3;
$file_path3="../../images/Upload/services/".$new_file_name3;
$dlt3=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `services_tbl` WHERE id='$id'"));
$dlt_path3="../../images/Upload/services/".$dlt3['image3'];
unlink($dlt_path3);
mysqli_query($conn,"UPDATE `services_tbl` SET `image3`='$new_file_name3' WHERE id='$id'");
move_uploaded_file($file_tmp3,$file_path3);
}
if(!empty($file_name4)){
$file_tmp4=$_FILES['icon']['tmp_name'];
$file_ext4=strtolower(end(explode('.',$_FILES['icon']['name'])));
$random_number4 = rand();
$new_file_name4 = $random_number4.'.'.$file_ext4;
$file_path4="../../images/Upload/services/".$new_file_name4;
$dlt4=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `services_tbl` WHERE id='$id'"));
$dlt_path4="../../images/Upload/services/".$dlt4['icon'];
unlink($dlt_path4);
mysqli_query($conn,"UPDATE `services_tbl` SET `icon`='$new_file_name4' WHERE id='$id'");
move_uploaded_file($file_tmp4,$file_path4);
}
$editQry=mysqli_query($conn,"UPDATE `services_tbl` SET
`title` = '$title',
`title_ar` = '$title_ar',
`heading` = '$heading',
`heading_ar` = '$heading_ar',
`heading1` = '$heading1',
`heading1_ar` = '$heading1_ar',
`content` = '$content',
`content_ar` = '$content_ar',
`title1` = '$title1',
`title1_ar` = '$title1_ar',
`heading2` = '$heading2',
`heading2_ar` = '$heading2_ar',
`content1` = '$content1',
`content1_ar` = '$content1_ar',
`slug`='$slug',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=serv';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->