Viewing file:  add-service.php (8.35 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include 'conn.php';
require_once "auth.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title><?php include('title.php') ?></title>
<link rel="shortcut icon" type="image/png" href="images/fav.png">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/themify-icons.css">
<link rel="stylesheet" href="css/animate.css">
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="css/red.css" id="style_theme">
<link rel="stylesheet" href="css/responsive.css">
<link rel="stylesheet" href="charts/css/morris.css">
<link rel="stylesheet" href="css/jquery-jvectormap.css">
<link rel="stylesheet" href="datatable/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="plugins/summernote/summernote-bs4.css">
<script src="js/modernizr.min.js"></script>
</head>
<body>
<!-- Pre Loader -->
<div class="loading">
<div class="spinner">
<div class="double-bounce1"></div>
<div class="double-bounce2"></div>
</div>
</div>
<!--/Pre Loader -->
<div class="wrapper">
<!-- Sidebar -->
<?php include('sidebar.php') ?>
<!-- /Sidebar -->
<!-- Page Content -->
<div id="content">
<div>
<?php include('topbar.php') ?>
</div>
<?php
$ser_result = mysqli_query($con,"SELECT * FROM service");
$roww = mysqli_fetch_array($ser_result);
if (isset($_POST['add_service'])) {
$ser_title = mysqli_real_escape_string($con, $_POST['ser_title']);
$ser_descrip = substr($_POST['ser_descrip'], 0, 7000);
$ser_title_fa = mysqli_real_escape_string($con, $_POST['ser_title_fa']);
$ser_descrip_fa = substr($_POST['ser_descrip_fa'], 0, 7000);
// Handle uploaded images
$ser_image = handleUploadedImage('ser_image', 'images/service/');
$ser_icon = handleUploadedImage('ser_icon', 'images/service/');
$query = "INSERT INTO service (ser_title, ser_descrip, ser_image, ser_icon, ser_title_fa, ser_descrip_fa) VALUES (?, ?, ?, ?, ?, ?)";
$stmt = mysqli_prepare($con, $query);
if ($stmt) {
mysqli_stmt_bind_param($stmt, "ssssss", $ser_title, $ser_descrip, $ser_image, $ser_icon, $ser_title_fa, $ser_descrip_fa);
$inserted = mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);
if ($inserted) {
echo "<script>alert('Added Successfully');</script>";
echo "<script>window.location.href = 'add-service.php'</script>";
} else {
echo "Error: " . mysqli_error($con);
}
} else {
echo "Error in preparing the SQL statement: " . mysqli_error($con);
}
}
function handleUploadedImage($fileInputName, $targetDirectory)
{
$uploadedFile = $_FILES[$fileInputName];
$newFileName = '';
if ($uploadedFile['name']) {
$newFileName = rand() . $uploadedFile['name'];
$tempName = $uploadedFile['tmp_name'];
$folder = $targetDirectory . $newFileName;
move_uploaded_file($tempName, $folder);
}
return $newFileName;
}
if (isset($_GET['delete_id'])) {
// Retrieve the service information before deletion
$query_select = "SELECT ser_image, doc_image, ser_icon FROM service WHERE id='" . $_GET['delete_id'] . "'";
$result = mysqli_query($con, $query_select);
$row = mysqli_fetch_assoc($result);
// Delete the service from the database
$query_delete = "DELETE FROM service WHERE id='" . $_GET['delete_id'] . "'";
$p = mysqli_query($con, $query_delete);
// Remove the associated photos from the server path
if ($row['ser_image'] != 'default.jpg') {
$ser_image_path = "images/service/" . $row['ser_image'];
if (file_exists($ser_image_path)) {
unlink($ser_image_path);
}
}
if ($row['doc_image'] != 'default.jpg') {
$doc_image_path = "images/service/" . $row['doc_image'];
if (file_exists($doc_image_path)) {
unlink($doc_image_path);
}
}
if ($row['ser_icon'] != 'default-icon.jpg') {
$ser_icon_path = "images/service/" . $row['ser_icon'];
if (file_exists($ser_icon_path)) {
unlink($ser_icon_path);
}
}
echo "<script>alert('Deleted Successfully');</script>
<script>window.location.href = 'add-service.php'</script>";
}
?>
<div class="row no-margin-padding">
<div class="col-md-6">
<h3 class="block-title">Add New service / اضافه کردن خدمات</h3>
</div>
<div class="col-md-6">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.php">
<span class="ti-home"></span>
</a>
</li>
<li class="breadcrumb-item">Add service</li>
</ol>
</div>
</div>
<section class="content">
<div class="row justify-content-center">
<div class="col-md-12">
<form action="" method="post" enctype="multipart/form-data">
<div style="width: 1000px;">
<div class="card card-outline card-info">
<div class="card-header">
</div>
<div class="card-header">
<div class="form-group">
<label>Service Title</label>
<input name="ser_title" type="text" class="form-control" placeholder="Enter service title" required>
</div>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="ser_title_fa" dir="rtl" style="text-align: right; padding-right: 40px;" >نام خدمات:</label>
<input type="text" class="form-control" id="ser_title_fa" name="ser_title_fa" placeholder="نام خدمات را به فارسی وارد کنید" required>
</div>
<div class="card-header">
<div class="form-group">
<label>Service Description</label>
<textarea name="ser_descrip" class="textarea" placeholder="Enter service description" style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
</div>
<div class="form-group" dir="rtl" style="text-align: right;">
<label for="ser_descrip_fa" dir="rtl" style="text-align: right; padding-right: 40px;" >جزئیات خدمات را وارد کنید </label>
<div class="mb-3">
<textarea name="ser_descrip_fa" class="textarea" placeholder=" جزئیات خدمات را به فارسی وارد کنید"
style="width: 100%; height: 200px; font-size: 14px; line-height: 18px; border: 1px solid #dddddd; padding: 10px;"></textarea>
</div>
<div class="card-header">
<div class="form-group">
<label>Service Image</label>
<input name="ser_image" type="file" required>
</div>
</div>
<div class="card-header">
<div class="form-group">
<label>Service Icon</label>
<input name="ser_icon" type="file" required>
</div>
</div>
<button type="submit" name="add_service" class="btn btn-block btn-primary btn-lg">Add Service</button>
</div>
</div>
</form>
</div>
</div>
</section>
<!-- /Main Content -->
</div>
<!-- /Page Content -->
</div>
<!-- Back to Top -->
<a id="back-to-top" href="#" class="back-to-top">
<span class="ti-angle-up"></span>
</a>
<script src="plugins/jquery/jquery.min.js"></script>
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="dist/js/adminlte.min.js"></script>
<script src="dist/js/demo.js"></script>
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<script>
$(function () {
$('.textarea').summernote()
})
</script>
<!-- Popper Library-->
<script src="js/popper.min.js"></script>
<!-- Bootstrap Library-->
<script src="js/bootstrap.min.js"></script>
<!-- Datatable -->
<script src="datatable/jquery.dataTables.min.js"></script>
<script src="datatable/dataTables.bootstrap4.min.js"></script>
<!-- Custom Script-->
<script src="js/custom.js"></script>
</body>
</html>
|