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_7c8ed5ef/admin/manage_projects/ |
Upload File : |
<?php
error_reporting(0);
include("../function.php");
if ($_SESSION['admin_id'] == "") {
header('location:../login.php');
}
$service_tbl = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM admin WHERE admin_id='" . $_SESSION['admin_id'] . "'"));
// Sidebar strat
include('../include/sidebar.php');
// Sidebar wrap
/*error_reporting(E_ALL);
ini_set('display_errors',1)*/
ini_set('display_startup_errors', 1);
ini_set('display_errors', 1);
error_reporting(E_ALL);
?>
<?php
if (isset($_POST['add']) && $_POST['add'] == 'Add') {
$title = $_POST['title'];
$title = str_replace("'", "\'", $title);
$content1 = $_POST['content1'];
$content1 = str_replace("'", "\'", $content1);
$content1_atb = $_POST['content1_atb'];
$content1_atb = str_replace("'", "\'", $content1_atb);
$status = $_POST['status'];
$file_name = $_FILES['image1']['name'];
$file_tmp = $_FILES['image1']['tmp_name'];
$file_ext = strtolower(end(explode('.', $_FILES['image1']['name'])));
$random_number = rand();
$new_file_name = $random_number . '.' . $file_ext;
$file_path = "../../images/Upload/Projects/" . $new_file_name;
move_uploaded_file($file_tmp, $file_path);
$addQry = mysqli_query($conn, "INSERT `project_tbl` SET
`title`='$title',
`content1`='$content1',
`content1_atb`='$content1_atb',
`image1`='$new_file_name',
`status`='$status'") or die(mysqli_error($conn));
$product_id = mysqli_insert_id($conn);
$update_slug = create_url($title) . $product_id;
$UpdateSlugQry = mysqli_query($conn, "UPDATE `project_tbl` SET `slug`='$update_slug' WHERE id='" . $product_id . "'");
// Handle adding new content to project_content_atb_tbl
if (isset($_POST['content_atb']) && is_array($_POST['content_atb'])) {
foreach ($_POST['content_atb'] as $key => $val) {
// Sanitize the content to prevent SQL injection
$content_atb = mysqli_real_escape_string($conn, $val);
// Insert query
$insertQuery = "INSERT INTO `project_content_atb_tbl` (`project_id`, `content_atb`) VALUES ('$product_id', '$content_atb')";
// Execute the query
if (!mysqli_query($conn, $insertQuery)) {
die("Error inserting new image: " . mysqli_error($conn));
}
}
}
echo "<script>window.location='show.php?page=proj';</script>";
$_SESSION['message'] = "Service Insert successfully";
}
?>
<!-- [ 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-light text-white fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Add Projects</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['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['error'] . '</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']);
?>
<form method="POST" name="reg" enctype="multipart/form-data" autocomplete="off">
<div class="container">
<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">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Title">Content1</label>
<textarea rows="3" name="content1" class="form-control"></textarea>
</div>
</div>
<div class="gap-2" id="input-container">
<div class="row">
<div class="col-lg-10">
<h5>Content Atb</h5>
<textarea rows="3" name="content1_atb" class="form-control" id="content_atb"></textarea>
</div>
<div class="col-lg-2">
<h5>Add Content Atb</h5>
<a id="myButton" class="bg-success form-control text-center text-white fw-bold mt-1 mb-2">Add More</a>
</div>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label for="image" class=" form-control-label mb-2">Image</label>
<input type="file" name="image1" class="form-control">
<p id="error1" style="color:red; display:none;">File Must be JPEG,JPG,PNG,SVG</p>
<p id="error2" style="color:red; display:none;">File Must be lessthan 20MB</p>
</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="">Please select status</option>
<option value="1">Show</option>
<option value="0">Hide</option>
</select>
</div>
</div>
<div class="col-md-12 mt-2">
<div class="form-group">
<input type="submit" name="add" class="btn btn-success" value="Add">
<a class="text-white btn btn-dark " href="show.php?page=service">Back</a>
</div>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<!-- Required Js -->
<?php include('../include/footer.php'); ?>
<script>
$(document).ready(function() {
$("#myButton").click(function() {
$.ajax({
url: "insert_input.php",
success: function(html) {
$("#input-container").append(html);
}
});
});
});
$(document).on("click", ".remove-input", function() {
$(this).closest(".input-element").remove();
});
// $(document).ready(function() {
// $('.delete-btn').on('click', function() {
// var itemId = $(this).data('id');
// var deleteButton = $(this);
// $.ajax({
// url: 'delete_product.php',
// method: 'POST',
// data: { id: itemId },
// success: function(response) {
// // Handle the response from the server
// console.log(response);
// // Remove the deleted data from the DOM
// deleteButton.closest('.data-item').remove();
// },
// error: function(xhr, status, error) {
// // Handle the error
// console.log(error);
// }
// });
// });
// });
</script>