Something went wrong. Try again.
Open source inventory management system with php and mysql Invoice generation and easy to download invoice in PDF format Lightweight and ea…
Something went wrong. Try again.
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253<?php
require_once 'core.php';
if($_POST) {
$startDate = $_POST['startDate']; $date = DateTime::createFromFormat('m/d/Y',$startDate); $start_date = $date->format("Y-m-d");
$endDate = $_POST['endDate']; $format = DateTime::createFromFormat('m/d/Y',$endDate); $end_date = $format->format("Y-m-d");
$sql = "SELECT * FROM orders WHERE order_date >= '$start_date' AND order_date <= '$end_date' and order_status = 1"; $query = $connect->query($sql);
$table = ' <table border="1" cellspacing="0" cellpadding="0" style="width:100%;"> <tr> <th>Order Date</th> <th>Client Name</th> <th>Contact</th> <th>Grand Total</th> </tr>
<tr>'; $totalAmount = ""; while ($result = $query->fetch_assoc()) { $table .= '<tr> <td><center>'.$result['order_date'].'</center></td> <td><center>'.$result['client_name'].'</center></td> <td><center>'.$result['client_contact'].'</center></td> <td><center>'.$result['grand_total'].'</center></td> </tr>'; $totalAmount += $result['grand_total']; } $table .= ' </tr>
<tr> <td colspan="3"><center>Total Amount</center></td> <td><center>'.$totalAmount.'</center></td> </tr> </table> ';
echo $table;
}
?>