What are best practices for filtering and querying birthdates stored in a database using PHP?

When filtering and querying birthdates stored in a database using PHP, it's important to properly format the date strings and use SQL functions like DATE_FORMAT or DATE() to compare dates accurately. It's also recommended to sanitize user input to prevent SQL injection attacks. 

// Example of filtering birthdates in a database query
$userInput = "1990-05-15"; // User input for birthdate
$birthdate = date('Y-m-d', strtotime($userInput)); // Format user input as date string

// Sanitize the input to prevent SQL injection
$birthdate = mysqli_real_escape_string($conn, $birthdate);

// Query to retrieve users born after a certain date
$query = "SELECT * FROM users WHERE birthdate > '$birthdate'";
$result = mysqli_query($conn, $query);

// Process the query results
if(mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo "User: " . $row['name'] . " - Birthdate: " . $row['birthdate'] . "<br>";
    }
} else {
    echo "No users found with birthdate after $birthdate";
}

Keywords

filtering querying birthdates database PHP

Related Questions