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/public_html/website_6ca89795/admin/ |
Upload File : |
<?php
include('header.php');
include('function.php');
include('../dbcon.php');
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$category_id = intval($_POST['category_id']);
$title = mysqli_real_escape_string($conn, $_POST['title']);
$page_title = mysqli_real_escape_string($conn, $_POST['page_title']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$keywords = mysqli_real_escape_string($conn, $_POST['keywords']);
$robots = mysqli_real_escape_string($conn, $_POST['robots']);
$canonical = mysqli_real_escape_string($conn, $_POST['canonical']);
$content = mysqli_real_escape_string($conn, $_POST['content']);
$price = mysqli_real_escape_string($conn, $_POST['price']);
$actual_price = mysqli_real_escape_string($conn, $_POST['actual_price']);
$stock = mysqli_real_escape_string($conn, $_POST['stock']);
$weight = mysqli_real_escape_string($conn, $_POST['weight']);
$is_featured = isset($_POST['is_featured']) ? 1 : 0;
$status = isset($_POST['status']) ? 1 : 0;
$titleslug = strtolower(
trim(
preg_replace('/[^A-Za-z0-9-]+/', '-', $title)
)
);
/* IMAGE UPLOAD */
$image = '';
$upload_dir = "dataimg/";
if (!file_exists($upload_dir)) {
mkdir($upload_dir, 0777, true);
}
if (!empty($_FILES['image']['name'])) {
$ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION);
$image = time() . rand(1111,9999) . '.' . $ext;
move_uploaded_file(
$_FILES['image']['tmp_name'],
$upload_dir . $image
);
}
/* INSERT QUERY */
$qry = "INSERT INTO areawecover
(
category_id,
title,
page_title,
description,
keywords,
robots,
canonical,
titleslug,
content,
price,
actual_price,
stock,
weight,
is_featured,
status,
image
)
VALUES
(
'$category_id',
'$title',
'$page_title',
'$description',
'$keywords',
'$robots',
'$canonical',
'$titleslug',
'$content',
'$price',
'$actual_price',
'$stock',
'$weight',
'$is_featured',
'$status',
'$image'
)";
$run = mysqli_query($conn, $qry);
if (!$run) {
echo "DB Error : " . mysqli_error($conn);
} else {
echo "success";
}
exit;
}
/* CATEGORY */
$categoryQuery = mysqli_query(
$conn,
"SELECT * FROM arawecovercategory ORDER BY category ASC"
);
?>
<!DOCTYPE html>
<html>
<head>
<title>Add Area We Cover</title>
<link rel="stylesheet"
href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://cdn.ckeditor.com/4.22.1/standard/ckeditor.js"></script>
</head>
<body>
<div class="container mt-4">
<div class="card shadow">
<div class="card-header bg-primary text-white">
<h3 class="mb-0">Add Product</h3>
</div>
<div class="card-body">
<form id="uploadForm" enctype="multipart/form-data">
<div class="row">
<div class="col-md-6 mb-3">
<label>Category</label>
<select name="category_id"
class="form-control"
required>
<option value="">Select Category</option>
<?php
while($row=mysqli_fetch_assoc($categoryQuery))
{
?>
<option value="<?= $row['id']; ?>">
<?= $row['category']; ?>
</option>
<?php
}
?>
</select>
</div>
<div class="col-md-6 mb-3">
<label>Title</label>
<input type="text"
name="title"
class="form-control"
required>
</div>
<div class="col-md-6 mb-3">
<label>Page Title</label>
<input type="text"
name="page_title"
class="form-control">
</div>
<div class="col-md-6 mb-3">
<label>Keywords</label>
<input type="text"
name="keywords"
class="form-control">
</div>
<div class="col-md-6 mb-3">
<label>Robots</label>
<input type="text"
name="robots"
class="form-control"
value="index,follow">
</div>
<div class="col-md-6 mb-3">
<label>Canonical URL</label>
<input type="text"
name="canonical"
class="form-control">
</div>
<div class="col-md-12 mb-3">
<label>Description</label>
<textarea name="description"
class="form-control"
rows="3"></textarea>
</div>
<div class="col-md-4 mb-3">
<label>Price</label>
<input type="number"
name="price"
class="form-control"
value="0">
</div>
<div class="col-md-4 mb-3">
<label>Actual Price</label>
<input type="number"
name="actual_price"
class="form-control"
value="0">
</div>
<div class="col-md-4 mb-3">
<label>Stock</label>
<input type="number"
name="stock"
class="form-control"
value="0">
</div>
<div class="col-md-4 mb-3">
<label>Weight</label>
<input type="text"
name="weight"
class="form-control">
</div>
<div class="col-md-6 mb-3">
<label>Main Image</label>
<input type="file"
name="image"
class="form-control"
accept="image/*"
onchange="previewImage(this)">
</div>
<div class="col-md-6 mb-3">
<label>Preview</label>
<div id="preview"></div>
</div>
<div class="col-md-6 mb-3">
<div class="form-check">
<input type="checkbox"
name="is_featured"
value="1"
class="form-check-input">
<label class="form-check-label">
Featured
</label>
</div>
</div>
<div class="col-md-6 mb-3">
<div class="form-check">
<input type="checkbox"
name="status"
value="1"
checked
class="form-check-input">
<label class="form-check-label">
Active
</label>
</div>
</div>
<div class="col-md-12 mb-3">
<label>Content</label>
<textarea id="content"
name="content"></textarea>
</div>
<div class="col-md-12">
<div class="progress mb-3">
<div id="progressBar"
class="progress-bar"
role="progressbar"
style="width:0%">
0%
</div>
</div>
</div>
<div class="col-md-12">
<button type="submit"
class="btn btn-success btn-lg">
Save Data
</button>
</div>
</div>
</form>
</div>
</div>
</div>
<script>
CKEDITOR.replace('content');
function previewImage(input)
{
if(input.files && input.files[0])
{
let reader = new FileReader();
reader.onload = function(e)
{
document.getElementById("preview").innerHTML =
'<img src="'+e.target.result+'" width="120" class="img-thumbnail">';
}
reader.readAsDataURL(input.files[0]);
}
}
document.getElementById("uploadForm").addEventListener("submit", function(e){
e.preventDefault();
for(instance in CKEDITOR.instances)
{
CKEDITOR.instances[instance].updateElement();
}
let formData = new FormData(this);
let xhr = new XMLHttpRequest();
xhr.open("POST","",true);
xhr.upload.onprogress = function(e)
{
if(e.lengthComputable)
{
let percent = Math.round((e.loaded/e.total)*100);
let bar = document.getElementById("progressBar");
bar.style.width = percent + "%";
bar.innerHTML = percent + "%";
}
}
xhr.onload = function()
{
if(xhr.responseText.trim() == "success")
{
alert("Data Added Successfully");
location.reload();
}
else
{
alert(xhr.responseText);
}
}
xhr.send(formData);
});
</script>
<div class="content-backdrop fade"></div>
</div>
<!-- Content wrapper -->
</div>
<!-- / Layout page -->
</div>
</div>
<!-- / Layout wrapper -->
<!-- Core JS -->
<!-- build:js assets/vendor/js/core.js -->
<script src="../assets/vendor/libs/jquery/jquery.js"></script>
<script src="../assets/vendor/libs/popper/popper.js"></script>
<script src="../assets/vendor/js/bootstrap.js"></script>
<script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>
<script src="../assets/vendor/js/menu.js"></script>
<!-- endbuild -->
<!-- Vendors JS -->
<!-- Main JS -->
<script src="../assets/js/main.js"></script>
<!-- Page JS -->
<!-- Place this tag in your head or just before your close body tag. -->
<script async defer src="https://buttons.github.io/buttons.js"></script>
</body>
</html>