if ($prev_model != $arr[0]) { $prev_model = $arr[0]; $query = "DELETE FROM products_plant WHERE products_model = '".$arr[0]."'"; if (deleteFrom($query)) if (mysql_affected_rows() > 0) echo "Sizes deleted for plant = ".$arr[0].'<br />'; } $query = "SELECT * FROM ".products_plant." WHERE products_model='".$arr[0]."' AND plant_maat='".$arr[3]."'"; if (recordExists($query)) { if ($arr[7] == 'DELETE') //Status { $query = "DELETE FROM products_plant WHERE products_model='".$arr[0]."' AND plant_maat = '".$arr[3]."'"; if (deleteFrom($query)) echo "Record Delete for the plant = ".$arr[0]." AND plant_mmat = ".$arr[3]."<br />"; } else { // Update the record $query = "UPDATE products_plant SET plant_sort='".$arr[1]."',plant_mc='".$arr[2]."',plant_description='".$arr[4]."',plant_price='".$arr[5]."',plant_vrij='".$arr[6] ."' WHERE products_model='".$arr[0]."' AND plant_maat='".$arr[3]."'"; if (updateRecord($query)) { echo "Record Updated for the plant ='".$arr[0]."' AND plant_maat=".$arr[3]."<br>"; } } } elseif ($arr[7] != 'DELETE') { $arr = array_slice($arr, 0, 7); //First 7 values; // Add new record $sql = "insert into products_plant (products_model, plant_sort, plant_mc, plant_maat, plant_description, plant_price, plant_vrij) values ('".implode("','", $arr)."')"; mysql_query ($sql);
<?php include_once '../../config/config.php'; include_once $serverPath . 'utils/db_post.php'; if (!empty($_GET['faceBookID'])) { $table = "photos"; $insert = "DELETE FROM " . getTableQuote($table) . " WHERE faceBookID=" . $_GET['faceBookID'] . ";"; runInsert($insert); } if (!empty($_GET['carousel_image_id'])) { $table = "carousel_images"; deleteFrom($table, $_GET['carousel_image_id']); }
<?php include_once '../../config/config.php'; include_once $serverPath . 'utils/db/db_post.php'; if (!empty($_GET['id'])) { $table = "dungeon"; deleteFrom($table, $_GET['id']); }
<?php include_once '../config/config.php'; include_once $serverPath . 'utils/security/requireAdmin.php'; include_once $serverPath . 'utils/db/db_post.php'; include_once $serverPath . 'utils/db/db_get.php'; $_POST = json_decode(file_get_contents('php://input'), true); if (!empty($_POST) && !empty($_POST['id']) && $_POST['id'] != $_SESSION['user']['id']) { $id = $_POST['id']; $table = "users"; $user = findById($table, $id); if ($user['protected'] == '0') { deleteFrom($table, $id); } }