1#@!#!123s

: / home5 / rakcha / www / admin /
Filename : gallery.php
back
<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
?>


<?php

 ini_set('display_errors', 1);
    ini_set('display_startup_errors', 1);
    error_reporting(E_ALL);




include("includes/database.php");
if (isset($_POST['upload_video']) && $_POST['upload_video'] === 'add_video') {
    global $con;
    header('Content-Type: application/json');

    $uploadDir = 'galleryVideo/';
    if (!file_exists($uploadDir)) {
        mkdir($uploadDir, 0777, true);
    }

    if (isset($_FILES['video']) && $_FILES['video']['error'] === UPLOAD_ERR_OK) {
        $fileTmpPath = $_FILES['video']['tmp_name'];
        $fileName = basename($_FILES['video']['name']);
        $fileSize = $_FILES['video']['size'];
        $fileType = mime_content_type($fileTmpPath);
        $source =  'video';

        $allowedTypes = ['video/mp4', 'video/webm', 'video/ogg'];

        if (!in_array($fileType, $allowedTypes)) {
            echo json_encode(["status" => "error", "message" => "Invalid file type. Only MP4, WebM, and OGG are allowed."]);
            exit;
        }

        if ($fileSize > 100 * 1024 * 1024) {
            echo json_encode(["status" => "error", "message" => "File size exceeds the 100 MB limit."]);
            exit;
        }

        $sanitizedFileName = preg_replace('/[^a-zA-Z0-9._-]/', '_', $fileName);
        $destPath = $uploadDir . uniqid('video_', true) . '.' . pathinfo($sanitizedFileName, PATHINFO_EXTENSION);

        if (move_uploaded_file($fileTmpPath, $destPath)) {
            $stmt = $con->prepare("INSERT INTO `gallery` (`source`, `image`) VALUES (?, ?)");
            $stmt->bind_param("ss", $source, basename($destPath));

            if ($stmt->execute()) {
                echo json_encode(["status" => "success", "message" => "Video uploaded successfully."]);
            } else {
                echo json_encode(["status" => "error", "message" => "Database error: " . $stmt->error]);
            }
            
            $stmt->close();
        } else {
            echo json_encode(["status" => "error", "message" => "Failed to move the uploaded file."]);
        }
    } else {
        echo json_encode(["status" => "error", "message" => "Failed to upload file."]);
    }
    exit;
}


// Handle regular form submission
if (isset($_POST['submit']) && $_POST['submit'] == 'addMedia') {

    

    handleFormSubmission();
}

