function deletFrom($table, $id) { $insert = "DELETE FROM " . $table . " WHERE id=" . $id . ";"; runInsert($insert); }
<?php require_once '../../config/config.php'; require_once $serverPath . 'utils/requireLogin.php'; require_once $serverPath . 'utils/dataUpdateInsert.php'; //Simple enough will delete a credit card of the logged in user given an id from the url if (!empty($_GET['id'])) { $table = "cc_info"; $insert = "DELETE FROM " . $table . " WHERE id=" . $_GET['id'] . " AND user_id=" . $_SESSION['user']['id'] . ";"; runInsert($insert); }
function deleteFrom($table, $id) { $insert = "DELETE FROM " . getTableQuote($table) . " WHERE id=" . $id . ";"; runInsert($insert); }
$table = "messages"; if (!empty($_POST)) { $data = ['message' => $_POST['message'], 'sent_to' => $_POST['services.user_id'], 'sent_from' => $_SESSION['user']['id']]; if (empty($_GET['id'])) { insert($table, $data); $added = true; header("Location: index.php"); die("Redirecting to index.php"); } else { //Normal update cannot be used here becuase it would allow anyone who is logged in to update anyone elses prank $update = "UPDATE " . $table . " SET "; foreach ($data as $columnName => $value) { $update .= $columnName . "='" . $value . "', "; } $update = substr($update, 0, strlen($update) - 2) . " WHERE id=" . $_GET['id'] . " AND user_id=" . $_SESSION['user']['id'] . ";"; runInsert($update); header("Location: index.php"); die("Redirecting to index.php"); } } ?> <div class="container-fluid"> <div class="panel panel-default"> <div class="panel-heading clearfix"> <h3 class="panel-title pull-left">My Messages</h3> </div> <div class="panel-body"> <p>Here is where messages will go between <?php $query1 = 'select prank.user_id, services.user_id from services inner join prank on services.prank_id=prank.id where services.user_id=' . $_SESSION['user']['id'] . ';'; $results1 = runQuery($query1); echo json_encode($results1);
function importMenuData($menuData) { global $table; foreach ($menuData as $menuDataRow) { $currentMenuItem = findByProperty($table, "name", $menuDataRow['name']); if ($currentMenuItem == null) { $menuItemImportOrUpdateStatement = getMenuItemImportStatement($menuDataRow); } else { $menuItemImportOrUpdateStatement = getMenuUpdateStatement($menuDataRow); } runInsert($menuItemImportOrUpdateStatement); } }