function processRequestConfirmed($page_id, $cid, $request) { switch ($request) { case "delete": dbCustomerDelete($cid); foreach (dbGetOrdersForCustomer($cid) as $stuff) { foreach ($stuff as $order) { print_r(dbGetOrdersForCustomer($cid)); dbOrderDelete($order["OID"]); } } break; default: echo "Dude. Somehow there was a bad request.\n"; } }
function dbGetCustomersSummary($sort, $reverse) { $hadError = false; $con = dbConnect(); if ($con == null) { return null; } if ($reverse) { $reverse = "DESC"; } else { $reverse = "ASC"; } #still needs OIDs!!!!! $sql = "SELECT customers.CID, \n customers.Title,\n customers.FirstName,\n customers.LastName,\n customers.City,\n customers.State,\n customers.Country,\n customers.MetDate,\n customers.CustomerCNotes\n FROM customers\n ORDER BY {$sort} {$reverse};"; $result = mysqli_query($con, $sql); if (!$result) { dbErrorMsg("Error during sql query in dbGetCustomersSummary" . mysqli_error($con)); $hadError = true; } else { $returnArray = array(); while ($row = mysqli_fetch_assoc($result)) { dbCustomerNormalize2PHP($row); $row["OID"] = dbGetOrdersForCustomer($row["CID"]); if ($row["State"] == 'ZZ') { $row["State"] = '-'; } $returnArray[] = $row; } mysqli_free_result($result); } dbClose($con); if ($hadError) { return null; } else { return $returnArray; } }