Server : LiteSpeed System : Linux in-mum-web1112.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u451330669 ( 451330669) PHP Version : 8.2.27 Disable Function : NONE Directory : /home/u451330669/domains/wecareindustry.in/public_html/admin/ |
<?php
require('top.inc.php');
$categories_id='';
$name='';
$meta_keyword='';
$meta_desc='';
$image='';
$meta_title='';
$short_desc ='';
$description='';
$msg='';
$image_required='required';
if(isset($_GET['id']) && $_GET['id']!=''){
$image_required='';
$id=get_safe_value($con,$_GET['id']);
$res=mysqli_query($con,"select * from product where id='$id'");
$check=mysqli_num_rows($res);
if($check>0){
$row=mysqli_fetch_assoc($res);
$categories_id=$row['categories_id'];
$name=$row['name'];
$meta_keyword=$row['meta_keyword'];
$meta_desc=$row['meta_desc'];
$meta_title=$row['meta_title'];
$short_desc=$row['short_desc'];
$description=$row['description'];
}else{
header('location:product.php');
die();
}
}
if(isset($_POST['submit'])){
$categories_id=get_safe_value($con,$_POST['categories_id']);
$name=get_safe_value($con,$_POST['name']);
$meta_desc=get_safe_value($con,$_POST['meta_desc']);
$meta_keyword=get_safe_value($con,$_POST['meta_keyword']);
$meta_title=get_safe_value($con,$_POST['meta_title']);
$short_desc=get_safe_value($con,$_POST['short_desc']);
$description=get_safe_value($con,$_POST['description']);
$res=mysqli_query($con,"select * from product where id='$id'");
$check=mysqli_num_rows($res);
if($check>0){
if(isset($_GET['id']) && $_GET['id']!=''){
$getData=mysqli_fetch_assoc($res);
if($id==$getData['id']){
}else{
$msg="Product already exist";
}
}else{
$msg="Product already exist";
}
}
if(isset($_GET['id']) && $_GET['id']==0){
if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/gif' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg' && $_FILES['image']['type']!='image/webp'){
$msg="Please select only gif,png,jpg and jpeg image formate";
}
}else{
if($_FILES['image']['type']!=''){
if($_FILES['image']['type']!='image/png'&& $_FILES['image']['type']!='image/gif' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg' && $_FILES['image']['type']!='image/webp'){
$msg="Please select only png,jpg and jpeg image formate";
}
}
}
if($msg==''){
if(isset($_GET['id']) && $_GET['id']!=''){
if($_FILES['image']['name']!=''){
$image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'],PRODUCT_IMAGE_SERVER_PATH.$image);
$update_sql="update product set categories_id='$categories_id', name='$name',meta_keyword='$meta_keyword',meta_desc='$meta_desc',short_desc='$short_desc',description='$description',image='$image',meta_title='$meta_title' where id='$id'";
}else{
$update_sql="update product set categories_id='$categories_id',name='$name',meta_keyword='$meta_keyword',meta_desc='$meta_desc',short_desc='$short_desc',description='$description',meta_title='$meta_title' where id='$id'";
}
mysqli_query($con,$update_sql);
}else{
$image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'],PRODUCT_IMAGE_SERVER_PATH.$image);
mysqli_query($con,"insert into product(categories_id,name,meta_keyword,meta_desc,short_desc,description,status,image,meta_title) values('$categories_id','$name','$meta_keyword','$meta_desc','$short_desc','$description',1,'$image','$meta_title')");
}
header('location:product.php');
die();
}
}
?>
<div class="content pb-0">
<div class="animated fadeIn">
<div class="row">
<div class="col-lg-12">
<div class="card">
<div class="card-header"><strong>News</strong><small> Form</small></div>
<form method="post" enctype="multipart/form-data">
<div class="card-body card-block">
<div class="form-group">
<label for="categories" class=" form-control-label">Categories</label>
<select class="form-control" name="categories_id">
<option>Select Category</option>
<?php
$res=mysqli_query($con,"select id,categories from categories order by categories asc");
while($row=mysqli_fetch_assoc($res)){
if($row['id']==$categories_id){
echo "<option selected value=".$row['id'].">".$row['categories']."</option>";
}else{
echo "<option value=".$row['id'].">".$row['categories']."</option>";
}
}
?>
</select>
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label">name</label>
<input type="text" name="name" placeholder="Enter Time" class="form-control" value="<?php echo $name?>">
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label">Image</label>
<input type="file" name="image" class="form-control" <?php echo $image_required?>>
</div>
<div class="form-group">
<label for="cname" class=" form-control-label">Short Description</label>
<textarea name="short_desc" placeholder="Enter product short description" class="form-control" ><?php echo $short_desc?></textarea>
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label" for="cname" >Description</label>
<textarea name="description" placeholder="Enter product description" class="form-control" ><?php echo $description?></textarea>
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label">meta_title</label>
<input type="text" name="meta_title" placeholder="Enter Time" class="form-control" value="<?php echo $meta_title?>">
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label">Meta_keyword</label>
<input type="text" name="meta_keyword" placeholder="Enter Time" class="form-control" value="<?php echo $meta_keyword?>">
</div>
<div class="form-group">
<label for="categories_id" class=" form-control-label">Meta_desc</label>
<input type="text" name="meta_desc" placeholder="Enter Time" class="form-control" value="<?php echo $meta_desc?>">
</div>
<button id="payment-button" name="submit" type="submit" class="btn btn-lg btn-info btn-block">
<span id="payment-button-amount">Submit</span>
</button>
<div class="field_error"><?php echo $msg?></div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<script>
function get_sub_cat(sub_cat_id){
var categories_id=jQuery('#categories_id').val();
jQuery.ajax({
url:'get_sub_cat.php',
type:'post',
data:'categories_id='+categories_id+'&sub_cat_id='+sub_cat_id,
success:function(result){
jQuery('#sub_categories_id').html(result);
}
});
}
</script>
<script src="https://cdn.ckeditor.com/4.5.1/standard/ckeditor.js"></script>
<script type="text/javascript">
CKEDITOR.editorConfig = function (config) {
config.language = 'es';
config.uiColor = '#F7B42C';
config.height = 300;
config.toolbarCanCollapse = true;
};
CKEDITOR.replace('description');
CKEDITOR.editorConfig = function (config) {
config.language = 'es';
config.uiColor = '#F7B42C';
config.height = 300;
config.toolbarCanCollapse = true;
};
CKEDITOR.replace('short_desc');
</script>
<?php
require('footer.inc.php');
?>
<script>
<?php
if(isset($_GET['id'])){
?>
get_sub_cat('<?php echo $sub_categories_id?>');
<?php } ?>
</script>