Display most recent options and post meta using wp cli

<?php
/**
* Plugin Name: EA Recent DB
* Description: Displays most recent options and post meta using wp cli
* Version: 1.0.0
* Author: Bill Erickson & Jared Atchison
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU General Public License version 2, as published by the
* Free Software Foundation. You may NOT assume that you can use any other
* version of the GPL.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE.
*
* @package EARecentDB
* @since 1.0.0
* @copyright Copyright (c) 2014, Bill Erickson & Jared Atchison
* @license GPL-2.0+
*/
if ( ! ( defined('WP_CLI') && WP_CLI ) )
return;
class EA_Recent_DB extends WP_CLI_Command {
/**
* Displays most recent entries in wp_options table
*
* ## OPTIONS
*
* [--count=<count>]
* : How many to show
*
* ## EXAMPLES
*
* wp recent-db option --count=5
*
* @synopsis [--count=<count>]
*/
function option( $args, $assoc_args ) {
$count = isset( $assoc_args['count'] ) && !empty( $assoc_args['count'] ) ? (int) $assoc_args['count'] : 1;
// Get options
global $wpdb;
$results = $wpdb->get_results(
$wpdb->prepare( "SELECT * FROM $wpdb->options ORDER BY option_id DESC LIMIT 0, %d", (int) $count ),
OBJECT
);
if( $results ) {
$output = '';
foreach( $results as $result )
$output .= '
Option ID: ' . $result->option_id . '
Option Name: ' . $result->option_name . '
Option Value: ' . $result->option_value . '
';
} else {
$output = 'No results found';
}
// Print Results
WP_CLI::success( $output );
}
/**
* Displays most recent entries in wp_postmeta table
*
* ## OPTIONS
*
* [--count=<count>]
* : How many to show
*
* [--post_id=<post_id>]
* : Limit to meta associated with this post
*
* ## EXAMPLES
*
* wp recent-db postmeta --count=5 --post_id=2
*
* @synopsis [--count=<count>] [--post_id=<post_id>]
*/
function postmeta( $args, $assoc_args ) {
$count = isset( $assoc_args['count'] ) && !empty( $assoc_args['count'] ) ? (int) $assoc_args['count'] : 1;
$post_id = isset( $assoc_args['post_id'] ) && !empty( $assoc_args['post_id'] ) ? (int) $assoc_args['post_id'] : false;
// Get post meta
global $wpdb;
if( $post_id ) {
$results = $wpdb->get_results(
$wpdb->prepare( "SELECT * FROM $wpdb->postmeta WHERE post_id = %d ORDER BY meta_id DESC LIMIT 0, %d", $post_id, $count ),
OBJECT
);
} else {
$results = $wpdb->get_results(
$wpdb->prepare( "SELECT * FROM $wpdb->postmeta ORDER BY meta_id DESC LIMIT 0, %d", $count ),
OBJECT
);
}
if( $results ) {
$output = '';
foreach( $results as $result )
$output .= '
Meta ID: ' . $result->meta_id . '
Post ID: ' . $result->post_id . '
Meta Key: ' . $result->meta_key . '
Meta Value: ' . $result->meta_value . '
';
} else {
$output = 'No results found';
}
// Print Results
WP_CLI::success( $output );
}
}
WP_CLI::add_command( 'recent-db', 'EA_Recent_DB' );
view raw ea-recent-db.php hosted with ❤ by GitHub

Bill Erickson

Bill Erickson is a freelance WordPress developer and a contributing developer to the Genesis framework. For the past 14 years he has worked with attorneys, publishers, corporations, and non-profits, building custom websites tailored to their needs and goals.

Ready to upgrade your website?

I build custom WordPress websites that look great and are easy to manage.

Let's Talk