Nx

Filename: ebrochure.php

<?php
    $title = "Orion | E-Brochure";
	require_once('includes/header.php');

$ip=$_SERVER['REMOTE_ADDR'];
    $date1 = date('Y-m-d H:i:s'); 
    $user_id  = $_SESSION['user_id'];
    if(isset($_GET['id'])){
        $id = $_GET['id'];
        $email = $_GET['email'];
        GetResultSet("DELETE FROM brochure WHERE id='$id'");

GetResultSet("INSERT INTO `audit_trial`(`date1`, `billno`, `event`, `amount`, `user_id`, `lnk`, `ip`) VALUES ('$date1', '$email', 'DELETE BROCHURE', '', '$user_id', 'ebrochure.php', '$ip')");

redirect("ebrochure.php");
    }

?>
<div class="wrapper">
    <div class="container-fluid">
        
        <div class="row">
            <div class="col-sm-12">
                <div class="page-title-box">
                    <div class="btn-group pull-right">
                        <ol class="breadcrumb hide-phone p-0 m-0">
                            <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                            <li class="breadcrumb-item active"><a href="ebrochure.php">E-Brochure</a></li>
                        </ol>
                    </div>
                    <h4 class="page-title">E-Brochure</h4>
                </div>
            </div>
        </div>

<div class="row">
            <div class="col-12">
                <div class="card m-b-30">
                    <div class="card-body">
                        
                        <table class="table table-hover table-responsive-sm">
                            <thead class="thead-default" style="background-color: #eee;">
                                <tr>
                                    <th>Option</th>
                                    <th>Name</th>
                                    <th>Email</th>
                                    <th>Contact</th>
                                    <th>Date</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php 
                                $result = GetResultSet("SELECT * FROM brochure ORDER BY id ASC");
                                $i=0;
                                // $result_arr = mysqli_fetch_all($result,MYSQLI_ASSOC);
                                // foreach ($result_arr as $list) {
                                while($list = mysqli_fetch_assoc($result)){
                                    $i++;
                                    ?>
                                    <tr>
                                        <td>
                                            <a href="ebrochure.php?id=<?php echo $list['id']; ?>&email=<?php echo $list['email']; ?>" class="text-danger mx-1 user_right_delete" onclick="return conf_del();"><i class="fa fa-trash" style="font-size: 20px;"></i></a>
                                        </td>
                                        <td><?php echo $list['name'];?></td>
                                        <td><?php echo $list['email']; ?></td>
                                        <td><?php echo $list['contact']; ?></td>
                                        <td><?php echo $list['date1']!=''?date('d-m-Y',strtotime($list['date1'])):''; ?></td>
                                    </tr>
                                    <?php 
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div> 
        </div>

</div> 
</div>
<?php
	require_once('includes/footer.php');
?>
<script type="text/javascript">
    function conf_del(){
        var a = confirm("Do you really want to Delete?");
        if(a==true){
            return true;
        }else{
            return false;
        }
    }
</script>