How to query data within the last hour using PHP

In web development, it is often necessary to obtain the latest data from the database and display it to the user. Sometimes we need to get data from the last few minutes or hours. In this article, I will introduce how to query the data within the last 1 hour using PHP.

First, we need to connect to the database. Here, I will use MySQL as the example database. The following is the sample code to connect to a MySQL database:

<?php $servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

In this example, we use the mysqli object to connect to the database. After the connection is successful, we can use the mysqli_query() function to execute SQL query statements. Next, we need to construct a SQL query to obtain the data for the last hour.

<?php $current_date = date(&#39;Y-m-d H:i:s&#39;);
$one_hour_before = date(&#39;Y-m-d H:i:s&#39;, strtotime(&#39;-1 hour&#39;));

$sql = "SELECT * FROM table_name WHERE created_at BETWEEN &#39;$one_hour_before&#39; AND &#39;$current_date&#39;";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Created At: " . $row["created_at"]. "<br>";
    }
} else {
    echo "0 results";
}
mysqli_close($conn);
?>

In this example, we first get the current date and time, and then use the strtotime() function to get the date and time 1 hour ago. We then build a SQL query using the BETWEEN operator to get data created between these two dates and times. Finally, we use the mysqli_fetch_assoc() function to get the query results and output them.

The above code can be adjusted and modified according to your own project needs, such as changing the name of the data table, changing the name of the timestamp field, etc. When using the code provided in this article, be sure to perform good code security checks to ensure database security.

By using these codes, we can easily query the data in the last 1 hour in PHP and display it to the user. This will help improve user experience and make the website more useful.

The above is the detailed content of How to query data within the last hour using PHP. For more information, please follow other related articles on the PHP Chinese website!