WordPress 对自定义的sql查询结果进行缓存

使用场景：首页调用最新评论、自定义获取最*的文章的sql语句
function d4p_get_query_results() {
global $wpdb;

return $data;
}

删除缓存方法
delete_transient('my_transient_key');

latest 10 posts sql

global $wpdb;
$transient_name = 'lc-latest-10-posts';
$post_ids = get_transient( $transient_name );
if ( $post_ids == FALSE ){
$sql = "SELECT post.ID
FROM $wpdb->posts post
WHERE
post.post_type = 'post'
AND post.post_status = 'publish'
ORDER BY post.post_date
DESC
LIMIT 0,10";
$results = $wpdb->get_col( $sql );
if( $results ){
foreach ( $results as $result ){
$post_ids[] = $result;
}
set_transient( $transient_name, $post_ids, 60 * 60 * 6 );
}
}