咨询：无Node.js时WordPress服务器每5分钟执行JavaScript方案

Hey there, let's tackle this problem step by step. Your initial approach of loading a JS file in the footer has two big issues: every visitor triggers the API call (wasting resources) and it won't run if no one's on the site. Since Node.js isn't an option, we can use server-side scheduling with tools that are already available on most WordPress hosts.

The good news is we don't need client-side JS at all here—we can handle the API call and database insertion directly with PHP on the server, which is far more efficient for this use case.

方案一：使用WordPress自带的WP-Cron（推荐） #

WP-Cron is WordPress's built-in scheduling system. While it's "pseudo-cron" (triggered by site visits), we can pair it with a system cron to fix the no-visits problem.

步骤1：添加定时任务代码到主题functions.php #

Add this code to your active theme's functions.php file (or a custom plugin for better portability):

// 注册自定义的5分钟定时间隔
function custom_cron_schedules( $schedules ) {
    $schedules['every_five_minutes'] = array(
        'interval' => 300, // 5分钟 = 300秒
        'display'  => __( 'Every 5 Minutes' ),
    );
    return $schedules;
}
add_filter( 'cron_schedules', 'custom_cron_schedules' );

// 主题激活时注册定时任务
function activate_custom_cron() {
    if ( ! wp_next_scheduled( 'custom_api_fetch_event' ) ) {
        wp_schedule_event( time(), 'every_five_minutes', 'custom_api_fetch_event' );
    }
}
register_activation_hook( __FILE__, 'activate_custom_cron' );

// 主题停用时清除定时任务
function deactivate_custom_cron() {
    wp_clear_scheduled_hook( 'custom_api_fetch_event' );
}
register_deactivation_hook( __FILE__, 'deactivate_custom_cron' );

// 核心处理函数：调用API并插入数据库
function custom_fetch_api_and_store() {
    // 替换为你的API地址
    $api_url = 'https://your-api-endpoint.com/data';
    
    // 使用CURL调用API（如果CURL禁用，可改用file_get_contents）
    $ch = curl_init();
    curl_setopt( $ch, CURLOPT_URL, $api_url );
    curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true );
    curl_setopt( $ch, CURLOPT_TIMEOUT, 10 ); // 设置超时时间
    $response = curl_exec( $ch );
    curl_close( $ch );

    if ( $response ) {
        $data = json_decode( $response, true );
        // 验证API返回的JSON是否有效
        if ( json_last_error() === JSON_ERROR_NONE && ! empty( $data ) ) {
            global $wpdb;
            // 替换为你的自定义数据库表名（记得加WordPress前缀）
            $table_name = $wpdb->prefix . 'your_custom_table';

            // 根据API返回的字段调整插入逻辑，这里仅作示例
            $wpdb->insert(
                $table_name,
                array(
                    'item_title' => sanitize_text_field( $data['title'] ),
                    'item_content' => wp_kses_post( $data['content'] ),
                    'created_at' => current_time( 'mysql' ) // 使用WordPress的当前时间
                ),
                array(
                    '%s', // 字符串类型
                    '%s',
                    '%s'
                )
            );
        }
    }
}
add_action( 'custom_api_fetch_event', 'custom_fetch_api_and_store' );

步骤2：确保定时任务可靠运行 #

If your site gets very little traffic, WP-Cron might not trigger on time. Fix this by setting up a system-level cron job to trigger WP-Cron every 5 minutes:

1. Log into your server via SSH or use your host's control panel (like cPanel's Cron Jobs tool)
2. Add this command (replace with your site's URL):

*/5 * * * * wget -q -O - https://your-wordpress-site.com/wp-cron.php?doing_wp_cron > /dev/null 2>&1

Or use curl if wget isn't available:

*/5 * * * * curl -s https://your-wordpress-site.com/wp-cron.php?doing_wp_cron > /dev/null 2>&1

方案二：直接使用系统Cron执行独立PHP脚本 #

If you prefer to bypass WP-Cron entirely, create a standalone PHP script that loads the WordPress environment and runs your task.

步骤1：创建独立脚本 #

Create a file named wp-api-fetch.php in your WordPress root directory with this content:

<?php
// 加载WordPress核心环境，这样可以使用$wpdb等函数
require_once( dirname( __FILE__ ) . '/wp-load.php' );

// 调用API（和方案一的逻辑一致）
$api_url = 'https://your-api-endpoint.com/data';
$ch = curl_init();
curl_setopt( $ch, CURLOPT_URL, $api_url );
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true );
curl_setopt( $ch, CURLOPT_TIMEOUT, 10 );
$response = curl_exec( $ch );
curl_close( $ch );

if ( $response ) {
    $data = json_decode( $response, true );
    if ( json_last_error() === JSON_ERROR_NONE && ! empty( $data ) ) {
        global $wpdb;
        $table_name = $wpdb->prefix . 'your_custom_table';

        $wpdb->insert(
            $table_name,
            array(
                'item_title' => sanitize_text_field( $data['title'] ),
                'item_content' => wp_kses_post( $data['content'] ),
                'created_at' => current_time( 'mysql' )
            ),
            array( '%s', '%s', '%s' )
        );
    }
}
?>

步骤2：设置系统Cron #

Add this cron job (replace the path with your actual WordPress directory):

*/5 * * * * php /var/www/html/your-wordpress/wp-api-fetch.php > /dev/null 2>&1

You can find your PHP CLI path with which php if you're unsure.

关键注意事项 #

• Security: Make sure your API endpoint is secure (use HTTPS) and the standalone script (if using) is protected from public access (you can add IP restrictions or a secret key parameter).
• Error Handling: Add logging to debug issues (e.g., write errors to a log file or use WordPress's error_log() function).
• Database Table: Ensure your custom database table exists—you can create it via a plugin or a one-time SQL query.

内容的提问来源于stack exchange，提问作者MrScf