<?php
session_start();
include '../assets/constant/config.php';

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

<?php include('include/sidebar.php'); ?>
<!-- Top Bar End -->
<?php include('include/header.php'); ?>

<!--  connect author at mdkhairnar92@gmail.com  -->
<div class="page-content-wrapper ">

    <div class="container-fluid">

        <div class="row">
            <div class="col-sm-12">
                <div class="page-title-box">
                    <div class="btn-group float-right">
                        <a href="send_email.php" class="btn btn-primary mb-3">Send Email</a>
                    </div>
                    <h4 class="page-title">Send Email</h4>
                </div>
            </div>
            <div class="clearfix"></div>
        </div>
        <!-- end page title end breadcrumb -->

        <div class="row">
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-body">
                        <div class="table-responsive">

                            <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;" >
                                <thead>
                                    <tr>
                                        
                                         <th>Send By</th>

                                         <th>Email</th>
                                         <th>Message </th>
                                         <th>date</th>
                                         <!-- <th>Action</th> -->
                                        
                                    </tr>
                                </thead>
                                <tbody>

                        <?php
                                   $stmt = $conn->prepare("SELECT m.name AS sender_name, s.to_member, s.message, s.date FROM send_email s INNER JOIN member m ON s.id = m.id WHERE s.delete_status='0'"); 
                        // $stmt = $conn->prepare("SELECT m.name, s.to_member, s.message,s.date FROM member m INNER JOIN send_email s ON m.id = s.member_id AND s.delete_status='0' ");
                                    $stmt->execute();
                                    $record = $stmt->fetchAll();
                                    // $i = 1;
                                    foreach ($record as $key) { ?>


                                        <tr>

                                            <!-- <td><?php echo $i; ?></td> -->
                                           <td> <?php echo $key['sender_name']; ?></td> 
                                           <td> <?php echo $key['to_member']; ?></td>
                                           <td> <?php echo $key['message']; ?></td> 
                                          <td> <?php echo $key['date']; ?></td> 
                                              

                                               <!-- <td>

                                              <a href="#" class="btn btn-danger" onclick="return confirm('Are you sure you want to delete this item?') && delForm(event, <?php echo $key['id'];?>,'app/email_crud.php');"><i class="fa fa-trash-alt" aria-hidden="true"></i></a>

                                            </td> -->
                                        </tr>
                                    <?php 
                                    } ?>
                                </tbody>
                               

                            </table>

  </div><!--end /tableresponsive-->
                    </div><!--end card-body-->
                </div><!--end card-->
            </div><!--end col-->


        </div><!--end row-->

 </div> <!-- Page content Wrapper -->

</div> <!-- content -->

<?php include('include/footer.php'); ?>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor or Laravel website or software development contact me at mayuri.infospace@gmail.com  -->

