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/ellexsleevesapartments.com/public_html/admin1249/ |
<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']);
include("headerstrict.php"); ?>
<title><?php echo $company_name; ?>, Admin, Rooms</title>
<style>
table {
border-collapse: collapse;
border-spacing: 0;
width: 100%;
border: 1px solid #ddd;
font-size:18px;
}
th, td {
text-align: left;
padding: 8px 28px 8px 28px;
}
tr:nth-child(even){background-color: #f2f2f2}
</style>
<?php
if (isset($_POST['add_room'])) {
$header = mysqli_real_escape_string($con,$_POST['header']);
$paragraph = mysqli_real_escape_string($con,$_POST['paragraph']);
$price = mysqli_real_escape_string($con,$_POST['price']);
$feature1 = mysqli_real_escape_string($con,$_POST['feature1']);
$feature2 = mysqli_real_escape_string($con,$_POST['feature2']);
$feature3 = mysqli_real_escape_string($con,$_POST['feature3']);
$feature4 = mysqli_real_escape_string($con,$_POST['feature4']);
$feature5 = mysqli_real_escape_string($con,$_POST['feature5']);
$feature1_wu = mysqli_real_escape_string($con,$_POST['feature1_wu']);
$feature2_wu = mysqli_real_escape_string($con,$_POST['feature2_wu']);
$feature3_wu = mysqli_real_escape_string($con,$_POST['feature3_wu']);
$feature4_wu = mysqli_real_escape_string($con,$_POST['feature4_wu']);
$feature5_wu = mysqli_real_escape_string($con,$_POST['feature5_wu']);
$featured = mysqli_real_escape_string($con,$_POST['featured']);
$number_rooms = mysqli_real_escape_string($con,$_POST['number_rooms']);
$discount = mysqli_real_escape_string($con,$_POST['discount']);
if( ($_FILES["fileField1"]["type"]=="") == false ){
$random_id1 = substr(md5(rand()), 0, 20);
$extension1 = pathinfo($_FILES["fileField1"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField1']['tmp_name'], "../rooms/$random_id1.$extension1");
$picture1 ="$random_id1.$extension1";
}
else{$picture1 ="";}
if( ($_FILES["fileField2"]["type"]=="") == false ){
$random_id2 = substr(md5(rand()), 0, 20);
$extension2 = pathinfo($_FILES["fileField2"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField2']['tmp_name'], "../rooms/$random_id2.$extension2");
$picture2 ="$random_id2.$extension2";
}
else{$picture2 ="";}
if( ($_FILES["fileField3"]["type"]=="") == false ){
$random_id3 = substr(md5(rand()), 0, 20);
$extension3 = pathinfo($_FILES["fileField3"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField3']['tmp_name'], "../rooms/$random_id3.$extension3");
$picture3 ="$random_id3.$extension3";
}
else{$picture3 ="";}
if( ($_FILES["fileField4"]["type"]=="") == false ){
$random_id4 = substr(md5(rand()), 0, 20);
$extension4 = pathinfo($_FILES["fileField4"]["name"], PATHINFO_EXTENSION);
move_uploaded_file( $_FILES['fileField4']['tmp_name'], "../rooms/$random_id4.$extension4");
$picture4 ="$random_id4.$extension4";
}
else{$picture4 ="";}
$db_id=0;
$stmt = $con -> prepare('INSERT INTO rooms VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)');
$stmt -> bind_param('issssssssssssssssssss', $db_id,$header,$paragraph,$price,$feature1,$feature2,$feature3,$feature4,$feature5,$picture1,$picture2,$picture3,$picture4,$featured,$feature1_wu,$feature2_wu,$feature3_wu,$feature4_wu,$feature5_wu,$number_rooms,$discount);
$stmt -> execute();
//create a session to verify it's coming from here
$_SESSION["action"] = "true";
$message="Room 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>Rooms</h2>
<p>Add a room</p>
</div>
<div class="row">
<div class="col-lg-9 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="header" class="form-control" placeholder="Title" required />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-12">
<textarea name="paragraph" class="form-control" placeholder="Description" required></textarea>
</div>
</div>
<div class="form-row">
<div class="form-group col-md-12">
<input type="text" name="price" class="form-control" placeholder="Price (Integers Only - No commas,periods or any other symbol)"/>
</div>
</div>
<div class='l'>Pictures</div>
<div class="form-row">
<div class="form-group col-md-6">
<input type='file' name='fileField1' class="form-control" required />
</div>
<div class="form-group col-md-6">
<input type='file' name='fileField2' class="form-control" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<input type='file' name='fileField3' class="form-control" />
</div>
<div class="form-group col-md-6">
<input type='file' name='fileField4' class="form-control" />
</div>
</div>
<div class='l'>Features and Amenities</div>
<div class="form-row">
<div class="form-group col-md-4">
<input type="text" name="feature1" class="form-control" placeholder="Feature 1 Caption" />
</div>
<div class="form-group col-md-8">
<input type="text" name="feature1_wu" class="form-control" placeholder="Feature 1 Write up" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-4">
<input type="text" name="feature2" class="form-control" placeholder="Feature 2 Caption" />
</div>
<div class="form-group col-md-8">
<input type="text" name="feature2_wu" class="form-control" placeholder="Feature 2 Write up" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-4">
<input type="text" name="feature3" class="form-control" placeholder="Feature 3 Caption" />
</div>
<div class="form-group col-md-8">
<input type="text" name="feature3_wu" class="form-control" placeholder="Feature 3 Write up" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-4">
<input type="text" name="feature4" class="form-control" placeholder="Feature 4 Caption" />
</div>
<div class="form-group col-md-8">
<input type="text" name="feature4_wu" class="form-control" placeholder="Feature 4 Write up" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-4">
<input type="text" name="feature5" class="form-control" placeholder="Feature 5 Caption" />
</div>
<div class="form-group col-md-8">
<input type="text" name="feature5_wu" class="form-control" placeholder="Feature 5 Write up" />
</div>
</div>
<div class="form-row">
<div class="form-group col-md-12">
<label for="featured">If selected room will appear under the 'featured' category</label>
<select name="featured" class='form-control' id="featured">
<option value="">Set as a Featured Room</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
<div class='form-group col-md-12'>
<input type='text' name='number_rooms' class='form-control' placeholder='Number of Rooms' />
</div>
<div class='form-group col-md-12'>
<input type='number' name='discount' class='form-control' placeholder='Discount' />
</div>
</div>
<div class="text-center">
<button type="submit" name='add_room'>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 Rooms</p>
</div>
<div class='row'>
<?php
$room_count = 0;
$stmt = $con -> prepare('SELECT * FROM rooms ORDER BY id ASC');
$stmt -> execute();
$stmt -> store_result();
$stmt -> bind_result($room_id,$header,$paragraph,$price,$feature1,$feature2,$feature3,$feature4,$feature5,$picture1,$picture2,$picture3,$picture4,$featured,$feature1_wu,$feature2_wu,$feature3_wu,$feature4_wu,$feature5_wu,$number_rooms,$discount);
$numrows = $stmt -> num_rows();
if($numrows > 0){
echo"
<div style='overflow-x:auto;'>
<table>
<tr>
<th>No</th>
<th>Name</th>
<th>Price</th>
<th>Discount</th>
<th>Description</th>
<th>View Details</th>
</tr>
";
while ($stmt -> fetch()) {
$room_count++;
echo"
<tr>
<td>$room_count</td>
<td>$header</td>
<td>$currency";echo number_format((float)$price, 2, '.', ',');echo"</td>
<td>$discount</td>
<td>$paragraph</td>
<td><a href='room_details.php?u=$room_id'>View Details</a></td>
</tr>
";
}
echo"
</table>
</div>
";
}
?>
</div>
</div>
</section><!-- End Contact Section -->
<?php include("footer.php"); ?>