Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
GARAGE
/
php_action
:
fetchOrderData.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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);