function magicalInsert($row) { // send the appropriate data to insert customer $customer = array_slice($row, 0, 14, true); print_r("customer"); print_r($customer); $CID = dbInsertNewCustomer($customer); // send the appropriate data to insert order $order = array_slice($row, 14, 19, true); print_r("order"); print_r($order); $OID = dbInsertNewOrder($CID, $order); // send the appropriate data to insert items $products = array_slice($row, 33, 1, true); $items = $products["Products"]; foreach ($items as $item) { print_r("item"); print_r($item); dbInsertNewItem($OID, $item); } }
function addOrderToDataBase($CID, $data) { global $SETTINGS; $OID = dbInsertNewOrder($CID, translateOrderInfo($data)); $item = array(); for ($i = 1; $i <= $SETTINGS["MaxItems"]; $i++) { $item["PKID"] = $data["packages{$i}"]; $item["Personality"] = $data["personality{$i}"]; $item["Quantity"] = $data["quantity{$i}"]; if ($item["Quantity"] != 0) { $IID = dbInsertNewItem($OID, $item); } } return $OID; }
function dbReplaceOrder($CID, $row) { return dbInsertNewOrder($CID, $row, true); }