1#@!#!123s

: / home / shubmkcj / designpitara.com / admin / book-appointment /
Filename : index.php
back
<?php
    include("../include/config.php");
    include("../include/sessionhandle.php");
    include("../include/header.php");
?>
<style>
    #job_pos2 ul li:nth-child(1) {
        background-color: #eb6a4e;
    }

    #job_pos2 ul li:nth-child(1) a {
        color: #fff;
    }

    #job_pos2 ul li:nth-child(1) a:hover {
        background-color: #eb6a4e;
    }

    #srkproperty_details .course-detailsa img {
        width: 100% !important;
        max-height: 250px !important;
    }

</style>
<script>
    window.onload = function() {
        document.getElementById('job_pos2').classList.add("active");
        document.getElementById('job_post21').classList.add("in");
    };

</script>

<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>Book Appointment</span>
                    </li>
                </ol>
            </div>
            <h2 class="font-light m-b-xs">
                Book Appointment Enquiry
            </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 Book Appointment Enquiry
        </div>
        <div class="panel-body">
            <div class="table-responsive">
                <table id="userPermission_dataTable" class="table table-striped table-bordered table-hover">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Candidate Summary</th>
                            <th>Atachment</th>
                            <th>Message</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>

                        <?php
        $srno = 0;
        $sqlAssign1 = "SELECT * FROM `book_appointment` ORDER BY `book_appointment`.`id` DESC";			
//                   echo $sqlAssign1;     
        $resultAssign1 = mysqli_query($conn, $sqlAssign1);											
        if (mysqli_num_rows($resultAssign1) > 0) {
            while($rows = mysqli_fetch_assoc($resultAssign1)) { 
                
                $id = $rows['id'];
                $rname = $rows['name'];
				$remail = $rows['email'];
                $rphone = $rows['phone'];
                $rmessage = $rows['messg'];
                $rresume = $rows['resume_file'];
                $t_status = $rows['status'];
             

                
?>
                        <tr>
                            <th scope="row"><?php echo $srno += 1;?></th>


                            <td style="text-align:left">
                                <p><b>Name : </b><?php echo $rname;?></p>
                                <br>
                                <p><b>Email : </b><?php echo $remail;?></p>
                                <br>
                                <p><b>Phone : </b><?php echo $rphone;?></p>
                              
                            </td>
                            <td>
                                <a href="<?php echo $main_baseurl . "book-a-design-appointment/upload/".$rresume ;?>" download>Download</a>
                               
                            </td>
                            <td>
                                <a type="button" course-details='<?php echo $rmessage;?>' data-toggle="modal" data-target="#srkproperty_details" class="btn theme-btn show_property_details" style="cursor: pointer;">More Detail</a>
                            </td>


                            <td>
                                <div class="action_btns">

<!--
                                    <form method="post" action="update-jobs-details.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-jobs-enquiry.php?id=<?php echo $id;?>">
                                        <button type="submit" name="delete_jobs_enquiry" 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($t_status == 'active'){?>
                                    <form method="post" action="execute-jobs-enquiry.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_deactive_jobs" class="actionbtn"><i class="fa fa-toggle-on text-success" aria-hidden="true"></i></button>
                                    </form>
                                    <?php }else{?>
                                    <form method="post" action="execute-jobs-enquiry.php?id=<?php echo $id;?>">
                                        <button type="submit" name="status_active_jobs" 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');
?>