header('Content-Type: text/html');
include "storedInfo.php";
//contains hostname/username/password/databasename
include "globalConstants.php";
include "sqloperationfunctions.php";
if (isset($_POST['redirect'])) {
$redirect = $_POST['redirect'];
} else {
$redirect = 'skateboards';
}
if (!isset($_POST['skid']) || !isset($_POST['rid'])) {
fishy('the board and rider must be set', $redirect);
}
if (isset($_POST['delete'])) {
$query = "DELETE FROM sk8_riders_skateboards WHERE fk_skateboard_id = ? AND fk_rider_id = ?";
$create = "deleted";
} else {
$query = "INSERT INTO sk8_riders_skateboards(fk_skateboard_id,fk_rider_id) VALUES (?,?) ";
$create = "created";
}
$stmt = $mysqli->prepare($query);
$stmt->bind_param('ii', $_POST['skid'], $_POST['rid']);
$stmt->execute();
if ($stmt->errno) {
$error = $stmt->error;
$number = $stmt->errno;
$stmt->close();
fishy($error, $redirect);
}
$stmt->close();
redirect("rider/skateboard relationship {$create}", $redirect);
<?php
ini_set('display_errors', 'On');
include "storedInfo.php";
//contains hostname/username/password/databasename
include "globalConstants.php";
include "sqloperationfunctions.php";
//delete skateboard
$delStmt = $mysqli->prepare("DELETE from sk8_riders WHERE id=?");
$delStmt->bind_param('i', $_POST['id']);
$delStmt->execute();
if (!$mysqli->errno) {
$delStmt->close();
redirect('Rider Removed', 'riders');
} else {
$delStmt->close();
fishy("database error: {$mysqli->errno}", 'riders');
}
?>
<?php
ini_set('display_errors', 'On');
header('Content-Type: text/html');
include "storedInfo.php";
//contains hostname/username/password/databasename
include "globalConstants.php";
include "sqloperationfunctions.php";
if (!isset($_POST['rider_name']) || $_POST['rider_name'] == '') {
fishy('you must set a name', 'riders');
}
$stmt = $mysqli->prepare("INSERT INTO sk8_riders (rider_name) VALUES (?) ");
$stmt->bind_param('s', $_POST['rider_name']);
$stmt->execute();
if ($stmt->errno) {
$error = $stmt->error;
$number = $stmt->errno;
$stmt->close();
fishy($error, 'riders');
}
$stmt->close();
if (isset($_POST['rider_url']) && $_POST['rider_url'] != '') {
//update img url
$last_id = $mysqli->insert_id;
$stmt = $mysqli->prepare("UPDATE sk8_riders SET rider_img_url=? WHERE id=?");
$stmt->bind_param('si', $_POST['rider_url'], $last_id);
$stmt->execute();
$stmt->close();
}
redirect("{$_POST['rider_name']} added to riders", 'riders');
function exit_in_error($stmt)
{
$msg = $stmt->error;
$stmt->close();
fishy($msg, 'inventory');
}
<?php
ini_set('display_errors', 'On');
header('Content-Type: text/html');
include "storedInfo.php";
//contains hostname/username/password/databasename
include "globalConstants.php";
include "sqloperationfunctions.php";
if (!isset($_POST['brand_name']) || $_POST['brand_name'] == '') {
fishy('you must set a name', 'inventory');
}
$stmt = $mysqli->prepare("INSERT INTO sk8_brand (brand_name, brand_img_url) VALUES (?,?) ");
$stmt->bind_param('ss', $_POST['brand_name'], $_POST['brand_url']);
$stmt->execute();
if ($stmt->errno) {
$error = $stmt->error;
$number = $stmt->errno;
$stmt->close();
if ($number == 1062) {
fishy("{$_POST['brand_name']} was already added to brands", 'inventory');
}
fishy($error, 'inventory');
}
$stmt->close();
redirect("{$_POST['brand_name']} added to brands", 'inventory');
<a href="build.php">
<button type="button" class="btn btn-warning">
<span class="glyphicon glyphicon-backward"> </span> Go Back (Cancel Build)
</button>
</a>
<button type="submit" class="btn btn-danger">
<span class="glyphicon glyphicon-wrench"> </span>Dissasemble Board(s) and Build new Board
</button>
</form>
</body>
</html>
<?php
exit;
}
$stmt->close();
fishy($error, 'build');
}
$stmt->close();
if (isset($_POST['board_img_url']) && $_POST['board_img_url'] != '') {
//update img url
$last_id = $mysqli->insert_id;
$stmt = $mysqli->prepare("UPDATE sk8_skateboards SET board_img_url=? WHERE id=?");
$stmt->bind_param('si', $_POST['board_img_url'], $last_id);
$stmt->execute();
$stmt->close();
}
redirect("{$_POST['board_name']} added to skateboards", 'skateboards');
<?php
ini_set('display_errors', 'On');
include "storedInfo.php";
//contains hostname/username/password/databasename
include "globalConstants.php";
include "sqloperationfunctions.php";
//delete skateboard
$delStmt = $mysqli->prepare("DELETE from sk8_skateboards WHERE id=?");
$delStmt->bind_param('i', $_POST['id']);
$delStmt->execute();
if (!$mysqli->errno) {
$delStmt->close();
redirect('Skateboard disasembles', 'skateboards');
} else {
$delStmt->close();
fishy("database error: {$mysqli->errno}", 'skateboards');
}
?>
fishy("how did you ask to delete from:{$_POST['table']}", 'inventory');
}
$table = $_POST['table'];
//delete item
$delStmt = $mysqli->prepare("DELETE from sk8_{$table}_inv WHERE id=?");
$delStmt->bind_param('i', $_POST['id']);
$delStmt->execute();
//foriegn key constraint violated
if ($mysqli->errno == 1451) {
$delStmt->close();
$skStmt = $mysqli->prepare("SELECT id,board_name from sk8_skateboards where fk_{$table}_id=?");
$skStmt->bind_param('i', $_POST['id']);
$skStmt->execute();
$skStmt->bind_result($id, $name);
$skStmt->fetch();
$skStmt->close();
$boardmessage = "cannot delete this part right now because it is being used on skateboard: \"{$name}\"";
redirect($boardmessage, 'inventory');
} else {
if (!$mysqli->errno) {
$delStmt->close();
//delete type if there are no more instances of it
$delStmt = $mysqli->prepare("DELETE from sk8_{$table}_type where id not in (select fk_{$table}_id from sk8_{$table}_inv);");
$delStmt->execute();
$delStmt->close();
redirect('Item Deleted', 'inventory');
} else {
$delStmt->close();
fishy("database error: {$mysqli->errno}", 'inventory');
}
}
