GET_POSTS/WP_QUERY耗尽134217728字节的内存大小

我想获取我的产品页面的所有帖子ID。但无论是第一种方法还是第二种方法都是成功的。。。

我总是得到：

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 8388616 bytes) in /var/www/vhosts/httpdocs/wp-includes/wp-db.php on line 1842

第一种方式：

if ( ! defined(\'ABSPATH\') ) {
    /** Set up WordPress environment */
    require_once( dirname( __FILE__ ) . \'/wp-load.php\' );
}

$posts_array = get_posts(array(
            \'post_type\' => \'product\',
            \'posts_per_page\' => -1
        ));

$myfile = fopen("wp_all_import.txt", "a");

foreach ($posts_array as $value) {
    fwrite($myfile, $posts_array . "\\n");
}

fclose($myfile);

第二种方式：

if ( ! defined(\'ABSPATH\') ) {
    /** Set up WordPress environment */
    require_once( dirname( __FILE__ ) . \'/wp-load.php\' );
}

$products_IDs = new WP_Query( array(
            \'post_type\' => \'product\',
            \'posts_per_page\' => -1
        ));
$myfile = fopen("wp_all_import.txt", "a");

while ($products_IDs->have_posts() ) : $products_IDs->the_post();
fwrite($myfile, get_the_ID() . "\\n");
endwhile; wp_reset_query();

fclose($myfile);

有人知道我的失败在哪里吗？我怎样才能弥补？我只想获取我的产品帖子的所有帖子ID。

问候并感谢您！

if ( ! defined(\'ABSPATH\') ) { /** Set up WordPress environment */ require_once( dirname( __FILE__ ) . \'/wp-load.php\' ); } // $limit determines how many rows you want to handle at any given time // increase / decrease this limit to see how much your server can handle at a time $limit = 100; $start = 0; // open file handle $myfile = fopen( dirname( __FILE__ ) . \'/wp_all_import.txt\', \'a\' ); $qry = "SELECT ID FROM `$wpdb->posts` where post_type=\'post\' AND post_status=\'publish\' limit %d, %d"; while( $result = $wpdb->get_results( $wpdb->prepare( $qry, array( $start, $limit ) ) ) ) { $write_data = \'\'; foreach ( $result as $row ) { $write_data = $write_data . $row->ID . "\\n"; } // Generally speaking, writing immidiately to the file is better than // string concatination, because depending on what you concat and how many times, // the generated string may become too big (like MB size string). // On the other hand, writing to files thousands of times in a single script may // cause I/O delays. So, here I\'ve done a combination of the two to keep both // string size & I/O within limits. // Adjust this according to your own situation. fwrite( $myfile, $write_data ); $start = $start + $limit; } // close file handle fclose( $myfile );

未执行Cronjob函数-负秒数

我创建了一个自定义函数，用于读取XML文件并将其导入woocommerce产品。XML文件每天由外部平台在网站ftp中导出。我将wordpress cronjob替换为真正的cronjob，cronjob实际上调用了函数，但函数从未执行过（参见屏幕截图）。我的职能：<?php /** * DynamiX Child Theme Functions * Load languages directory for translation */ fu

相关推荐

未执行Cronjob函数-负秒数