• File: fetchOrderData.php
  • Full Path: /home/dealkatnwc/www/GARAGE/php_action/fetchOrderData.php
  • Date Modified: 12/11/2023 3:34 PM
  • File size: 566 bytes
  • MIME-type: text/x-php
  • Charset: utf-8
<?php 	

require_once 'core.php';

$orderId = $_POST['orderId'];

$valid = array('order' => array(), 'order_item' => array());

$sql = "SELECT orders.order_id, orders.order_date, orders.client_name, orders.client_contact, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, orders.payment_type, orders.payment_status FROM orders 	
	WHERE orders.order_id = {$orderId}";

$result = $connect->query($sql);
$data = $result->fetch_row();
$valid['order'] = $data;


$connect->close();

echo json_encode($valid);