function handleFormSubmission() {
    global $con;
    
    $title = $_POST['title'];
    $description = $_POST['description'];
    $source = $_POST['source'];
    
    if ($source == 'image') {
        // Handle image upload
        $random_slider_image = rand(10000000, 99999999);
        $slider_image = $_FILES['image']['name'];
        $uploaded_slider_image = "";

        if (!empty($slider_image)) {
            $target_path = "gallery/";
            $uploaded_slider_image = $random_slider_image . "_" . $slider_image;
            move_uploaded_file($_FILES['image']['tmp_name'], $target_path . $uploaded_slider_image);
        }

        mysqli_query($con, "INSERT INTO `gallery` (`title`, `description`, `source`, `image`) 
                          VALUES('$title','$description','$source','$uploaded_slider_image')") 
                          or die(mysqli_error($con));
        
        echo "<script>
                alert('Image added successfully!');
                window.location.href='gallery.php';
              </script>";
        exit;
    }
   
}



// Handle regular form submission
if (isset($_POST['submit']) && $_POST['submit'] == 'addPoster') {

    

    handlePosterFormSubmission();
}

function handlePosterFormSubmission() {
    global $con;

    $source = $_POST['source'];
    

        // Handle image upload
        $random_slider_image = rand(10000000, 99999999);
        $slider_image = $_FILES['posterimage']['name'];
        $uploaded_slider_image = "";

        if (!empty($slider_image)) {
            $target_path = "poster/";
            $uploaded_slider_image = $random_slider_image . "_" . $slider_image;
            move_uploaded_file($_FILES['posterimage']['tmp_name'], $target_path . $uploaded_slider_image);
        }

        mysqli_query($con, "INSERT INTO `poster` (`image`) 
                          VALUES('$uploaded_slider_image')") 
                          or die(mysqli_error($con));
        
        echo "<script>
                alert('Image added successfully!');
                window.location.href='gallery.php';
              </script>";
        exit;
    }
   



?>



  <!DOCTYPE html>

<html lang="en">



<head>

    <meta charset="utf-8" />

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta content="width=device-width, initial-scale=1" name="viewport" />

    <meta name="description" content="RAKCHA | Dashboard" />

    <meta name="author" content="RAKCHA | Dashboard" />

    <title>RAKCHA | Dashboard</title>

    <!-- google font -->

    <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" />

	<!-- icons -->

    <link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>

	<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">

	<!--bootstrap -->

	<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />

    <!-- data tables -->

    <link href="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/>

	<!-- Material Design Lite CSS -->

	<link rel="stylesheet" href="assets/plugins/material/material.min.css">

	<link rel="stylesheet" href="assets/css/material_style.css">

	<!-- animation -->

	<link href="assets/css/pages/animate_page.css" rel="stylesheet">

	<!-- Theme Styles -->

    

    <link href="assets/css/style.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />

    <link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />

	<link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />

	<!-- favicon -->

    <link rel="shortcut icon" href="assets/img/favicon.ico" /> 

     <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f4;
            text-align: center;
            padding: 20px;
        }
        .upload-container {
            width: 50%;
            margin: auto;
            background: white;
            padding: 20px;
            border-radius: 10px;
            box-shadow: 0px 0px 10px #ccc;
        }
        .drop-zone {
            border: 2px dashed #008cba;
            padding: 20px;
            cursor: pointer;
            background: #f9f9f9;
            position: relative;
        }
        .drop-zone:hover {
            background: #e0f7fa;
        }
        .drop-zone input {
            display: none;
        }
        .progress-container {
            display: none;
            margin-top: 10px;
        }
        .progress-bar {
            width: 100%;
            height: 10px;
            background: #ddd;
            border-radius: 5px;
            overflow: hidden;
            margin-top: 10px;
        }
        .progress-bar div {
            height: 100%;
            width: 0%;
            background: #008cba;
            transition: width 0.3s;
        }
        .video-preview {
            display: none;
            margin-top: 10px;
        }
        button {
            background: #008cba;
            color: white;
            border: none;
            padding: 10px 20px;
            cursor: pointer;
            border-radius: 5px;
            margin-top: 10px;
        }
        button:hover {
            background: #005f73;
        }
    </style>

</head>

<!-- END HEAD -->

<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">

    <div class="page-wrapper">

        <!-- start header -->

        <div class="page-header navbar navbar-fixed-top">

            <div class="page-header-inner ">

                <!-- logo start -->

                <div class="page-logo">

                    <a href="main_home.php">

                        <img src="../images/resources/logo.png">

                    </a>

                </div>

                <!-- logo end -->

                <ul class="nav navbar-nav navbar-left in">

                    <li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>

                </ul>

                

                <!-- start mobile menu -->

                <a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">

                    <span></span>

                </a>

               <!-- end mobile menu -->

                <!-- start header menu -->

                <div class="top-menu">

                    <ul class="nav navbar-nav pull-right">

                        

                        <!-- start manage user dropdown -->

                        <li class="dropdown dropdown-user">

                            <a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">

                                <i class="fa fa-user-o"></i>

                                <span class="username username-hide-on-mobile"> Admin </span>

                                <i class="fa fa-angle-down"></i>

                            </a>

                            <ul class="dropdown-menu dropdown-menu-default animated jello">

                                

                                <li>

                                    <a href="logout.php">

                                        <i class="icon-logout"></i> Log Out </a>

                                </li>

                            </ul>

                        </li>

                       

                    </ul>

                </div>

            </div>

        </div>

        <!-- end header -->

        

        <!-- start page container -->

        <div class="page-container">

 			<div class="sidebar-container">

                <div class="sidemenu-container navbar-collapse collapse fixed-menu">

                    <div id="remove-scroll">

                        <ul class="sidemenu  page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">

                            <li class="sidebar-toggler-wrapper hide">

                                <div class="sidebar-toggler">

                                    <span></span>

                                </div>

                            </li>

                            

                            <li class="nav-item start">

	                            <a href="main_home.php" class="nav-link nav-toggle">

	                                <i class="material-icons">dashboard</i>

	                                <span class="title">Dashboard</span>

                                	

	                            </a>

	                            

	                        </li>

                            <li class="nav-item">

                                <a href="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Stock Management</span> 

                                </a>

                            </li>

                            



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Members</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                             

                           

                             

                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Payout</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Kit Bank</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                     

                                    <li class="nav-item">

                                        <a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>

                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Product Management</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">

                                    <li class="nav-item">

                                        <a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>

                                        </a>

                                    </li>

                                    

                                    <li class="nav-item">

                                        <a href="billing.php" class="nav-link "> <span class="title">New Billing</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>

                                        </a>

                                    </li>

                                    <li class="nav-item">

                                        <a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>

                                        </a>

                                    </li>

                                    

                                </ul>

                            </li>



                            <li class="nav-item">

                                <a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Daily Updates</span> 

                                </a>

                            </li>

                            <li class="nav-item active">

                                <a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Gallery</span> 

                                </a>

                            </li>

                             

                            <li class="nav-item">

                                <a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Reward Eligible list</span> 

                                </a>

                            </li>

                             

                             

                             

                            <li class="nav-item">

                                <a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">KYC Documents</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">OLD DATA</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">NETWORK TREE</span> <span class="arrow"></span>

                                </a>

                                <ul class="sub-menu">



                                    

                                    

                                    <li class="nav-item">

                                        <a href="network.php" class="nav-link "> <span class="title">Seniority List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="network_search.php" class="nav-link "> <span class="title">Level List</span>

                                        </a>

                                    </li>



                                    <li class="nav-item">

                                        <a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>

                                        </a>

                                    </li>



                                    

                                    

                                    

                                    

                                </ul>

                            </li>

                             

                            <li class="nav-item">

                                <a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Coupon Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Personal Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Special Pv Update</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">SMS DETAILS</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">COMMITTEE DETAILS</span> 

                                </a>

                            </li>

                             

                            

                            <li class="nav-item">

                                <a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Notice Letter</span> 

                                </a>

                            </li>

                            

                            <li class="nav-item">

                                <a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Password</span> 

                                </a>

                            </li>



                            <li class="nav-item">

                                <a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>

                                    <span class="title">Change Trans Password</span> 

                                </a>

                            </li>

                           

                        </ul>

                    </div>

                </div>

            </div>

			<!-- start page content -->

            <div class="page-content-wrapper">

                <div class="page-content">

                    <div class="page-bar">

                        <div class="page-title-breadcrumb">

                           

                            <ol class="breadcrumb page-breadcrumb pull-right">

                                <li><i class="fa fa-home"></i>&nbsp;<a class="parent-item" href="main_home.php">Home</a>&nbsp;<i class="fa fa-angle-right"></i>

                                </li>

                                

                                </li>

                                <li class="active">Daily Updates</li>

                            </ol>

                        </div>

                    </div>

                    <div class="row">

                        <div class="col-md-6 col-sm-6">

                            <div class="card card-box">

                                

                                <div class="card-bodys " id="bar-parent">

                          
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f4;
            padding: 20px;
        }
        .form-horizontal {
            background: white;
            padding: 20px;
            border-radius: 8px;
            box-shadow: 0 0 10px rgba(0,0,0,0.1);
            max-width: 800px;
            margin: 0 auto;
        }
        .form-group {
            margin-bottom: 15px;
        }
        .form-control {
            width: 100%;
            padding: 8px;
            border: 1px solid #ddd;
            border-radius: 4px;
            box-sizing: border-box;
        }
        label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
        }
        .btn-primary {
            background-color: #007bff;
            color: white;
            border: none;
            padding: 10px 15px;
            border-radius: 4px;
            cursor: pointer;
        }
        .btn-primary:hover {
            background-color: #0069d9;
        }
        #video_uplader_container {
            display: none;
            margin-top: 20px;
            padding: 15px;
            background: #f8f9fa;
            border-radius: 5px;
        }
        .upload-container {
            width: 100%;
        }
        .drop-zone {
            border: 2px dashed #008cba;
            padding: 20px;
            cursor: pointer;
            background: #f9f9f9;
            position: relative;
            text-align: center;
            margin-bottom: 15px;
        }
        .drop-zone:hover {
            background: #e0f7fa;
        }
        .drop-zone input {
            display: none;
        }
        .progress-container {
            display: none;
            margin-top: 10px;
        }
        .progress-bar {
            width: 100%;
            height: 10px;
            background: #ddd;
            border-radius: 5px;
            overflow: hidden;
            margin-top: 10px;
        }
        .progress-bar div {
            height: 100%;
            width: 0%;
            background: #008cba;
            transition: width 0.3s;
        }
        .video-preview {
            display: none;
            margin-top: 10px;
            max-width: 100%;
        }
        .radio-group {
            display: flex;
            gap: 20px;
            margin-top: 10px;
        }
        .radio-option {
            display: flex;
            align-items: center;
            gap: 5px;
        }
    </style>
