<?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);