php7查询记录数,php查询最近30天、7天、每天、昨天、上个月的记录 php多表联合查询 php查询系统 php多条件查...
时间: 2024-01-07 20:05:54 浏览: 15
您想了解如何在 PHP7 中查询记录数、查询最近30天、7天、每天、昨天、上个月的记录,多表联合查询以及多条件查询。以下是一些示例代码供您参考:
1. 查询记录数:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询记录数
$result = mysqli_query($conn, "SELECT COUNT(*) as count FROM table");
$row = mysqli_fetch_assoc($result);
$count = $row['count'];
echo "总共有 " . $count . " 条记录";
```
2. 查询最近30天的记录:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询最近30天的记录
$result = mysqli_query($conn, "SELECT * FROM table WHERE date >= DATE(NOW()) - INTERVAL 30 DAY");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
3. 查询最近7天的记录:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询最近7天的记录
$result = mysqli_query($conn, "SELECT * FROM table WHERE date >= DATE(NOW()) - INTERVAL 7 DAY");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
4. 查询每天的记录:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询每天的记录
$result = mysqli_query($conn, "SELECT DATE(date) as day, COUNT(*) as count FROM table GROUP BY DAY(date)");
while ($row = mysqli_fetch_assoc($result)) {
echo $row['day'] . "有" . $row['count'] . "条记录";
}
```
5. 查询昨天的记录:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询昨天的记录
$result = mysqli_query($conn, "SELECT * FROM table WHERE date = DATE(NOW()) - INTERVAL 1 DAY");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
6. 查询上个月的记录:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 查询上个月的记录
$result = mysqli_query($conn, "SELECT * FROM table WHERE MONTH(date) = MONTH(NOW()) - 1 AND YEAR(date) = YEAR(NOW())");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
7. 多表联合查询:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 多表联合查询
$result = mysqli_query($conn, "SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.table1_id");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
8. 多条件查询:
```php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database");
// 多条件查询
$result = mysqli_query($conn, "SELECT * FROM table WHERE column1 = 'value1' AND column2 = 'value2'");
while ($row = mysqli_fetch_assoc($result)) {
// 处理每一条记录
}
```
希望这些示例代码能够帮助到您。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)