wobblies

Back Back Up Advanced Editor

<?php 
include 'head.php';
include 'header.php';

// Include database connection file
include_once("../_db.php");

// Initialize variables
$status = $message = '';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $bedrooms = $_POST['bedrooms'];
    $location = $_POST['location'];
    $baths = $_POST['baths'];
    $heights = $_POST['heights'];
    $description = $_POST['description'];
    $price = $_POST['price'];
    $state = $_POST['state'];
    $neighborhood = $_POST['neighborhood'];
    $agent = $_POST['agent'];
    $type = $_POST['type'];
    $country = $_POST['country'];
    $rental_id = md5(uniqid());

// Check if all fields are filled
    if (empty($bedrooms) || empty($location) || empty($baths) || empty($heights) || empty($description) || empty($price) || empty($state) || empty($neighborhood) || empty($agent) || empty($type) || empty($country) || empty($_FILES['image']['name'][0])) {
        $status = 'error';
        $message = 'Please fill all fields';
    } else {
        // File upload handling
        $uploadDirectory = '../rental/';

// Loop through each uploaded image
        foreach ($_FILES['image']['tmp_name'] as $key => $tmp_name) {
            $fileName = basename($_FILES['image']['name'][$key]);
            $targetPath = $uploadDirectory . $fileName;

// Check if file already exists
            if (file_exists($targetPath)) {
                $status = 'error';
                $message = 'File already exists';
                break;
            } else {
                // Upload file
                if (!move_uploaded_file($_FILES['image']['tmp_name'][$key], $targetPath)) {
                    $status = 'error';
                    $message = 'Failed to upload file';
                    break;
                } else {
                    // Insert into database
                    $insertQuery = "INSERT INTO rentals (rental_id, bedroom_category, location, baths, heights, description, price, state, neighborhood, agent, type, country, nft_img) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
                    $insertStmt = $conn->prepare($insertQuery);

// Check if prepare() was successful
                    if ($insertStmt) {
                        $insertStmt->bind_param("sssssssssssss", $rental_id, $bedrooms, $location, $baths, $heights, $description, $price, $state, $neighborhood, $agent, $type, $country, $fileName);
                        if ($insertStmt->execute()) {
                            $status = 'success';
                            $message = 'Rental added successfully';
                        } else {
                            $status = 'error';
                            $message = 'Failed to execute insert query: ' . $insertStmt->error;
                            break;
                        }
                    } else {
                        $status = 'error';
                        $message = 'Failed to prepare SQL statement: ' . $conn->error;
                        break;
                    }
                }
            }
        }
    }

// Display status message
    if ($status) {
        echo '<div style="color: ' . ($status === 'success' ? 'green' : 'red') . ';">' . $message . '</div>';
    }
}
include 'sidebar.php';   
?>

<body class="skin-default fixed-layout">
    <div id="main-wrapper">
        <div class="page-wrapper">
            <div class="container-fluid">
                <?php include 'nav.php'; ?>
                <div class="container">
                    <div class="text-right my-3">
                        <button type="button" class="btn btn-success" data-toggle="modal" data-target="#myModal">
                            <i class="bi bi-plus"></i> Add Category
                        </button>
                    </div>
                </div>

<div class="modal fade" id="myModal">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            
                            <div class="modal-header">
                                <h4 class="modal-title">Manage Category</h4>
                                <button type="button" class="close" data-dismiss="modal">&times;</button>
                            </div>
                            
                            <div class="modal-body">
                                <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" class="add-product-form" enctype="multipart/form-data">
                                    <select name="bedrooms" class="form-control my-2">
                                        <option value="Studio">Studio</option>
                                        <option value="1">1 Bedroom</option>
                                        <option value="2">2 Bedrooms</option>
                                        <option value="3">3 Bedrooms</option>
                                    </select>

<div class="form-group">
                                        <input type="text" name="location" placeholder="Enter rental location" class="form-control my-2" required>
                                    </div>
                                    
                                    <div class="form-group">
                                        <select name="baths" class="form-control my-2">
                                            <option value="1">1</option>
                                            <option value="1.5">1.5</option>
                                            <option value="2">2</option>
                                            <option value="2.5">2.5</option>
                                            <option value="3">3</option>
                                        </select>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="heights" placeholder="Enter rental apartment height" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <textarea name="description" cols="30" rows="5" class="form-control my-2" placeholder="Enter rental description" required></textarea>
                                    </div>
                                    <div class="form-group">
                                        <input type="number" name="price" placeholder="Enter rental price" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="state" placeholder="Enter rental state" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="neighborhood" placeholder="Enter rental neighborhood" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="agent" placeholder="Enter agent" class="form-control my-2" required>
                                    </div>
                                    <div class="form-group">
                                        <select name="type" class="form-control my-2">
                                            <option value="For rent">For Rent</option>
                                            <option value="For Sale">For Sale</option>
                                        </select>
                                    </div>
                                    <div class="form-group">
                                        <input type="text" name="country" placeholder="Enter country" class="form-control my-2" required>
                                    </div>
                                    <label for="image[]">Select Image:</label>
                                    <input type="file" name="image[]" id="image" accept="image/png, image/jpeg, image/webp" multiple required><br><br>

<div class="modal-footer">
                                        <button type="submit" name="add_rental" class="btn btn-success">Submit</button>
                                        <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>

<section>
                    <div class="d-flex justify-content-end align-items-center">
                        <div class="container-fluid">
                            <div class="card">
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table">
                                            <thead>
                                                <tr>
                                                    <th>#</th>
                                                    <th>Rental Image</th>
                                                    <th>Bedrooms</th>
                                                    <th>Location</th>
                                                    <th>Price</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php 
                                                  $select_rentals = mysqli_query($conn, "SELECT * FROM rentals");
                                                  if (mysqli_num_rows($select_rentals) > 0) {
                                                      $num = 1;
                                                      while ($row = mysqli_fetch_assoc($select_rentals)) {
                                                ?>
                                                <tr>
                                                    <td><?php echo $num++; ?></td>
                                                    <td><img src="../rental/<?php echo $row['nft_img']; ?>" height="100" alt=""></td>
                                                    <td><?php echo htmlspecialchars($row['bedroom_category']); ?></td>
                                                    <td><?php echo htmlspecialchars($row['location']); ?></td>
                                                    <td>$<?php echo number_format($row['price']); ?>/mo</td>
                                                    <td>
                                                        <a href="rental-details.php?rental_id=<?php echo $row['rental_id']; ?>" class="btn btn-info btn-sm"><i class="bi bi-eye-fill" style="font-size: 20px;"></i></a>
                                                    </td>
                                                </tr>
                                                <?php 
                                                      }
                                                  } 
                                                ?> 
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </section>
            </div>
        </div>
    </div>  
    <?php
    include 'footer.php';
    ?>
</body>