1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ultrabio / nirvakam /
Filename : video.php
back
<?php
session_start();
include "../includes/config.php";

if (isset($_SESSION['login']) && $_SESSION['login'] == 'true') {

    $video_id = '';
    $update_mode = false;

    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
        $video_id = $_POST['video_id'];

        if (isset($_POST['update_id'])) {
            $update_id = $_POST['update_id'];
            $sql = "UPDATE video SET video_id='$video_id' WHERE id='$update_id'";
            if ($conn->query($sql) === TRUE) {
            } else {
                echo "<div class='alert alert-danger'>Error: " . $conn->error . "</div>";
            }
        } else {
            $sql = "INSERT INTO video (video_id, status) VALUES ('$video_id', 1)";
            if ($conn->query($sql) === TRUE) {
				header("Location: video.php");
                exit;
            } else {
                echo "<div class='alert alert-danger'>Error: " . $conn->error . "</div>";
            }
        }
    }

    if (isset($_GET['delete_id'])) {
        $delete_id = $_GET['delete_id'];

        $sql = "UPDATE video SET status = 0 WHERE id = '$delete_id'";
        if ($conn->query($sql) === TRUE) {
        } else {
            echo "<div class='alert alert-danger'>Error: " . $conn->error . "</div>";
        }
    }

    if (isset($_GET['edit_id'])) {
        $edit_id = $_GET['edit_id'];
        $result = $conn->query("SELECT * FROM video WHERE id='$edit_id'");
        if ($result->num_rows > 0) {
            $row = $result->fetch_assoc();
            $video_id = $row['video_id'];
            $update_mode = true;
        }
    }
?>

    <?php include "includes/header.php"; ?>
    <?php include "includes/leftmenu.php"; ?>
    <?php include "includes/topbar.php"; ?>

    <div class="container-fluid">
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb my-0 ms-2">
                <li class="breadcrumb-item"><a href="">Home</a></li>
                <li class="breadcrumb-item active"><span>Video Create</span></li>
            </ol>
        </nav>
    </div>

    <div class="body flex-grow-1 px-3">
        <div class="container-lg">
            <div class="card mb-4">
                <div class="card-header"><?php echo $update_mode ? 'Update Video' : 'Create Video'; ?></div>
                <div class="card-body">

                    <form method="POST" action="" enctype="multipart/form-data" id="formId">
                        <div class="row">
                            <div class="mb-3 col-md-6">
                                <label class="form-label" id="file_name" for="video_id">Video Id</label>
                                <input class="form-control" id="video_id" type="text" name="video_id" value="<?php echo $video_id; ?>" placeholder="Enter Video id" required />
                                <?php
                                if ($update_mode) {
                                    echo "<input type='hidden' name='update_id' value='" . $edit_id . "'>";
                                }
                                ?>
                            </div>
                        </div>
                        <button type="submit" class="btn btn-primary btn-block">
                            <?php echo $update_mode ? 'Update' : 'Submit'; ?>
                        </button>
                    </form>

                    <table class="table mt-5">
                        <thead class="table-dark">
                            <tr>
                                <th scope="col">S.No</th>
                                <th scope="col">Video Id</th>
                                <th scope="col">Edit</th>
                                <th scope="col">Delete</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $result = $conn->query("SELECT * FROM video WHERE status = 1");
                            if ($result->num_rows > 0) {
                                $i = 1;
                                while ($row = $result->fetch_assoc()) {
                                    echo "<tr>";
                                    echo "<td>" . $i++ . "</td>";
                                    echo "<td>" . $row['video_id'] . "</td>";
                                    echo "<td><a href='video.php?edit_id=" . $row['id'] . "'>Edit</a></td>";
                                    echo "<td><a href='video.php?delete_id=" . $row['id'] . "' onclick='return confirm(\"Are you sure delete this video?\");'>Delete</a></td>";
                                    echo "</tr>";
                                }
                            } else {
                                echo "<tr><td colspan='4'>No records found.</td></tr>";
                            }
                            ?>
                        </tbody>
                    </table>

                </div>
            </div>
        </div>


        <?php include "includes/footer.php"; ?>

    <?php
} else {
    header("location:index.php");
}
    ?>