Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/public_html/admin

Free Space:

14.02 GB

🔧 Quick Actions

✏️ Editing: testimonials.php

<?php
include 'config.php';

// Function to extract YouTube video ID from a URL
function extractYouTubeID($url) {
    // Regex for matching YouTube URL
    if (preg_match('/(?:https?:\/\/(?:www\.)?)?(?:youtube\.com\/(?:[^\/\n\s]+\/\S+\/|(?:v|e(?:mbed)?)\/|\S*?[?&]v=))([^"&?\/\s]{11})/', $url, $matches)) {
        return $matches[1]; // Return the YouTube video ID
    }
    return false; // Return false if not a valid YouTube URL
}

// Handle delete testimonial
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    $deleteQuery = "DELETE FROM testimonials WHERE id = ?";
    $deleteStmt = $conn->prepare($deleteQuery);
    $deleteStmt->bind_param('i', $delete_id);

if ($deleteStmt->execute()) {
        echo "<script>alert('Testimonial deleted successfully!'); window.location.href='testimonials.php';</script>";
    } else {
        echo "<script>alert('Error deleting testimonial.'); window.location.href='testimonials.php';</script>";
    }
}

// Fetch testimonial data if editing
$testimonial = null;
if (isset($_GET['edit_id'])) {
    $edit_id = intval($_GET['edit_id']);
    $editQuery = "SELECT * FROM testimonials WHERE id = ?";
    $editStmt = $conn->prepare($editQuery);
    $editStmt->bind_param('i', $edit_id);
    $editStmt->execute();
    $testimonial = $editStmt->get_result()->fetch_assoc();
}

// Handle form submission for adding or updating testimonial
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $video_url = $_POST['video_url'] ?? '';

// Extract video ID from YouTube URL
    $video_id = extractYouTubeID($video_url);

// If the URL is not valid, show error
    if (!$video_id) {
        $error = "Please provide a valid YouTube video URL.";
    } else {
        // If editing, update existing testimonial
        if (isset($_POST['edit_id'])) {
            $edit_id = intval($_POST['edit_id']);
            $updateQuery = "UPDATE testimonials SET video_url = ? WHERE id = ?";
            $stmt = $conn->prepare($updateQuery);
            $stmt->bind_param('si', $video_id, $edit_id);

if ($stmt->execute()) {
                $success = 'Testimonial updated successfully!';
            } else {
                $error = 'Error updating testimonial.';
            }
        } else {
            // If adding a new testimonial
            $insertQuery = "INSERT INTO testimonials (video_url) VALUES (?)";
            $stmt = $conn->prepare($insertQuery);
            $stmt->bind_param('s', $video_id);

if ($stmt->execute()) {
                $success = "Testimonial added successfully!";
            } else {
                $error = "Error executing statement: " . $stmt->error;
            }
        }
    }
}

// Fetch all testimonials
$query = "SELECT * FROM testimonials";
$result = $conn->query($query);
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Manage Testimonials</title>
    <link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet">
    <link rel="stylesheet" type="text/css" href="assets/icon/themify-icons/themify-icons.css">
    <link rel="stylesheet" type="text/css" href="assets/icon/icofont/css/icofont.css">
    <link rel="stylesheet" type="text/css" href="assets/icon/simple-line-icons/css/simple-line-icons.css">
    <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="assets/css/main.css">
    <link rel="stylesheet" type="text/css" href="assets/css/responsive.css">
</head>

<div class="content-wrapper">
            <div class="container-fluid">
                <div class="row">
                    <div class="main-header">
                        <h4>All Testimonials</h4>
                    </div>
                </div>

<div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-header">
                                <h5>Manage Testimonials</h5>
                            </div>
                            <div class="card-block">
                                
                                <?php if (isset($success)): ?>
                                    <div class="alert alert-success"><?= $success ?></div>
                                <?php elseif (isset($error)): ?>
                                    <div class="alert alert-danger"><?= $error ?></div>
                                <?php endif; ?>

<form method="POST" action="">
                                    <div class="form-group">
                                        <label for="video_url">Testimonial Video URL (YouTube Embed)</label>
                                        <input type="text" class="form-control" id="video_url" name="video_url" value="<?= $testimonial['video_url'] ?? '' ?>" placeholder="Enter YouTube video embed URL" required>
                                    </div>

<?php if (isset($testimonial['id'])): ?>
                                        <input type="hidden" name="edit_id" value="<?= $testimonial['id']; ?>">
                                    <?php endif; ?>

<button type="submit" class="btn btn-success"><?= isset($testimonial['id']) ? 'Update Testimonial' : 'Add Testimonial' ?></button>
                                    <a href="testimonials.php" class="btn btn-secondary">Cancel</a>
                                </form>

<div class="table-responsive mt-4">
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Video ID</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if ($result->num_rows > 0): ?>
                                                <?php $count = 1; ?>
                                                <?php while ($row = $result->fetch_assoc()): ?>
                                                    <tr>
                                                        <td><?= $count++ ?></td>
                                                        <td><?= htmlspecialchars($row['video_url']) ?></td>
                                                        <td>
                                                            <a href="testimonials.php?edit_id=<?= $row['id'] ?>" class="btn btn-primary btn-sm"><i class="icofont icofont-edit"></i> Edit</a>
                                                            <a href="testimonials.php?delete_id=<?= $row['id'] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this testimonial?');"><i class="icofont icofont-trash"></i> Delete</a>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr><td colspan="3" class="text-center">No testimonials found</td></tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

</div>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: testimonials.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation