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 = ' '; $totalAmount = ""; while ($result = $query->fetch_assoc()) { $table .= ''; $totalAmount += $result['grand_total']; } $table .= '
Order Date Client Name Contact Grand Total
'.$result['order_date'].'
'.$result['client_name'].'
'.$result['client_contact'].'
'.$result['grand_total'].'
Total Amount
'.$totalAmount.'
'; echo $table; } ?>