|
Server IP : 2a02:4780:11:1017:0:31f1:b895:8 / Your IP : 216.73.216.163 Web Server : LiteSpeed System : Linux in-mum-web917.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u837925013 ( 837925013) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u837925013/domains/tech2wizard.com/public_html/admin/export/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$page='store';
$page1='';
include('inc/sidebar.php') ;
if(isset($_GET['edit'])){
$get_store= "select * from store WHERE id='".$_GET['edit']."'";
$query=mysqli_query($con,$get_store);
$store_data=mysqli_fetch_array($query);
}
if(isset($_REQUEST['datafrmSubmit'])){
if($_REQUEST['datafrmSubmit'] == 'Submit'){
$date=date("Y-m-d h:i:s");
$location = 'uploads/store/';
date_default_timezone_set("Asia/Kolkata");
$res=mysqli_query($con,"select * from store where slug='".$_REQUEST['slug']."'");
if(mysqli_num_rows($res)>0){
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>Slug Alreay Added<i class="fa fa-close"id="close"></i>
</div>
</div>';
}else{
$sql_insert = "insert into store set gallery = '".$store_image."',title = '".str_replace("'", "\'", $_REQUEST['title'])."',dsc = '".str_replace("'", "\'", $_REQUEST['dsc'])."',slug = '".$_REQUEST['slug']."',address = '".str_replace("'", "\'", $_REQUEST['address'])."',state = '".$_REQUEST['state']."',city = '".$_REQUEST['city']."',zip = '".$_REQUEST['zip']."',whatsapp = '".$_REQUEST['whatsapp']."',phone = '".$_REQUEST['phone']."',email = '".$_REQUEST['email']."',map = '".$_REQUEST['map']."',hours = '".str_replace("'", "\'", $_REQUEST['hours'])."', date = '$date',status = '1'";
$query_insert = mysqli_query($con, $sql_insert);
$store_id=mysqli_insert_id($con);
foreach($_FILES['img']['name'] as $id=>$val){
$fileName = $_FILES['img']['name'][$id];
$tempLocation = $_FILES['img']['tmp_name'][$id];
$targetFilePath = $location . $fileName;
$fileType = strtolower(pathinfo($targetFilePath, PATHINFO_EXTENSION));
move_uploaded_file($tempLocation, $targetFilePath);
$sqlVal = "('".$store_id."', '".$fileName."')";
if(!empty($fileName)) {
$insert = $con->query("INSERT INTO `store_image` (`store_id`, `image`) VALUES $sqlVal");
}
}
if($query_insert){
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>store Added.<i class="fa fa-close"id="close"></i>
</div>
</div>';
echo "<script type='text/javascript'>window.location=\"store.php\";</script>";
}
}
}
if($_REQUEST['datafrmSubmit'] == 'Update'){
$dsc=$_REQUEST['dsc'];
$location = 'uploads/store/';
date_default_timezone_set("Asia/Kolkata");
$res=mysqli_query($con,"select * from store where slug='".$_REQUEST['slug']."' AND id!='".$_GET['edit']."'");
if(mysqli_num_rows($res)>0){
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>Slug Alreay Added<i class="fa fa-close"id="close"></i>
</div>
</div>';
}else{
$sql_insert = "UPDATE store set title = '".str_replace("'", "\'", $_REQUEST['title'])."',dsc = '".str_replace("'", "\'", $_REQUEST['dsc'])."',slug = '".$_REQUEST['slug']."',address = '".str_replace("'", "\'", $_REQUEST['address'])."',state = '".$_REQUEST['state']."',city = '".$_REQUEST['city']."',zip = '".$_REQUEST['zip']."',whatsapp = '".$_REQUEST['whatsapp']."',phone = '".$_REQUEST['phone']."',email = '".$_REQUEST['email']."',map = '".$_REQUEST['map']."',hours = '".str_replace("'", "\'", $_REQUEST['hours'])."' WHERE ID='".$_GET['edit']."'";
$query_insert = mysqli_query($con, $sql_insert);
if(!empty($_FILES['img']['name'])){
foreach($_FILES['img']['name'] as $id=>$val){
$fileName = $_FILES['img']['name'][$id];
$tempLocation = $_FILES['img']['tmp_name'][$id];
$targetFilePath = $location . $fileName;
$fileType = strtolower(pathinfo($targetFilePath, PATHINFO_EXTENSION));
move_uploaded_file($tempLocation, $targetFilePath);
$sqlVal = "('".$_GET['edit']."', '".$fileName."')";
if(!empty($fileName)) {
$insert = $con->query("INSERT INTO `store_image` (`store_id`, `image`) VALUES $sqlVal");
}
}
}
if($query_insert){
echo'<div id="hide-toast"class="toast" role="success" aria-live="assertive" aria-atomic="true">
<div class="toast-body success">
<i class="fa fa-warning"></i>store Updated.<i class="fa fa-close"id="close"></i>
</div>
</div>';
echo "<script type='text/javascript'>window.location=\"store.php\";</script>";
}
}
}
}
?>
<!-- navbar-wrapper start -->
<div class="body-wrapper">
<div class="bodywrapper__inner">
<div class="row align-items-center mb-30 justify-content-between">
<div class="col-lg-4 col-sm-6">
<h6 class="page-title">Add store</h6>
</div>
<div class="col-lg-8 col-sm-6 text-sm-right mt-sm-0 mt-3 right-part">
<div class="d-flex flex-wrap justify-content-end flex-gap-8">
<a type="button"href="store.php" class="btn btn--primary"style="height: 38px;"><i class="fa fa-plus"></i>Go Back</a>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 mb-30">
<div class="card">
<div class="card-body">
<form method="post" action="" name="datafrm" id="datafrm" enctype="multipart/form-data">
<input type="hidden" name="_token" value="F3hYZRLH4v3C9Ru6ljqKNSmfRwKJx6eXLvbIf74y" /> <input type="hidden" name="type" value="element" />
<div class="form-row">
<div class="col-md-4">
<input type="hidden" name="has_image[]" value="1" />
<div class="form-group">
<label>Cover Image</label>
<div class="image-upload">
<div class="thumb">
<div class="avatar-preview">
<div class="profilePicPreview" >
<button type="button" class="remove-image"><i class="fa fa-times"></i></button>
</div>
</div>
<div class="avatar-edit">
<input type="file" class="profilePicUpload" value=""name="img[]" id="profilePicUpload0" accept=".png, .jpg, .jpeg" multiple/>
<label for="profilePicUpload0" class="bg--primary">Image</label>
<small class="mt-2 text-facebook">
Supported files: <b>jpeg, jpg, png</b>
</small>
</div>
</div>
</div>
</div>
<div class="image-show">
<div class="row">
<?php
$gallery= $con ->query("SELECT * FROM store_image Where store_id='".$store_data['id']."'");
while($gallery_data = $gallery ->fetch_assoc()){
?>
<div class="col-md-6 mt-20">
<div onclick="dell_gallery('<?php echo $gallery_data['id']; ?>','del')" class="gallery_remove">REMOVE</div>
<img src="<?php echo STORE_SITE_PATH.$gallery_data['image']; ?>" alt="image" />
</div>
<?php } ?>
</div>
</div>
</div>
<div class="col-md-8">
<div class="col-md-12">
<div class="form-group">
<label>Title</label>
<input type="text" class="form-control" placeholder="Title" name="title" id="title" value="<?php if(isset($store_data)){echo $store_data['title']; } ?>" required="" />
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Slug</label>
<input type="text" class="form-control" placeholder="slug" name="slug" id="slug" value="<?php if(isset($store_data)){echo $store_data['slug'];} ?>" required=""/>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Store Address</label>
<input type="text" class="form-control" placeholder="Store Address" name="address" id="address" value="<?php if(isset($store_data)){echo $store_data['address']; } ?>" required="" />
</div>
</div>
<div class="col-md-12">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Store State</label>
<select class="form-control" name="state"id="stateID" required="">
<option value="">Select State</option>
<?php
$sql_states= mysqli_query($con,"SELECT * FROM `states` ORDER BY state_id ASC");
while($states_data= mysqli_fetch_array($sql_states))
{
?>
<option value="<?php echo $states_data['state_id'] ?>" <?php if($states_data['state_id']==$store_data['state']){ echo 'selected'; } ?>><?php echo $states_data['state_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Store City</label>
<select class="form-control" name="city"id="cityID" required="">
<option value="">Select State First</option>
<?php
$sql_city= mysqli_query($con,"SELECT * FROM `cities` WHERE state_id='".$store_data['state']."' ORDER BY city_id ASC");
while($city_data= mysqli_fetch_array($sql_city))
{
?>
<option value="<?php echo $city_data['city_id'] ?>" <?php if($city_data['city_id']==$store_data['city']){ echo 'selected'; } ?>><?php echo $city_data['city_name'] ?></option>
<?php } ?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Store Zip</label>
<input type="number" class="form-control" placeholder="Store Zip" name="zip" id="zip" value="<?php if(isset($store_data)){echo $store_data['zip']; } ?>" required="" />
</div>
</div>
</div>
</div>
<div class="col-md-12">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Whatsapp Number</label>
<input type="number" class="form-control" placeholder="Whatsapp Number" name="whatsapp" id="whatsapp" value="<?php if(isset($store_data)){echo $store_data['whatsapp']; } ?>" required="" />
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Contact Number</label>
<input type="number" class="form-control" placeholder="Contact Number" name="phone" id="phone" value="<?php if(isset($store_data)){echo $store_data['phone']; } ?>" required="" />
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label>Store Email</label>
<input type="email" class="form-control" placeholder="Store Email" name="email" id="email" value="<?php if(isset($store_data)){echo $store_data['email']; } ?>" required="" />
</div>
</div>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Store MAP</label>
<textarea name="map"required class=""><?php if(isset($store_data)){ echo $store_data['map'];} ?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Store Hours</label>
<textarea name="hours"required class="summernote"><?php if(isset($store_data)){ echo $store_data['hours'];} ?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Description</label>
<textarea name="dsc"required class="summernote"><?php if(isset($store_data)){ echo $store_data['dsc'];} ?></textarea>
</div>
</div>
</div>
</div>
<div class="form-group">
<button type="submit" name="datafrmSubmit" id="datafrmSubmit"value="<?php if(isset($_GET['edit']))
{ echo 'Update'; }else{ echo 'Submit'; } ?>"class="btn btn--primary btn-block btn-lg"><?php if(isset($_GET['edit']))
{ echo 'Update'; }else{ echo 'Submit'; } ?></button>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- bodywrapper__inner end -->
</div>
<!-- body-wrapper end -->
</div>
<!-- body-wrapper end -->
</div>
<!-- jQuery library -->
<script>
jQuery('#title').change(function(){
jQuery('#result').html('');
var title=jQuery('#title').val();
jQuery.ajax({
url:'inc/get-store-slug.php',
type:'post',
data:'title='+title,
success:function(result){
// jQuery('#slug').val(result);
var trimStr = $.trim(result);
jQuery('#slug').val(trimStr);
}
});
});
</script>
<script>
$(document).ready(function() {
$('#stateID').on('change', function() {
var state_id = this.value;
$.ajax({
url: "inc/fetch-city.php",
type: "POST",
data: {
state_id: state_id
},
cache: false,
success: function(result){
$("#cityID").html(result);
}
});
});
});
</script>
<script>
function dell_gallery(pid,type){
jQuery.ajax({
url:'inc/DelGallery.php',
type:'post',
data:'pid='+pid+'&type='+type,
success:function(result){
window.location.reload();
}
});
}
</script>
<?php include('inc/footer.php') ?>