Skip to content
PHP Logo

Are there best practices for querying date and time data in MySQL using PHP?

When querying date and time data in MySQL using PHP, it's important to handle the data correctly to ensure accurate results. One common best practice is to use MySQL's built-in date and time functions to manipulate and format the data as needed. Additionally, it's recommended to properly sanitize user input to prevent SQL injection attacks.

php 
// Example of querying date and time data in MySQL using PHP
// Assuming $mysqli is the MySQLi connection object

// Get current date and time in MySQL format
$currentDateTime = date('Y-m-d H:i:s');

// Query to select records created after a specific date
$query = "SELECT * FROM table_name WHERE created_at > '$currentDateTime'";

// Execute the query
$result = $mysqli->query($query);

// Fetch and display results
while ($row = $result->fetch_assoc()) {
    echo $row['column_name'] . "<br>";
}

// Close the connection
$mysqli->close();

Related questions