File "newsletter.php"

Full Path: /home/sasslijg/public_html/admin/use.fontawesome.com/releases/newsletter.php
File size: 7.58 KB
MIME-type: text/x-php
Charset: utf-8

<?php

include("header.php");



$query="SELECT * from subscription";
$emails=db::getRecords($query);

?>


<section id="breadcrumb-alignment">
    <div class="row">
        <div class="col-sm-12">
            <div class="card">

                <div class="card-body">

                    <div class="d-flex justify-content-between breadcrumb-wrapper">
                        <nav aria-label="breadcrumb ">
                            <ol class="breadcrumb mt-2">
                                <li class="breadcrumb-item"><a href="javascript:void(0)"><i class='bx bx-home-alt mx-1'></i>Dashboard</a></li>
                                <li class="breadcrumb-item"><a href="javascript:void(0)">Newsletters</a></li>


                            </ol>

                        </nav>
                        <nav aria-label="breadcrumb ">
                            <div class="ml-auto">
                                <div class="btn-group">
                                    <button type="button" class="btn btn-success bg-success bg-darken-2 m-1 px-5" data-toggle="modal" data-target="#create-banner">Send Email</button>
                                </div>

                                <div class="modal fade" id="create-banner" tabindex="-1" role="dialog" aria-hidden="true">
                                    <div class="modal-dialog modal-dialog-centered">
                                        <div class="modal-content radius-30">
                                            <div class="modal-header bg-success bg-darken-2 border-bottom-0">
                                                <h3 class="text-white m-1">Send Email</h3>
                                                <button type="button" class="close" data-dismiss="modal" aria-label="Close">	<span aria-hidden="true">&times;</span>
                                                </button>
                                            </div>
                                            <div class="modal-body p-5">

                                                <form action="action.php" method="post" enctype="multipart/form-data">

                                                    <div class="form-group">
                                                        <label class="h4">Description</label>
                                                        <textarea type="text" name="description" rows="4" class="form-control form-control-lg radius-30" > </textarea>
                                                    </div>

                                                    <hr/>
                                                    <div class="form-group">
                                                        <button type="submit" class="btn bg-success bg-darken-2 text-white float-right radius-30 btn-lg"  name="send_newsletter" >Submit</button>
                                                    </div>
                                                </form>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </nav>

                    </div>


                </div>
            </div>
        </div>
    </div>
</section>
<!-- Breadcrumb Alignment Ends -->


<div class="card">
    <div class="card-body">

        <!-- Row grouping -->
        <section id="row-grouping-datatable">
            <div class="row">
                <div class="col-12">
                    <div class="card">
                        <div class="card-title">
                            <h2 class="mb-0 text-center h1 text-primary uppercase">Newsletters</h2>
                        </div>
                        <hr>
                        <div class="card-datatable">
                            <table id="example" class="table   table-bordered" style="width:100%">
                                <thead>
                                    <tr class="text-center">

                                        <th class="text-center">#</th>   
                                        <th class="text-center">Subscribe Email</th>
                                        <th class="text-center">Action</th>


                                    </tr>
                                </thead>
                                <tbody>
                                    <?php
                                    $count1=0;
                                    if($emails!=NULL)
                                    {
                                        foreach($emails as $email)
                                        {
                                            $count1++;
                                    ?> 
                                    <tr>
                                       
                                        <td class="text-center"><?php echo $count1; ?></td>
                                        <td class="text-center"> <?php echo $email['subscribe_email']; ?></td>
                                        <td class="text-center"> 
                                            <a class="btn btn-pinterest m-1" title="Delete" onclick="delete_newsletter('<?php echo $email['id']; ?>')"><i class="bx bx-trash"></i></a>
                                        </td>
                                     
                                    </tr> <?php 
                                        } 

                                    }
                                    else{
                                        echo"Data is not Found!!";
                                    }
                                    ?>
                                  
                                </tbody>
                                <tfoot>

                                </tfoot>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </section>
        <!--/ Row grouping -->

    </div>
</div>

<!-- Modal -->
<div class="modal fade" id="delete_modal" data-backdrop="false" tabindex="-1" role="dialog" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content  border-0">
            <div class="modal-header bg-danger bg-darken-2 border-bottom-0">
                <h5 class="modal-title" style="color:white;">Delete</h5>

                <button type="button" class="close" data-dismiss="modal" aria-label="Close">	<span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form action="action.php" method="POST">
                    <div class="modal-body">
                        <p class="text-danger" >Are You Sure to Delete This</p>
                    </div>
                    <input type="text" id="delete_email" name="delete_email" hidden>
                    <div class="modal-footer border-top-0">
                        <button type="button" class="btn btn-primary" data-dismiss="modal">Cancel</button>
                        <button type="submit" name="delete_newsletter" class="btn btn-outline-danger">Delete</button>
                    </div>
                </form>
            </div>

        </div>
    </div>
</div>


<?php
include("footer.php");
?>

<script>
    function delete_newsletter(email)
    {
        document.getElementById("delete_email").value=email;

        $("#delete_modal").modal('show'); 
    }


</script>