Num - Add-cart.php

https://vintage-books.com/add-cart.php?num=12

A request to add-cart.php?num=1.1 returns a MySQL error: "Unknown column '1.1' in 'where clause'" — SQL injection confirmed. add-cart.php num

$product_id = filter_input(INPUT_POST, 'product_id', FILTER_VALIDATE_INT, ['options' => ['min_range' => 1]]); $quantity = filter_input(INPUT_POST, 'quantity', FILTER_VALIDATE_INT, ['options' => ['min_range' => 1, 'max_range' => 99]]); if (!$product_id || !$quantity) http_response_code(400); die('Invalid request'); https://vintage-books

// Vulnerable code $id = $_GET['num']; $result = mysqli_query($conn, "SELECT * FROM products WHERE id = $id"); An attacker submits: add-cart.php?num=1 UNION SELECT username, password FROM users-- $_SESSION['last_cart_action'] = time()

// In the form that calls add-cart $_SESSION['csrf_token'] = bin2hex(random_bytes(32)); echo '<input type="hidden" name="csrf_token" value="'.$_SESSION['csrf_token'].'">'; // In add-cart.php if (!hash_equals($_SESSION['csrf_token'], $_POST['csrf_token'])) die('CSRF attack detected');

$stmt = $conn->prepare("SELECT price, stock FROM products WHERE id = ? AND active = 1"); $stmt->bind_param("i", $product_id); $stmt->execute(); Principle 4: Implement CSRF Tokens Since you are modifying state (the cart), every request must include a unique token.

$_SESSION['last_cart_action'] = time(); Use this checklist to test if your add-cart.php script is secure.