관리-도구

편집 파일: user_query.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 `query` 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 `query` WHERE id='$id'";
            mysqli_query($con, $delete_sql);

header('location:user_query.php');
            // $delete_sql = "delete from query where id='$id'";
            // mysqli_query($con, $delete_sql);
        }
    }

$sql = "select * from `query` order by id desc";
    $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 User Query</h5>
                                        
                                    </div>

<div class="table-responsive category-table">
                                        <div>
                                            <table class="table all-package theme-table" id="table_id">
                                                <thead>
                                                    <tr>
                                                        <th>S. No.</th>
                                                        <th>Date</th>
                                                        <th>Name</th>
                                                        <th>Phone</th>
                                                        <th>Email</th>
                                                        <th>Subject</th>
                                                        <th>Message</th>
                                                        <th>Option</th>
                                                    </tr>
                                                </thead>

</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>