관리-도구

편집 파일: all-youtube_link.php

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

<head>
    <?php include('include/head_admin.php');
    if (isset($_GET['type']) && $_GET['type'] != '') {
        $type = get_safe_value($con, $_GET['type']);
        if ($type == 'status') {
            $operation = get_safe_value($con, $_GET['operation']);
            $id = get_safe_value($con, $_GET['id']);
            if ($operation == 'active') {
                $status = '1';
            } else {
                $status = '0';
            }
            $update_status_sql = "update `youtube_link` set status='$status' where id='$id'";
            mysqli_query($con, $update_status_sql);
        }

if ($type == 'delete') {
            $id = get_safe_value($con, $_GET['id']);

$delete_sql = "DELETE FROM `youtube_link` WHERE id='$id'";
            $result = mysqli_query($con, $delete_sql);
            header('location:all-youtube_link.php');
        }
    }

$sql = "select * from `youtube_link` ";
    $res = mysqli_query($con, $sql);
    ?>
</head>

<div class="page-wrapper compact-wrapper" id="pageWrapper">
        
        <?php include('include/header_admin.php'); ?>

<div class="page-body-wrapper">
            
            <?php include('include/sidebar_admin.php'); ?>

<div class="page-body">
                
                <div class="container-fluid">
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="card card-table">
                                <div class="card-body">
                                    <div class="title-header option-title">
                                        <h5>All Youtube Links</h5>
                                        <form class="d-inline-flex">
                                            <a href="add-youtube_link.php" class="align-items-center btn btn-theme d-flex">
                                                <i data-feather="plus-square"></i>Add New
                                            </a>
                                        </form>
                                    </div>

<div class="table-responsive youtube_link-table">
                                        <div>
                                            <table class="table all-package theme-table" id="table_id">
                                                <thead>
                                                    <tr>
                                                        <th>S. No.</th>
                                                        <th>Title</th>
                                                        <th>Option</th>
                                                    </tr>
                                                </thead>

<td>
                                                                <ul>
                                                                    <li>
                                                                        <a href="<?php echo $row['link'] ?>" target="_blank">
                                                                            <i class="ri-eye-line"></i>
                                                                        </a>
                                                                    </li>

</ul>
                                                            </td>
                                                        </tr>
                                                    <?php } ?>

</tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php include('include/footer_admin.php'); ?>
            </div>
            
        </div>

</div>

<?php include('include/foot_admin.php'); ?>
</body>

</html>