1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com / demo /
Filename : carco_booking_list.php
back
<?php
include("header.php");
if(isset($_SESSION['login'])){
include "top.php";
include("main.php");

?>

<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.css">
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap4.min.css">
</head>

<div class="page-container">
<div class="main-content">

<?php
$sql = "select c.id,i.invoice_id,i.invoice,c.booking_date,c.booked_by FROM `carco_booking_details` c, invoice i where c.invoice_id = i.invoice_id";
$result = $conn->query($sql);
?>
<div class="section__content section__content--p30">
<div class="row">
<div class="col-lg-12">
    <div class="table-responsive table--no-card m-b-30">
         <center><h3 style="background-color:white; padding: 1%">Cargo Booking Details</h3></center>
        <table class="table table-borderless table-striped table-earning" id="example">
            <thead>
                <tr>
                    <th>S.NO</th>
                    <th>Invoice No #</th>
                    <th>Booked Date</th>
                    <th>Booked By</th>
                    <th><center>Actions</center></th>
                </tr>                       
            </thead>
            <tbody>
                                            
<?php 
	$sno='1';
	while($row=$result->fetch_assoc()) { 
?>
		<tr>
		    <td><?=$sno; $sno++;?></td>
		    <td><?php echo $row['invoice']; ?></td>
		    <td><?php echo date('d-m-Y',strtotime($row['booking_date']));?></td>
		    <td><?php echo $row['booked_by'];?></td>

			<td>
				<center>

			    	<a href="view_carco_booking_details.php?cid=<?php echo $row["id"];?>"><i class="fa fa-eye" aria-hidden="true"></i></a>
			   
			    </center>
			</td>
			</tr>
<?php } ?>

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

<script src="vendor/jquery-3.2.1.min.js"></script>
<script src="vendor/animsition/animsition.min.js"></script>
<script src="js/main.js"></script>

<!-- date table -->
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>  
<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>
<script type="text/javascript">
   $(document).ready(function() {
    $('#example').DataTable();
    } );
</script>




<?php 
}
else
{
    header ('location:index.php');
}

?>