How to query the data in the table before 11 o'clock on the same day in php

PHP is a very popular programming language that can handle database operations very well. In actual projects, we sometimes need to query the data in the database before 11 o'clock that day. So how to achieve it?

1. Get the current date and 11 o'clock timestamp

Use the PHP built-in function time() to get the current timestamp. We can calculate the timestamp of 11 o'clock that day.

$current_time = time(); // 当前时间戳
$eleven_time = strtotime(date('Y-m-d 11:00:00')); // 今天11点的时间戳

2. Connect to the database

In PHP, you can use the PDO (PHP Data Objects) or mysqli function to connect to the database. Here we take PDO as an example to connect.

$dsn = 'mysql:host=localhost;dbname=test';
$username = 'root';
$password = '123456';
$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
try {
    $pdo = new PDO($dsn, $username, $password, $options);
} catch(PDOException $e) {
    echo '连接失败：' . $e->getMessage();
    exit;
}

3. Query the data before 11 o'clock on the day

With the above two steps, we can start querying the database.

$sql = "SELECT * FROM `table` WHERE `create_time` prepare($sql);
$stmt->bindParam(':eleven_time', $eleven_time);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);

We pass the 11 o'clock timestamp as a parameter to the SQL statement, and use the operator to query all data in the table that was created before 11 o'clock that day.

4. Complete code

The complete code is as follows:

$current_time = time(); // 当前时间戳
$eleven_time = strtotime(date('Y-m-d 11:00:00')); // 今天11点的时间戳

$dsn = 'mysql:host=localhost;dbname=test';
$username = 'root';
$password = '123456';
$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
try {
    $pdo = new PDO($dsn, $username, $password, $options);
} catch(PDOException $e) {
    echo '连接失败：' . $e->getMessage();
    exit;
}

$sql = "SELECT * FROM `table` WHERE `create_time` prepare($sql);
$stmt->bindParam(':eleven_time', $eleven_time);
$stmt->execute();
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);

print_r($data);

5. Summary

Through the above code, we can very conveniently query the database for 11 days of the day data before the point. PDO is used here to connect to the database, which is not only safe and reliable, but also more convenient to write code. Of course, if you are used to using mysqli functions, you can also try it.

It is worth noting that in actual projects, we should prevent SQL injection. Both PDO and mysqli provide measures such as prepared statements to prevent SQL injection. We should pay attention to this when writing code.

The above is the detailed content of How to query the data in the table before 11 o'clock on the same day in php. For more information, please follow other related articles on the PHP Chinese website!