php 月末

// 示例代码：统计一个月内的订单数量
$startDate = mktime(0, 0, 0, date('m'), 1, date('Y'));
$endDate = mktime(23, 59, 59, date('m'), date('t'), date('Y'));

$sql = "SELECT COUNT(*) as total_orders FROM orders WHERE order_date BETWEEN ? AND ?";
$stmt = $pdo->prepare($sql);
$stmt->execute([$startDate, $endDate]);
$result = $stmt->fetch(PDO::FETCH_ASSOC);

echo "Total orders this month: " . $result['total_orders'];

// 示例代码：异步生成报告
use Pheanstalk\Pheanstalk;

$pheanstalk = new Pheanstalk('127.0.0.1');

$data = ['type' => 'report', 'month' => date('m'), 'year' => date('Y')];
$pheanstalk->useTube('report_generator')->put(json_encode($data));

echo "Report generation started asynchronously.";

// 示例代码：使用Cron定时执行数据库备份
// 在Linux系统中，编辑Cron表并添加以下行：
// 0 0 * * * /usr/bin/php /path/to/backup_script.php

// backup_script.php
$pdo = new PDO('mysql:host=localhost;dbname=mydb', 'username', 'password');
$backupFile = 'backup_' . date('Y-m-d_H-i-s') . '.sql';

$sql = "mysqldump --user=username --password=password --databases=mydb > $backupFile";
exec($sql);

echo "Database backup completed: $backupFile";