Home  >  Article  >  Backend Development  >  How to query the data in the table before 11 o'clock on the same day in php

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

PHPz
PHPzOriginal
2023-04-19 09:20:42550browse
<p>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? </p> <p>1. Get the current date and 11 o'clock timestamp</p> <p>Use the PHP built-in function <code>time()</code> to get the current timestamp. We can calculate the timestamp of 11 o'clock that day. </p> <pre class="brush:php;toolbar:false">$current_time = time(); // 当前时间戳 $eleven_time = strtotime(date('Y-m-d 11:00:00')); // 今天11点的时间戳</pre> <p> 2. Connect to the database </p> <p> In PHP, you can use the <code>PDO (PHP Data Objects) </code> or <code>mysqli</code> function to connect to the database. Here we take PDO as an example to connect. </p> <pre class="brush:php;toolbar:false">$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; }</pre> <p>3. Query the data before 11 o'clock on the day</p> <p>With the above two steps, we can start querying the database. </p> <pre class="brush:php;toolbar:false">$sql = "SELECT * FROM `table` WHERE `create_time` < :eleven_time"; $stmt = $pdo->prepare($sql); $stmt->bindParam(':eleven_time', $eleven_time); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC);</pre> <p>We pass the 11 o'clock timestamp as a parameter to the SQL statement, and use the <code><</code> operator to query all data in the table that was created before 11 o'clock that day. </p><p>4. Complete code</p><p>The complete code is as follows:</p><pre class="brush:php;toolbar:false">$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` < :eleven_time"; $stmt = $pdo->prepare($sql); $stmt->bindParam(':eleven_time', $eleven_time); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); print_r($data);<p>5. Summary</p> <p>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. </p> <p>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. </p></code></p>

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn