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';
