1#@!#!123s

: / home / shubmkcj / designpitara.com / admin /
Filename : lead-inquiry.php
back
<?php
    include("include/config.php");
    include("include/sessionhandle.php");
    include("include/header.php");
?>

<style>
    #lead_inquiry {
        background-color: #eb6a4e;
        color: #fff;
    }

    #lead_inquiry a {
        color: #fff !important;
    }

    #lead_inquiry a:hover {
        background-color: #eb6a4e !important;
    }

</style>

<div class="small-header">
    <div class="hpanel">
        <div class="panel-body">
            <div id="hbreadcrumb" class="pull-right">
                <ol class="hbreadcrumb breadcrumb">
                    <li><a href="<?php echo $admin_baseurl . 'dashboard.php';?>">Dashboard</a></li>
                    <li class="active">
                        <span>Inquiry</span>
                    </li>
                </ol>
            </div>
            <h2 class="font-light m-b-xs">
                View All Lead Inquiry
            </h2>

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



<div class="content">
    <div class="hpanel">
        <div class="panel-heading hbuilt">
            <div class="panel-tools">
                <a class="showhide"><i class="fa fa-chevron-up"></i></a>
                <a class="fullscreen"><i class="fa fa-expand"></i></a>
            </div>
            View All Lead Inquiry
        </div>
        <div class="panel-body">
            <div class="table-responsive">
                <table id="all_lead_inquiryz" class="table table-striped table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Name</th>
                            <th>Phone</th>
                            <th>Email</th>
                            <th>Message</th>
                            <th>other</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>

                        <?php
        $srno = 0;
        $sqlAssign1 = "SELECT * FROM `lead_inquiry` ORDER BY `lead_inquiry`.`id` DESC";										
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $id = $rows['id'];
                $s_name = $rows['name'];
				$s_phone = $rows['phone'];
				$s_email = $rows['email'];
				$s_message = $rows['message'];
				$s_other = $rows['other'];
				$s_status = $rows['status'];
                
?>
                        <tr>
                            <th scope="row"><?php echo $srno += 1;?></th>

                            <td><?php echo $s_name;?></td>
                            <td><?php echo $s_phone;?></td>
                            <td><?php echo $s_email;?></td>
                            <td><?php echo $s_message;?> </td>
                            <td><?php echo $s_other;?></td>




                            <td>
                                <div class="action_btns">
                                    <!--
									<form method="post" action="update-services.php?id=<?php echo $id;?>">
										<button type="submit" class="actionbtn"><i class="fa fa-pencil-square-o text-success" aria-hidden="true"></i></button>
									</form>
-->

                                    <form method="post" action="execute.php?id=<?php echo $id;?>">
                                        <button type="submit" name="delete_lead_inquiry" class="actionbtn" onclick="return confirm('Do you want to delete this data?')"><i class="fa fa-trash text-danger" aria-hidden="true"></i></button>
                                    </form>


                                    <?php if($s_status == 'active'){?>
                                    <form method="post" action="execute.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_deactive_lead_inquiry" class="actionbtn"><i class="fa fa-toggle-on text-success" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }else{?>
                                    <form method="post" action="execute.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_active_lead_inquiry" class="actionbtn"><i class="fa fa-toggle-off text-danger" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }?>
                                </div>
                            </td>
                        </tr>
                        <?php }}?>

                    </tbody>
                </table>
            </div>
        </div>

    </div>
</div>

<br>
<?php 
    include('include/footer.php');
?>