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