Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/pennagaram.org/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: add-shop.php

<!doctype html>
<html lang="en">
<?php
include('includes/head.php');
include('includes/db.php');

// Fetch categories
$categoriesSql = "SELECT id, name FROM shop_categories ORDER BY name ASC";
$categoriesResult = mysqli_query($conn, $categoriesSql);
$categories = [];
if ($categoriesResult) {
    while ($row = mysqli_fetch_assoc($categoriesResult)) {
        $categories[] = $row;
    }
}

// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['action']) && $_POST['action'] === 'add_shop') {
        $shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
        $owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
        $email = mysqli_real_escape_string($conn, $_POST['email']);
        $mobile = mysqli_real_escape_string($conn, $_POST['mobile']);
        $address = mysqli_real_escape_string($conn, $_POST['address']);
        $business_type_id = intval($_POST['business_type']);
        $opening_hours = isset($_POST['opening_hours']) ? mysqli_real_escape_string($conn, $_POST['opening_hours']) : NULL;
        $website = isset($_POST['website']) ? mysqli_real_escape_string($conn, $_POST['website']) : NULL;
        $map_link = isset($_POST['map_link']) ? mysqli_real_escape_string($conn, $_POST['map_link']) : NULL;
        $description = isset($_POST['description']) ? mysqli_real_escape_string($conn, $_POST['description']) : NULL;
        $keywords = isset($_POST['keywords']) ? mysqli_real_escape_string($conn, $_POST['keywords']) : NULL;
        $listing_type = isset($_POST['listing_type']) ? mysqli_real_escape_string($conn, $_POST['listing_type']) : 'free';
        
        // Get business type name from category ID
        $business_type_name = '';
        $categoryQuery = "SELECT name FROM shop_categories WHERE id = ?";
        $categoryStmt = mysqli_prepare($conn, $categoryQuery);
        mysqli_stmt_bind_param($categoryStmt, "i", $business_type_id);
        mysqli_stmt_execute($categoryStmt);
        mysqli_stmt_bind_result($categoryStmt, $business_type_name);
        mysqli_stmt_fetch($categoryStmt);
        mysqli_stmt_close($categoryStmt);
        
        $uploadDir = 'uploads/shops/';
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0755, true);
        }
        
        $errors = [];
        
        // Handle front image (required)
        if (isset($_FILES['front_image']) && $_FILES['front_image']['error'] === 0) {
            $frontImage = $_FILES['front_image'];
            $imageExt = strtolower(pathinfo($frontImage['name'], PATHINFO_EXTENSION));
            $allowedExt = ['jpg', 'jpeg', 'png', 'webp', 'gif'];
            
            if (in_array($imageExt, $allowedExt)) {
                $frontImageName = 'shop_front_' . time() . '_' . uniqid() . '.' . $imageExt;
                $frontImageTarget = $uploadDir . $frontImageName;
                
                if (!move_uploaded_file($frontImage['tmp_name'], $frontImageTarget)) {
                    $errors[] = "Failed to upload front image.";
                }
            } else {
                $errors[] = "Invalid front image format. Allowed formats: JPG, JPEG, PNG, WebP, GIF.";
            }
        } else {
            $errors[] = "Front image is required.";
        }
        
        // Handle additional images (optional, multiple)
        $additionalImages = [];
        if (isset($_FILES['additional_images']) && count($_FILES['additional_images']['name']) > 0) {
            $additionalFiles = $_FILES['additional_images'];
            $fileCount = count($additionalFiles['name']);
            
            for ($i = 0; $i < $fileCount; $i++) {
                if ($additionalFiles['error'][$i] === 0) {
                    $additionalExt = strtolower(pathinfo($additionalFiles['name'][$i], PATHINFO_EXTENSION));
                    
                    if (in_array($additionalExt, $allowedExt)) {
                        $additionalName = 'shop_additional_' . time() . '_' . uniqid() . '_' . $i . '.' . $additionalExt;
                        $additionalTarget = $uploadDir . $additionalName;
                        
                        if (move_uploaded_file($additionalFiles['tmp_name'][$i], $additionalTarget)) {
                            $additionalImages[] = $additionalTarget;
                        }
                    }
                }
            }
        }
        
        if (empty($errors)) {
            // Generate slug
            $slug = generateSlug($shop_name);
            
            // Insert shop details into shops1 table
            $insertShopSql = "INSERT INTO shops1 (
                shop_name, owner_name, email, mobile, address, business_type, 
                opening_hours, website, map_link, description, keywords, 
                front_image, listing_type, slug, status, created_at
            ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'approved', NOW())";
            
            $stmt = mysqli_prepare($conn, $insertShopSql);
            mysqli_stmt_bind_param(
                $stmt, 
                'ssssssssssssss',
                $shop_name, $owner_name, $email, $mobile, $address, $business_type_name,
                $opening_hours, $website, $map_link, $description, $keywords,
                $frontImageTarget, $listing_type, $slug
            );
            
            if (mysqli_stmt_execute($stmt)) {
                $shop_id = mysqli_insert_id($conn);
                
                // Insert additional images into shop_images table
                if (!empty($additionalImages)) {
                    foreach ($additionalImages as $imagePath) {
                        $imageSql = "INSERT INTO shop_images (shop_id, image_path, created_at) VALUES (?, ?, NOW())";
                        $imageStmt = mysqli_prepare($conn, $imageSql);
                        mysqli_stmt_bind_param($imageStmt, "is", $shop_id, $imagePath);
                        mysqli_stmt_execute($imageStmt);
                        mysqli_stmt_close($imageStmt);
                    }
                }
                
                $successMsg = "Shop added successfully! Shop ID: " . $shop_id;
            } else {
                $errorMsg = "Failed to add shop: " . mysqli_error($conn);
            }
            mysqli_stmt_close($stmt);
        } else {
            $errorMsg = implode("<br>", $errors);
        }
    }
}

