kohjhjhصثقصثقصثقgdfgdg
Ele57885fddfgdfgfghgقفغفغفقhfg555434536
/
home
/
u402332945
/
domains
/
simmar.co.in
/
public_html
/
Admin-Panel
/
Upload FileeE
HOME
<?php header("Content-Type: application/xls"); header("Content-Disposition: attachment; filename=Application Form.xls"); header("Pragma: no-cache"); header("Expires: 0"); include 'db.php'; $name = $_POST['name']; $name1 = $_POST['name1']; $name2 = $_POST['name2']; $orderItemSql = "SELECT customer_order.id, customer_order.p_name,customer_order.p_price, customer_order.p_qty,customer_order.total, customer_order.daty, cust.name, cust.email, cust.phonenumr, cust.address FROM customer_order INNER JOIN cust ON customer_order.tr_id = cust.order_id WHERE customer_order.daty >= '$name1' AND customer_order.daty <= '$name2' and customer_order.uid ='$name' and customer_order.status ='Credit'"; $sql = $db->query($orderItemSql); ?> <!DOCTYPE html> <html lang="en"> <!-- Mirrored from thememinister.com/crm/clist.html by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 03 Oct 2019 15:43:24 GMT --> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Customer Management</title> </head> <body> <table id="example" class="display" style="width:100%" border="1"> <thead > <tr class="info"> <th>S.No</th> <th>Date</th> <th>Name</th> <th>Email</th> <th>Phone Numbers</th> <th>Address</th> <th>Product name</th> <th>Price</th> <th>Quantity</th> <th>Total</th> </tr> </thead> <tbody> <?php $subTotal1z = ""; $subTotal1z = 0; $subTotal2 = ""; $subTotal2 = 0; $i = 1; while($row = $sql->fetch_array()) { ?> <tr> <td><center><?php echo $i;?></center></td> <td><center><?php echo $row['5'];?></center></td> <td><center><?php echo $row['6'];?></center></td> <td><center><?php echo $row['7'];?></center></td> <td><center><?php echo $row['8'];?></center></td> <td><center><?php echo $row['9'];?></center></td> <td><center><?php echo $row['1'];?></center></td> <td><center><?php echo $row['2'];?></center></td> <td><center><?php echo $row['3'];?></center></td> <td><center><?php echo $row['4'];?></center></td> </tr> <?php $i++; $subTotal1z += $row[4]; $subTotal2 += $row[3]; } ?> <tr> <td colspan="9"><center>Total Amount</center></center></td> <td><center><center><?php echo $subTotal1z;?></center></center></td> </tr> <tr> <td colspan="8"><center>Quantity</center></center></td> <td><center><center><?php echo $subTotal2;?></center></center></td> </tr> </tbody> </table> </body> <!-- Mirrored from thememinister.com/crm/clist.html by HTTrack Website Copier/3.x [XR&CO'2014], Thu, 03 Oct 2019 15:44:01 GMT --> </html>