Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/edusystem

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: uploadvideo.php

<?php
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Include database connection
include("includes/connection.php");

// Fetch teacher's mobile number from session
$mobile = $_SESSION['teacher'];

// Fetch teacher's data
$teacher_query = "SELECT * FROM teachers WHERE mobile = ?";
$teacher_stmt = $con->prepare($teacher_query);
if ($teacher_stmt === false) {
    die("Error preparing teacher query: " . $con->error);  // Debugging error
}
$teacher_stmt->bind_param("s", $mobile);
$teacher_stmt->execute();
$teacher_result = $teacher_stmt->get_result();
$teacher_data = $teacher_result->fetch_assoc();

// Check if teacher's data exists
if (!$teacher_data) {
    echo "Error: Teacher data not found.";
    exit();
}

// Teacher's ID
$teacher_id = $teacher_data['id'];

// Handle video upload
if (isset($_POST['upload_video'])) {
    if (isset($_FILES['video']) && $_FILES['video']['error'] == 0) {
        $video_extension = pathinfo($_FILES['video']['name'], PATHINFO_EXTENSION);
        $allowed_extensions = ['mp4', 'avi', 'mov', 'mkv'];

if (in_array($video_extension, $allowed_extensions)) {
            // Generate a unique file name
            $video_path = 'uploads/video/' . time() . '.' . $video_extension;

// Move uploaded file to the target directory
            if (move_uploaded_file($_FILES['video']['tmp_name'], $video_path)) {
                // Check if the video already exists in the teacher_videos table
                $check_video_query = "SELECT * FROM teacher_videos WHERE teacher_id = ? AND video_path = ?";
                $check_video_stmt = $con->prepare($check_video_query);
                if ($check_video_stmt === false) {
                    die("Error preparing check query: " . $con->error);  // Debugging error
                }
                $check_video_stmt->bind_param("is", $teacher_id, $video_path);
                $check_video_stmt->execute();
                $check_video_result = $check_video_stmt->get_result();

if ($check_video_result->num_rows > 0) {
                    $error = "This video has already been uploaded.";
                } else {
                    // Insert the new video into the teacher_videos table with the current timestamp
                    $insert_query = "INSERT INTO teacher_videos (teacher_id, video_path, uploaded_at) VALUES (?, ?, NOW())";
                    $insert_stmt = $con->prepare($insert_query);
                    if ($insert_stmt === false) {
                        die("Error preparing insert query: " . $con->error);  // Debugging error
                    }
                    $insert_stmt->bind_param("is", $teacher_id, $video_path);
                    $insert_stmt->execute();
                    $success = "Video uploaded successfully.";
                }
            } else {
                $error = "Error moving uploaded file.";
            }
        } else {
            $error = "Invalid file format. Only MP4, AVI, MOV, and MKV are allowed.";
        }
    } else {
        $error = "Please select a video file to upload.";
    }
}

// Handle setting a new current video
if (isset($_POST['set_current_video'])) {
    $new_video_path = $_POST['video_path'];

// Update the current video in the teachers table
    $update_query = "UPDATE teachers SET video = ? WHERE id = ?";
    $update_stmt = $con->prepare($update_query);

if ($update_stmt === false) {
        die("Error preparing update query: " . $con->error);  // Debugging error
    }
    $update_stmt->bind_param("si", $new_video_path, $teacher_id);
    if ($update_stmt->execute()) {
        $success = "Current video updated successfully.";
    } else {
        $error = "Error executing update query: " . $update_stmt->error;
    }
}

// Fetch the updated current video from the teachers table
$current_video_query = "SELECT video FROM teachers WHERE id = ?";
$current_video_stmt = $con->prepare($current_video_query);
if ($current_video_stmt === false) {
    die("Error preparing current video query: " . $con->error);  // Debugging error
}
$current_video_stmt->bind_param("i", $teacher_id);
$current_video_stmt->execute();
$current_video_result = $current_video_stmt->get_result();
$current_video_data = $current_video_result->fetch_assoc();
$current_video = $current_video_data['video'];