// Function to generate slug
function generateSlug($shopName) {
    global $conn;
    
    $slug = strtolower(trim($shopName));
    $slug = preg_replace('/[^a-z0-9-]/', '-', $slug);
    $slug = preg_replace('/-+/', '-', $slug);
    $slug = trim($slug, '-');
    
    // Check if slug already exists and make it unique
    $base_slug = $slug;
    $counter = 1;
    
    do {
        $check_sql = "SELECT id FROM shops1 WHERE slug = ?";
        $check_stmt = mysqli_prepare($conn, $check_sql);
        mysqli_stmt_bind_param($check_stmt, "s", $slug);
        mysqli_stmt_execute($check_stmt);
        mysqli_stmt_store_result($check_stmt);
        
        if (mysqli_stmt_num_rows($check_stmt) > 0) {
            $slug = $base_slug . '-' . $counter;
            $counter++;
        } else {
            break;
        }
        
        mysqli_stmt_close($check_stmt);
    } while (true);
    
    return $slug;
}
?>

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Add New Shop</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">Shops</a></li>
                                    <li class="breadcrumb-item active">Add Shop</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (isset($successMsg)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="fas fa-check-circle me-2"></i>
                        <?php echo $successMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                <?php if (isset($errorMsg)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <?php echo $errorMsg; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Shop Details</h4>
                                <form method="post" enctype="multipart/form-data" id="addShopForm">
                                    <input type="hidden" name="action" value="add_shop">
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="shop_name" class="form-label">Shop Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="shop_name" name="shop_name" required placeholder="Enter shop name" maxlength="255">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="owner_name" class="form-label">Owner Name <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="owner_name" name="owner_name" required placeholder="Enter owner name" maxlength="255">
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="email" class="form-label">Email Address <span class="text-danger">*</span></label>
                                                <input type="email" class="form-control" id="email" name="email" required placeholder="Enter email address" maxlength="255">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="mobile" class="form-label">Mobile Number <span class="text-danger">*</span></label>
                                                <input type="text" class="form-control" id="mobile" name="mobile" required placeholder="Enter mobile number" maxlength="20">
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="address" class="form-label">Complete Address <span class="text-danger">*</span></label>
                                        <textarea class="form-control" id="address" name="address" required rows="3" placeholder="Enter complete shop address with PIN code"></textarea>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="business_type" class="form-label">Business Category <span class="text-danger">*</span></label>
                                                <select class="form-select" id="business_type" name="business_type" required>
                                                    <option value="">Select Business Type</option>
                                                    <?php foreach ($categories as $cat): ?>
                                                        <option value="<?php echo htmlspecialchars($cat['id']); ?>"><?php echo htmlspecialchars($cat['name']); ?></option>
                                                    <?php endforeach; ?>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="listing_type" class="form-label">Listing Type</label>
                                                <select class="form-select" id="listing_type" name="listing_type">
                                                    <option value="free">Free Basic Listing</option>
                                                    <option value="premium">Premium Verified Listing</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="opening_hours" class="form-label">Business Hours</label>
                                                <input type="text" class="form-control" id="opening_hours" name="opening_hours" placeholder="e.g., 9:00 AM - 8:00 PM, Monday-Saturday" maxlength="100">
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="website" class="form-label">Website (Optional)</label>
                                                <input type="url" class="form-control" id="website" name="website" placeholder="https://yourbusiness.com" maxlength="255">
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="map_link" class="form-label">Google Map Location Link</label>
                                        <input type="url" class="form-control" id="map_link" name="map_link" placeholder="https://maps.google.com/?q=Your+Business+Location" maxlength="500">
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="description" class="form-label">Business Description</label>
                                        <textarea class="form-control" id="description" name="description" rows="4" placeholder="Describe your business, products, services, and specialties"></textarea>
                                    </div>
                                    
                                    <div class="mb-3">
                                        <label for="keywords" class="form-label">Search Keywords</label>
                                        <input type="text" class="form-control" id="keywords" name="keywords" placeholder="e.g., best textiles pennagaram, grocery store near me" maxlength="255">
                                        <div class="form-text">Add keywords that customers might use to find your business (separate with commas)</div>
                                    </div>
                                    
                                    <div class="row">
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="front_image" class="form-label">Shop Front Image <span class="text-danger">*</span></label>
                                                <input type="file" class="form-control" id="front_image" name="front_image" accept=".jpg,.jpeg,.png,.webp,.gif" required>
                                                <div class="form-text">Upload a clear image of your shop front. Max file size: 5MB.</div>
                                            </div>
                                        </div>
                                        <div class="col-md-6">
                                            <div class="mb-3">
                                                <label for="additional_images" class="form-label">Additional Business Images</label>
                                                <input type="file" class="form-control" id="additional_images" name="additional_images[]" accept=".jpg,.jpeg,.png,.webp,.gif" multiple>
                                                <div class="form-text">Upload more images of products, services, or interior. Max file size: 5MB each.</div>
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="mt-4">
                                        <button type="submit" class="btn btn-primary">
                                            <i class="fas fa-plus-circle me-2"></i>Add Shop
                                        </button>
                                        <button type="reset" class="btn btn-secondary">
                                            <i class="fas fa-redo me-2"></i>Reset Form
                                        </button>
                                        <a href="shops-list.php" class="btn btn-outline-dark">
                                            <i class="fas fa-list me-2"></i>View All Shops
                                        </a>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                
            </div>
            
        </div>
        
        <?php include('includes/footer.php')?>
    </div>
    
</div>


<?php include('includes/rightbar.php')?>


<?php include('includes/scripts.php')?>
<script>
document.addEventListener('DOMContentLoaded', function() {
    // Form validation and loading state
    document.getElementById('addShopForm').addEventListener('submit', function(e) {
        const shopName = document.getElementById('shop_name').value.trim();
        const ownerName = document.getElementById('owner_name').value.trim();
        const email = document.getElementById('email').value.trim();
        const mobile = document.getElementById('mobile').value.trim();
        const address = document.getElementById('address').value.trim();
        const businessType = document.getElementById('business_type').value.trim();
        const frontImage = document.getElementById('front_image').files[0];
        
        // Basic validation
        if (!shopName || !ownerName || !email || !mobile || !address || !businessType || !frontImage) {
            e.preventDefault();
            showAlert('Please fill all required fields (marked with *).', 'error');
            return;
        }
        
        // Email validation
        const emailRegex = /^[^\s@]+@[^\s@]+\.[^\s@]+$/;
        if (!emailRegex.test(email)) {
            e.preventDefault();
            showAlert('Please enter a valid email address.', 'error');
            return;
        }
        
        // Mobile validation (basic - 10 digits)
        const mobileDigits = mobile.replace(/\D/g, '');
        if (mobileDigits.length !== 10) {
            e.preventDefault();
            showAlert('Please enter a valid 10-digit mobile number.', 'error');
            return;
        }
        
        // File size validation for front image
        if (frontImage && frontImage.size > 5 * 1024 * 1024) {
            e.preventDefault();
            showAlert('Front image size must be less than 5MB', 'error');
            return;
        }
        
        // File size validation for additional images
        const additionalImages = document.getElementById('additional_images').files;
        for (let i = 0; i < additionalImages.length; i++) {
            if (additionalImages[i].size > 5 * 1024 * 1024) {
                e.preventDefault();
                showAlert('Additional images must be less than 5MB each', 'error');
                return;
            }
        }
        
        // Show loading state
        const submitBtn = this.querySelector('button[type="submit"]');
        submitBtn.innerHTML = '<i class="fas fa-spinner fa-spin me-2"></i>Adding Shop...';
        submitBtn.disabled = true;
    });
    
    // Image preview functionality
    const frontImageInput = document.getElementById('front_image');
    const additionalImagesInput = document.getElementById('additional_images');
    
    frontImageInput.addEventListener('change', function(e) {
        previewImage(this.files[0], 'front-preview');
    });
    
    additionalImagesInput.addEventListener('change', function(e) {
        const files = this.files;
        const container = document.getElementById('additional-preview');
        if (!container) {
            const previewContainer = document.createElement('div');
            previewContainer.id = 'additional-preview';
            previewContainer.className = 'row mt-3';
            additionalImagesInput.parentNode.appendChild(previewContainer);
        }
        
        document.getElementById('additional-preview').innerHTML = '';
        
        for (let i = 0; i < files.length; i++) {
            previewImage(files[i], 'additional-preview', i);
        }
    });
    
    function previewImage(file, type, index = 0) {
        if (file) {
            const reader = new FileReader();
            reader.onload = function(e) {
                if (type === 'front-preview') {
                    let preview = document.getElementById('front-preview');
                    if (!preview) {
                        preview = document.createElement('div');
                        preview.id = 'front-preview';
                        preview.className = 'mt-2';
                        frontImageInput.parentNode.appendChild(preview);
                    }
                    preview.innerHTML = `
                        <div class="image-preview">
                            <img src="${e.target.result}" class="img-thumbnail" style="max-height: 150px;">
                            <small class="text-muted d-block mt-1">Front Image Preview</small>
                        </div>
                    `;
                } else {
                    const container = document.getElementById('additional-preview');
                    const col = document.createElement('div');
                    col.className = 'col-md-3 mb-2';
                    col.innerHTML = `
                        <div class="image-preview">
                            <img src="${e.target.result}" class="img-thumbnail" style="max-height: 150px;">
                            <small class="text-muted d-block mt-1">Additional Image ${index + 1}</small>
                        </div>
                    `;
                    container.appendChild(col);
                }
            }
            reader.readAsDataURL(file);
        }
    }
    
    function showAlert(message, type) {
        // Remove existing alerts
        const existingAlerts = document.querySelectorAll('.custom-alert');
        existingAlerts.forEach(alert => alert.remove());
        
        const alertDiv = document.createElement('div');
        alertDiv.className = `alert alert-${type === 'error' ? 'danger' : 'success'} custom-alert alert-dismissible fade show`;
        alertDiv.innerHTML = `
            <i class="fas fa-${type === 'error' ? 'exclamation-triangle' : 'check-circle'} me-2"></i>
            ${message}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        `;
        
        document.querySelector('.container-fluid').insertBefore(alertDiv, document.querySelector('.container-fluid').firstChild);
        
        // Auto remove after 5 seconds
        setTimeout(() => {
            if (alertDiv.parentNode) {
                alertDiv.remove();
            }
        }, 5000);
    }
});
</script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-shop.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation