This code will do the job: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ); $query = new WP_Query( $args ); $posts = array(); $categories = array(); $json = array(); while( $query->have_posts() ) : $query->the_post(); $post_categories = get_the_category(); $post_category = current($post_categories); $categories[] = array( ‘name’ => $post_category->name ); $posts[] = array( … Read more
I guess you want it to know in which article you need to edit and add featured image. You can create some file in the worpdress root folder and just use WP_Query to get all the posts and to check if there is no feature image you can use the has_post_thumbnail(). Change the post_type if … Read more
It’s a serialized string. Here’s a good description of what it is: A PHP array or object or other complex data structure cannot be transported or stored or otherwise used outside of a running PHP script. If you want to persist such a complex data structure beyond a single run of a script, you need … Read more
Use this code instead- class hidemysite_security{ public function __construct() { if (is_admin()) { register_activation_hook(__FILE__, array( $this, ‘activate’)); register_deactivation_hook( __FILE__, array( $this, ‘my_plugin_remove_database’ ) ); } } public function activate() { global $wpdb; $table = $wpdb->prefix . ‘md_things’; $charset = $wpdb->get_charset_collate(); $charset_collate = $wpdb->get_charset_collate(); $sql = “CREATE TABLE $table ( id mediumint(9) NOT NULL AUTO_INCREMENT, time … Read more
WP-CLI has a bunch of helpful commands, including some to perform basic database operations. However, it’s not its job to create new users in MySQL and grant them permissions on a newly created database. So that part of your script can’t really be replaced with WP-CLI. You’re still in luck though. The wp core command … Read more
You could use custom post types and custom taxonomies. Using the custom post types to store data, taxonomies to categorize the data and you can utilize WordPress’ default searching functionality. https://codex.wordpress.org/Post_Types https://codex.wordpress.org/Taxonomies https://codex.wordpress.org/Creating_a_Search_Page
So after some thinking I came up with this: Codex / WordPress Versions has Changelogs, but these seem to mention (recent) database upgrades implicitly, starting at 5.0. (Compare how Matomo explicitly states DB upgrades). Maybe this will be enough for future versions, here’s the thorough, cumbersome way that works for older versions, too: check db_version … Read more
Fuxia was using update_option in her answer and it may work, but I wouldn’t recommend that – it isn’t the polite way of setting a theme. So how I would approach that problem? First of all, you want to perform this action only once and for all sites. So there is no point in using … Read more
There’s nothing wrong with it from WPs point of view. If you want to join posts with your own table and change the way of ordering, then that’s the way to do it. The only thing is a little bit tricky, I guess, is that you use posts_join_paged and not posts_join – it can make … Read more
This is random, but a friend of mine got himself into the same situation a two weeks back and found this plugin to be helpful. https://wordpress.org/plugins/media-sync/ But as Tom mentioned above in his comment, you’ll run into attachment post type issues. Hope this helps you get half way there!!