<form method="post" enctype="multipart/form-data" class="form-horizontal" id="galleryForm">
    <h4><b><u>Add New Gallery</u></b></h4>
    <div class="form-group">

        <div class="radio-group">
            <div class="radio-option">
                <input type="hidden" name="source" class="form-control" value="image" id="selectImage" checked>
            </div>
           
        </div>
    </div>

    <div class="form-group" id="imageUploadContainer">
        <label>Gallery Image</label>
        <input type="file" name="image" class="form-control" id="imageInput">
    </div>



    <button type="submit" name="submit" value="addMedia" class="btn-primary">Submit</button>
</form>




    


                                </div>

                            </div>

                        </div>
                        <div class="col-md-6 col-sm-6">

                            <div class="card card-box">

                                

                                <div class="card-bodys " id="bar-parent">

                          
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #f4f4f4;
            padding: 20px;
        }
        .form-horizontal {
            background: white;
            padding: 20px;
            border-radius: 8px;
            box-shadow: 0 0 10px rgba(0,0,0,0.1);
            max-width: 800px;
            margin: 0 auto;
        }
        .form-group {
            margin-bottom: 15px;
        }
        .form-control {
            width: 100%;
            padding: 8px;
            border: 1px solid #ddd;
            border-radius: 4px;
            box-sizing: border-box;
        }
        label {
            display: block;
            margin-bottom: 5px;
            font-weight: bold;
        }
        .btn-primary {
            background-color: #007bff;
            color: white;
            border: none;
            padding: 10px 15px;
            border-radius: 4px;
            cursor: pointer;
        }
        .btn-primary:hover {
            background-color: #0069d9;
        }
        #video_uplader_container {
            display: none;
            margin-top: 20px;
            padding: 15px;
            background: #f8f9fa;
            border-radius: 5px;
        }
        .upload-container {
            width: 100%;
        }
        .drop-zone {
            border: 2px dashed #008cba;
            padding: 20px;
            cursor: pointer;
            background: #f9f9f9;
            position: relative;
            text-align: center;
            margin-bottom: 15px;
        }
        .drop-zone:hover {
            background: #e0f7fa;
        }
        .drop-zone input {
            display: none;
        }
        .progress-container {
            display: none;
            margin-top: 10px;
        }
        .progress-bar {
            width: 100%;
            height: 10px;
            background: #ddd;
            border-radius: 5px;
            overflow: hidden;
            margin-top: 10px;
        }
        .progress-bar div {
            height: 100%;
            width: 0%;
            background: #008cba;
            transition: width 0.3s;
        }
        .video-preview {
            display: none;
            margin-top: 10px;
            max-width: 100%;
        }
        .radio-group {
            display: flex;
            gap: 20px;
            margin-top: 10px;
        }
        .radio-option {
            display: flex;
            align-items: center;
            gap: 5px;
        }
    </style>
   <form class="upload-container" id="videoForm" action="" method="post" enctype="multipart/form-data">
        <p><strong>Upload a Video</strong></p>
        <p>Allowed file types: MP4, WebM, OGG. Maximum size: 100 MB.</p>

        <div class="drop-zone" id="drop-zone">
            <p>Drag and drop a video here or <span style="color: #008cba; text-decoration: underline;">click to browse</span></p>
            <input type="file" id="videoInput" name="video" accept="video/*" hidden>
        </div>

        <input type="hidden" name="source" value="video" id="selectImage">

        <video id="videoPreview" class="video-preview" width="100%" controls style="display: none;"></video>

        <div class="progress-container" style="display: none;">
            <div class="progress-bar"><div></div></div>
        </div>

        <button id="uploadBtn" type="button" name="upload_video" value="add_video" disabled>Upload Video</button>
    </form>

    <div id="alertContainer" style="position: fixed; top: 20px; right: 20px; z-index: 1000;"></div>

    <script>
        const dropZone = document.getElementById('drop-zone');
        const videoInput = document.getElementById('videoInput');
        const uploadBtn = document.getElementById('uploadBtn');
        const progressBar = document.querySelector('.progress-bar div');
        const progressContainer = document.querySelector('.progress-container');
        const videoPreview = document.getElementById('videoPreview');

        let selectedFile = null;

        dropZone.addEventListener('click', () => videoInput.click());

        dropZone.addEventListener('dragover', (event) => {
            event.preventDefault();
            dropZone.style.background = '#e0f7fa';
        });

        dropZone.addEventListener('dragleave', () => {
            dropZone.style.background = '#f9f9f9';
        });

        dropZone.addEventListener('drop', (event) => {
            event.preventDefault();
            dropZone.style.background = '#f9f9f9';
            selectedFile = event.dataTransfer.files[0];
            previewVideo(selectedFile);
        });

        videoInput.addEventListener('change', () => {
            selectedFile = videoInput.files[0];
            previewVideo(selectedFile);
        });

        function previewVideo(file) {
            if (file && file.type.startsWith('video/')) {
                const fileURL = URL.createObjectURL(file);
                videoPreview.src = fileURL;
                videoPreview.style.display = 'block';
                uploadBtn.disabled = false;
            } else {
                alert('Please select a valid video file.');
                videoPreview.style.display = 'none';
                uploadBtn.disabled = true;
            }
        }

        uploadBtn.addEventListener('click', () => {
            if (!selectedFile) return;

            const formData = new FormData();
            formData.append('video', selectedFile);
            formData.append('upload_video', 'add_video');

            const xhr = new XMLHttpRequest();
            xhr.open('POST', '', true); // Replace '' with your PHP upload URL

            xhr.upload.onprogress = (event) => {
                if (event.lengthComputable) {
                    const percentComplete = (event.loaded / event.total) * 100;
                    progressBar.style.width = percentComplete + '%';
                    progressContainer.style.display = 'block';
                }
            };

            xhr.onload = () => {
                if (xhr.status === 200) {
                    try {
                        const response = JSON.parse(xhr.responseText);
                        alert(response.message);

                        if (response.status === "success") {
                            videoPreview.src = "";
                            videoPreview.style.display = "none";
                            progressContainer.style.display = "none";
                            uploadBtn.disabled = true;

                            const successMessage = document.createElement('div');
                            successMessage.textContent = "Video uploaded successfully!";
                            successMessage.style.color = "green";
                            successMessage.style.fontSize = "20px";
                            successMessage.style.marginTop = "20px";
                            document.body.appendChild(successMessage);
                              setTimeout(() => {
                                window.location.href = "gallery.php";
                            }, 1000);
                        }
                    } catch (e) {
                        alert(" Sccussfully Video Upload Completed");
                        window.location.href="gallery.php";
                    }
                } else {
                    alert('Error uploading file.');
                    window.location.href="gallery.php";
                }
            };

            xhr.onerror = () => alert('Upload failed. Please try again.');

            xhr.send(formData);
        });
    </script>


    


                                </div>

                            </div>

                        </div>

                    </div>
                    
                    
                    
                        <div class="row">

                        <div class="col-md-6 col-sm-6">

                            <div class="card card-box">

                                

                                <div class="card-bodys " id="bar-parent">

                          
 
    
