Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory : /home/u615232177/domains/debutlers.com/public_html/admin4985/ |
<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
include("headerstrict.php"); ?>
<title><?php echo $company_name; ?>, Admin, Menu</title>
<?php
if (isset($_POST['add_category'])) {
$category_name = mysqli_real_escape_string($con,$_POST['category_name']);
$featured = mysqli_real_escape_string($con,$_POST['featured']);
if( ($_FILES["fileField"]["type"]=="") == false ){
$random_id = substr(md5(rand()), 0, 20);
$extension = pathinfo($_FILES["fileField"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField']['tmp_name'], "../site_img/menu_category/$random_id.$extension");
$picture ="$random_id.$extension";
}
else{$picture="";}
$db_id=0;
$stmt = $con -> prepare('INSERT INTO menu_categories VALUES (?,?,?,?)');
$stmt -> bind_param('isss', $db_id,$category_name,$picture,$featured);
$stmt -> execute();
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Item successfully added.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
}
?>
<!-- ======= Breadcrumbs ======= -->
<section id="breadcrumbs" class="breadcrumbs">
<div class="container"> </div>
</section>
<!-- End Breadcrumbs -->
<!-- ======= Contact Section ======= -->
<section id="contact" class="contact inner-page">
<div class="container" data-aos="fade-up">
<div class="section-title">
<h2>Menu</h2>
<p>Add a Menu Category</p>
</div>
<div class="row">
<div class="col-lg-6 mt-5 mt-lg-0 d-flex align-items-stretch">
<form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post" class="php-email-form1" enctype='multipart/form-data'>
<div class='validate'><?php echo $error; ?></div>
<div class="form-row">
<div class="form-group col-md-12">
<input type="text" name="category_name" class="form-control" placeholder="Name of Category" required />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-12">
<select class='form-control' name='featured' required>
<option value=''>Set as Featured</option>
<option value='Yes'>Yes</option>
<option value='No'>No</option>
</select>
</div>
</div>
<div class="form-row">
<div class="form-group col-md-12">
<input type='file' name='fileField' class="form-control" required />
</div>
</div>
<div class="text-center">
<button type="submit" name='add_category'>Save</button>
</div>
</form>
</div>
<div class="col-lg-6 d-flex align-items-stretch">
</div>
</div><!-- end row -->
<br/></br>
<div class="section-title">
<p>Uploaded Menu Categories</p>
</div>
<div class='row'>
<?php
$stmt = $con -> prepare('SELECT * FROM menu_categories');
$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($id,$category_name,$picture,$featured);
$numrows = $stmt -> num_rows();
if($numrows > 0){
while ($stmt -> fetch()) {
echo"
<div class='col-md-4'>
<form action='";?><?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?><?php echo"' method='post'class='php-email-form1'enctype='multipart/form-data'>
<div class='form-row'>
<div class='form-group col-md-12'>
<label>Category name</label>
<input type='text' name='category_name' class='form-control' placeholder='Name of Category' value='$category_name' required />
</div>
</div>
<div class='form-row'>
<div class='form-group col-md-12'>
<label>Featured</label>
<select class='form-control' name='featured' required>
<option selected value='$featured'>$featured</option>
<option value='Yes'>Yes</option>
<option value='No'>No</option>
</select>
</div>
</div>
<div class='form-row'>
<div class='form-group col-md-12'>
<label>Image</label>
<img style='width:100%;border-radius:5px;'src='../site_img/menu_category/$picture' class='img-fluid' alt=''>
<input type='file' name='fileField' class='form-control'/>
</div>
</div>
<div class='text-center'>
<button type='submit' name='update$id'>Update</button>
<button type='submit' name='delete$id'>Delete</button>
</div>
</form>
</div>
";
if (isset($_POST["update$id"])) {
$category_name = mysqli_real_escape_string($con,$_POST['category_name']);
$featured = mysqli_real_escape_string($con,$_POST['featured']);
if( ($_FILES["fileField"]["type"]=="") == false ){
unlink("../site_img/menu_category/$picture");
$random_id = substr(md5(rand()), 0, 20);
$extension = pathinfo($_FILES["fileField"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField']['tmp_name'], "../site_img/menu_category/$random_id.$extension");
$picture ="$random_id.$extension";
}
$stmt = $con -> prepare('UPDATE menu_categories SET category_name = ?,picture = ?,featured = ? WHERE id = ?');
$stmt -> bind_param('sssi', $category_name,$picture,$featured,$id);
$stmt -> execute();
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Update was successfully done.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
}
if (isset($_POST["delete$id"])) {
$stmt = $con -> prepare('DELETE FROM menu_categories WHERE id = ?');
$stmt -> bind_param('i', $id);
$stmt -> execute();
unlink("../site_img/menu_category/$picture");
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Category successfully deleted.";
echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=$page_name&m=$message\">";
}
}
}
?>
</div>
</div>
</section><!-- End Contact Section -->
<?php include("footer.php"); ?>