Skip to content
PHP Logo

When using variables in a LIMIT query in PHP, what are some common mistakes to avoid?

When using variables in a LIMIT query in PHP, a common mistake is not properly sanitizing or validating the input, which can lead to SQL injection vulnerabilities. To avoid this, always sanitize and validate user input before using it in a query. Additionally, ensure that the variable used in the LIMIT clause is an integer to prevent unexpected behavior.

php
// Example of using variables in a LIMIT query with proper validation

// Assuming $offset and $limit are user input variables
$offset = isset($_GET['offset']) ? intval($_GET['offset']) : 0;
$limit = isset($_GET['limit']) ? intval($_GET['limit']) : 10;

// Sanitize and validate the input
if ($offset < 0) {
    $offset = 0;
}
if ($limit < 1) {
    $limit = 10;
}

// Use the variables in the LIMIT query
$query = "SELECT * FROM table_name LIMIT $offset, $limit";