["input", "", "", "text"], "product" => ["input", "", "", "text"], "price" => ["input", "", "", "text"], "payment_method" => ["input", "", "", "text"], "status" => ["input", "", "", "text"], "delievery_status" => ["input", "", "", "text"], );; if (isset($_POST['create_package'])) { $actionId = escape(($_POST['actionId'])); $customer = escape($_POST['customer']); $product = escape($_POST['product']); $price = escape($_POST['price']); $payment_method = escape($_POST['payment_method']); $status = escape($_POST['status']); $delievery_status = escape($_POST['delievery_status']); if ($actionId == "") { $id = generateRandomString(); $actionId = $id; $query = "insert into jeoXillityCrm_orders set id='$id' , customer='$customer', product='$product', price='$price', payment_method='$payment_method', status='$status', delievery_status='$delievery_status', timeAdded='$timeAdded'"; } else { $query = "update jeoXillityCrm_orders set id='$actionId' , customer='$customer', product='$product', price='$price', payment_method='$payment_method', status='$status', delievery_status='$delievery_status' where id='$actionId'"; } // echo $query; // exit; runQuery($query); header("Location: ?" . generateUrlParams_return(["m" => "Data was saved successfully!", "type" => "success"])); exit(); } if (isset($_GET['delete-record'])) { $id = escape($_GET['delete-record']); $query = "delete from jeoXillityCrm_orders where id='$id'"; runQuery($query); } $getData = getAll($con, "SELECT * FROM " . $g_projectSlug . "_users "); $users = []; foreach ($getData as $k => $v) { $users[$v['id']] = ucfirst($v['name']); } $productsData = getAll($con, "SELECT * FROM " . $g_projectSlug . "_products "); $productsName = []; foreach ($productsData as $k => $v) { $productsName[$v['id']] = ucfirst($v['title']); } ?>

All Order

New Record

Customer	Product	Price	Payment method	Status	Delievery status	Order Date	Actions