// Fetch all previous videos from the teacher_videos table
$videos_query = "SELECT video_path, uploaded_at FROM teacher_videos WHERE teacher_id = ? ORDER BY id DESC";
$videos_stmt = $con->prepare($videos_query);
if ($videos_stmt === false) {
    die("Error preparing videos query: " . $con->error);  // Debugging error
}
$videos_stmt->bind_param("i", $teacher_id);
$videos_stmt->execute();
$videos_result = $videos_stmt->get_result();
$videos = [];
while ($row = $videos_result->fetch_assoc()) {
    $videos[] = $row;
}

include("includes/headermain.php");
?>

<body>
<div id="main-wrapper">
    <?php 
    if (file_exists("includes/header.php")) {
        include("includes/header.php");
    } else {
        echo "Header file not found.";
    }

if (file_exists("includes/tbarmenu.php")) {
        include("includes/tbarmenu.php");
    } else {
        echo "Top bar menu file not found.";
    }
    ?>

<div class="page-wrapper">
        <div class="container mt-5">
            <div class="card">
                <div class="card-header bg-info text-white text-center">
                    <h3>Upload and Manage Video</h3>
                </div>
                <div class="card-body">
                    
                    <?php if (isset($success)) { ?>
                        <div class="alert alert-success"><?php echo $success; ?></div>
                    <?php } elseif (isset($error)) { ?>
                        <div class="alert alert-danger"><?php echo $error; ?></div>
                    <?php } ?>

<form method="POST" action="" enctype="multipart/form-data">
                        <div class="form-group">
                            <label for="video"><strong>Select Video File:</strong></label>
                            <input type="file" name="video" class="form-control" required>
                        </div>
                        <button type="submit" name="upload_video" class="btn btn-primary">
                            <i class="fas fa-upload"></i> Upload Video
                        </button>
                    </form>

<div class="mt-4">
                        <h4>Current Video:</h4>
                        <?php if ($current_video) { ?>
                            <video width="60%" controls>
                                <source src="<?php echo $current_video; ?>" type="video/mp4">
                                Your browser does not support the video tag.
                            </video>
                            <form method="POST" action="">
                                <input type="hidden" name="video_path" value="<?php echo $current_video; ?>">
                                <button type="submit" name="set_current_video" class="btn btn-warning mt-2">
                                    <i class="fas fa-sync"></i> Set as Current Video
                                </button>
                            </form>
                        <?php } else { ?>
                            <p>No current video uploaded.</p>
                        <?php } ?>
                    </div>

<?php if (count($videos) > 0) { ?>
                        <div class="mt-4">
                            <h4>Uploaded Videos:</h4>
                            <div class="row">
                                <?php foreach ($videos as $video) { ?>
                                    <div class="col-md-6 mb-3">
                                        <video width="100%" controls>
                                            <source src="<?php echo $video['video_path']; ?>" type="video/mp4">
                                            Your browser does not support the video tag.
                                        </video>
                                        <p><small>Uploaded on: <?php echo $video['uploaded_at']; ?></small></p>
                                        <form method="POST" action="">
                                            <input type="hidden" name="video_path" value="<?php echo $video['video_path']; ?>">
                                            <button type="submit" name="set_current_video" class="btn btn-primary">
                                                <i class="fas fa-sync"></i> Set as Current Video
                                            </button>
                                        </form>
                                    </div>
                                <?php } ?>
                            </div>
                        </div>
                    <?php } else { ?>
                        <p class="mt-4">No additional videos uploaded yet.</p>
                    <?php } ?>
                </div>
            </div>
        </div>
    </div>

<script src="assets/libs/jquery/dist/jquery.min.js"></script>
    <script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
    <script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
    <script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
    <script src="assets/extra-libs/sparkline/sparkline.js"></script>
    <script src="dist/js/waves.js"></script>
    <script src="dist/js/sidebarmenu.js"></script>
    <script src="dist/js/custom.min.js"></script>
</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: uploadvideo.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation