관리-도구

편집 파일: all-itinerary.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 `itinerary` 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 `itinerary` WHERE id='$id'";
            mysqli_query($con, $delete_sql);
            header('location:all-itinerary.php');
        }
    }

$sql = "select * from itinerary 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 d-sm-flex d-block">
                                        <h5>Itinerarys List</h5>
                                        <div class="right-options">
                                            <ul>
                                                
                                                <li>
                                                    <a class="btn btn-solid" href="add-itinerary.php">Add Itinerary</a>
                                                </li>
                                            </ul>
                                        </div>
                                    </div>
                                    <div>
                                        <div class="table-responsive">
                                            <table class="table all-itinerary theme-table table-itinerary" id="table_id">
                                                <thead>
                                                    <tr>
                                                        <th>#</th>
                                                        <th>Package</th>
                                                        
                                                        <th>Option</th>
                                                    </tr>
                                                </thead>

<?php
                                                            $package = $row['package'];
                                                            $sql1 = "SELECT * FROM `package` WHERE `id` = '$package'";
                                                            $res1 = mysqli_query($con, $sql1);
                                                            $row1 = mysqli_fetch_assoc($res1);
                                                            ?>
                                                            <td><?php echo $row1['name'] ?></td>

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