<form method="post" enctype="multipart/form-data" class="form-horizontal" id="AdvertismentForm">
    <h4><b><u>Add Poster</u></b></h4>
    <div class="form-group" id="imageUploadContainer">
        <label>Advertisment Image</label>
        <input type="file" name="posterimage" class="form-control" id="posterimage">
    </div>



    <button type="submit" name="submit" value="addPoster" class="btn-primary">Submit</button>
</form>




    


                                </div>

                            </div>

                        </div>
                   

                    </div>









                    <div class="row">

                        <div class="col-md-12">

                            <div class="card card-topline-red">

                                <div class="card-head">

                                    <header>Gallery Details</header>

                                   

                                </div>

                                <div class="card-body ">

                                    

                                    <table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example4">

                                        <thead>

                                            <tr>

                                                <th>S.No</th>

                                                <th>Title</th>

                                                <th>Description</th>

                                                <th>Image</th>

                                                

                                                <th>Opreation</th>

                                                

                                            </tr>

                                        </thead>





                                        <tbody>

                                            <?php 

                                   

                                              $select_query = "select * from gallery";

                                              $run = mysqli_query($con,$select_query);

                                               $serial = 1;

                                               while ($row = mysqli_fetch_array($run)) {

                                                $s_num = $serial++;

                                                $gallery_id = $row['gallery_id'];

                                                $gallery_title = $row['title'];

                                                $gallery_image = $row['image'];

                                                $gallery_description = $row['description'];

                                                

                                                

                                                

                                           ?>

                                            <tr>

                                                <td><?= $s_num; ?></td>

                                                <td><?= $gallery_title; ?></td>

                                                <td><?= $gallery_description; ?></td>

                                                

                                                



                                                <td align="center"><img src="../gallery/<?= $gallery_image; ?>" width="50" height="50"></td>

                                                <td>

                                                

                                                



                                                



                                                <a href="includes/delete.php?gallery_id=<?= $gallery_id; ?>" class="btn btn-info waves-effect waves-light btn-danger m-b-5 btn-xs"><i class="fa fa-trash-o m-r-5"></i><span>Delete</span></a>

                                                

                                                </td>

                                                

                                            </tr>

                                            <?php } ?>

                                            

                                        </tbody>

                                    </table>

                                </div>

                            </div>

                        </div>

                    </div>

                    

                <!-- end page content -->

                

            </div>

            <!-- end page container -->

            <!-- start footer -->

            <div class="page-footer">

               <div class="page-footer-inner"> 2018 &copy; All Rights Reserved.

                    

                </div>

                <div class="scroll-to-top">

                    <i class="icon-arrow-up"></i>

                </div>

            </div>

            <!-- end footer -->

        </div></div>
        

        <!-- start js include path -->

        <script src="assets/plugins/jquery/jquery.min.js" ></script>

        <script src="assets/plugins/popper/popper.min.js" ></script>

        <script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>

		<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>

        <!-- bootstrap -->

        <script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>

        <!-- data tables -->

        <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>

        <script src="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.js" ></script>

        <script src="assets/js/pages/table/table_data.js" ></script>

        <!-- Common js-->

		<script src="assets/js/app.js" ></script>

        <script src="assets/js/layout.js" ></script>

		<script src="assets/js/theme-color.js" ></script>

		<!-- Material -->

		<script src="assets/plugins/material/material.min.js"></script>

	<!-- animation -->

	<script src="assets/js/pages/ui/animations.js" ></script>

        <!-- end js include path -->

</body>



</html>





<?php 



 if(isset($_POST['submit'])){

    

        

        $title = $_POST['title'];

        $description = $_POST['description'];

        

        



        $select_query_count = "select * from gallery";

        $run_count = mysqli_query($con,$select_query_count);



        $gallery_code = mysqli_num_rows($run_count) + 1;





        



        $image = $_FILES['image'] ['name'];

        $image_tmp = $_FILES['image'] ['tmp_name'];



        

        $image_name = $gallery_code ."_". $image;

        

        if($title=='' || $image==''){

        

        echo "<script>alert('some one feilds is empty please fill')</script>";

        exit();

        }



        else {

        

           

             move_uploaded_file($image_tmp, "../gallery/$image_name");

             $insert_query = "insert into gallery(title, description, image) values('$title', '$description', '$image_name')";

            if (mysqli_query($con,$insert_query)) {

                echo "<script>alert('Gallery Image has been successfully added...')</script>";

                echo "<script>window.open('gallery.php','_self')</script>";

            }

            

            

        

        }

       

    }





 ?>