function deleteBroker($handler, $brokerId) { $brokerInfo = getBasicBrokerInfo($handler, $brokerId); $trucks = mysql_query("SELECT * FROM truck WHERE brokerId = {$brokerId}", $handler); while ($truck = mysql_fetch_assoc($trucks)) { deleteTruck($handler, $truck['truckId']); } $drivers = mysql_query("SELECT * FROM driver WHERE brokerId = {$brokerId}", $handler); while ($driver = mysql_fetch_assoc($drivers)) { deleteDriver($handler, $driver['driverId']); } deleteAddress($handler, $brokerInfo['addressId']); mysql_query("DELETE FROM broker WHERE brokerId = '{$brokerId}'", $handler); return $brokerId; }
<?php include_once '../function_header.php'; include '../common_server_functions.php'; //print_r($_REQUEST); $response = array(); $item = $_REQUEST['itemId']; if ($item == '') { die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR')); } if (getItemTicketCount($conexion, $item) > 0) { die(wrapError(ERROR_CODE_INVALID_VALUE, 'The item you want to delete has assigned tickets. Please delete the tickets first.')); } //die(wrapError(-2,'Feature not ready')); $itemId = deleteTruck($conexion, $item); mysql_close($conexion); echo wrapSubmitResponse(0, $item);
<?php include_once '../function_header.php'; include '../common_server_functions.php'; //print_r($_REQUEST); $response = array(); $truck = $_REQUEST['truckId']; if ($truck == '') { die(wrapError(ERROR_CODE_FIVE, 'INTERNAL ERROR')); } if (getTruckTicketCount($conexion, $truck) > 0) { die(wrapError(ERROR_CODE_INVALID_VALUE, 'The truck you want to delete has assigned tickets. Please delete the tickets first.')); } //die(wrapError(-2,'Feature not ready')); $truckId = deleteTruck($conexion, $truck); mysql_close($conexion); echo wrapSubmitResponse(0, $truck);
if ($db->affected_rows != 1) { // affected rows doesn't match up echo '<p>Error: Total rows affected: ' . $db->affected_rows . ' is not 1.</p>'; break; } // everything's good, it worked - display feedback echo '<p>The record has been saved.</p>'; break; // PROCESS // PROCESS case 'DELETE': // delete record // verify id is present if (empty($id)) { // display feedback and bail echo '<p>Error: Invalid ID.</p>'; break; // terminate case } if (deleteTruck($db, $id)) { // display success feedback echo '<p>The record was successfully deleted.</p>'; } else { // query error echo '<p>Unable to delete record.</p>'; } break; // DELETE } // switch include 'footer.php';