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/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']); 
include("headerstrict.php"); ?>
<title><?php echo $company_name; ?>, Admin, Swimming-pool Meal Details</title>
<?php
if (isset($_GET['u'])){
	$id = mysqli_real_escape_string($con,$_GET['u']);
	$stmt = $con -> prepare('SELECT * FROM swimming_pool WHERE id=?');
	$stmt -> bind_param('s',$id);
	$stmt -> execute(); 
	$stmt -> store_result(); 
	$stmt -> bind_result($id,$category_name_db,$name,$description,$price,$picture);
	$numrows = $stmt -> num_rows();
	if($numrows > 0){
	while ($stmt -> fetch()) { }
	}
	
}
else{echo "<meta http-equiv=\"refresh\" content=\"0; url=adminhome.php\">";exit();}
?>
<!-- ======= 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><?php echo $name; ?></h2>
		<p></p>
	</div>
	
	
        <div class="row">
		<div class='col-md-2'></div>
		<?php
		echo"			
		<div class='col-md-8'>
		<form action='swimming_pool_details.php?u=$id' method='post' enctype='multipart/form-data' class='php-email-form1'>
		<h2>Meal Details</h2>
			<div class='form-row'>
                <div class='form-group col-md-12'>
					<input type='text' name='name' class='form-control' placeholder='Name' value='$name' required /> 
                </div>
				<div class='form-group col-md-12'>
					<select name='category' class='form-control' required>
					<option value='$category_name_db'>$category_name_db</option>";
						
					$stmt = $con -> prepare('SELECT * FROM swimming_pool_categories'); 
					$stmt -> execute(); 
					$stmt -> store_result(); 
					$stmt -> bind_result($category_id,$category_name,$pp,$ff); 
					$numrows = $stmt -> num_rows();
					if($numrows > 0){
						while ($stmt -> fetch()) { 
						echo"			
						<option value='$category_name'>$category_name</option>
						";
						}
					}
					else{echo"<option value=''>Please add a categor first </option>";}
					echo"
					</select>
                </div>
				<div class='form-group col-md-12'>
					<textarea style='' name='description' class='form-control' placeholder='Description'>$description</textarea> 
                </div>
               
            </div>

			<div class='form-row'>
                <div class='form-group col-md-12'>
				<label>Price</label>
					<input placeholder='Price' type='text' class='form-control' name='price' value='$price'>
                </div>
              </div>

				<div class='form-row'>
                <div class='form-group col-md-12'>
					<img style='width:100%;border-radius:5px;'src='assets/img/swimming_meals/$picture' class='img-fluid' alt=''>
					<input type='file' name='fileField' class='form-control'/> 
				</div>
			</div>
			
	<div class='form-group col-md-12'>
		 <div class='text-center' style='position:relative;top:-19px;'>
				<button type='submit' name='update$id'>Update</button>
				<button type='submit' name='delete$id'>Delete</button>
			</div>
		 </div>
		</form>
		</div>
		";
		if (isset($_POST["update$id"])) {
			$category = mysqli_real_escape_string($con,$_POST['category']);
			$name = mysqli_real_escape_string($con,$_POST['name']);
			$description = mysqli_real_escape_string($con,$_POST['description']);
			$price = mysqli_real_escape_string($con,$_POST['price']);

			if( ($_FILES["fileField"]["type"]=="") == false ){
				unlink("assets/img/swimming_meals/$picture");
				$random_id = substr(md5(rand()), 0, 20);
				$extension = pathinfo($_FILES["fileField"]["name"], PATHINFO_EXTENSION);
				move_uploaded_file( $_FILES['fileField']['tmp_name'], "assets/img/swimming_meals/$random_id.$extension");
				$picture ="$random_id.$extension";
			}

			$stmt = $con -> prepare('UPDATE swimming_pool SET category =?,name=?,description=?,price=?,picture=? WHERE id = ?');
			$stmt -> bind_param('sssssi', $category,$name,$description,$price,$picture,$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?u=$id&m=$message\">";
		}
						
		if (isset($_POST["delete$id"])) {
			$stmt = $con -> prepare('DELETE FROM swimming_pool WHERE id = ?');	
			$stmt -> bind_param('i', $id);
			$stmt -> execute();
			unlink("assets/img/swimming_meals/$picture");
			//create a session to verify it's coming from here
			$_SESSION["action"] = "true";
			$message="Item successfully deleted.";
			echo "<meta http-equiv=\"refresh\" content=\"0; url=success.php?u=meals_swim.php&m=$message\">";
		}
		
		
		
	
		?>
		
		

        </div><!-- end row -->
		
    </div>
</section><!-- End Contact Section -->
  <?php include("footer.php"); ?>