Two ways: 1. use the federated engine to enable one Mysql server to talk to the other; 2. have WordPress talk to both. Create a second wpdb object that talks to the non-WordPress database. This is quite possible, and you can give it non-WordPress-related queries. See Using wpdb to connect to a separate database for … Read more
You need to JOIN the term tables with the posts table, something like this: SELECT p.post_name, p.post_content, t.name FROM wp_posts p JOIN wp_term_relationships tr ON ( tr.object_id = p.ID ) JOIN wp_term_taxonomy tt ON ( tt.term_taxonomy_id = tr.term_taxonomy_id ) JOIN wp_terms t ON ( t.term_id = tt.term_id ) WHERE p.post_type=”post” AND p.post_status=”publish” AND tt.taxonomy = … Read more
Can someoene please help with customization of a post?
I’ll post only the FUNCTIONS.PHP code: // Relevanssi does not show ACF fields by default – this is a work-around for specific fields in the DB function excerpt_function($content, $post, $query) { global $wpdb; // Grab everything in the ACF content fields from the DB and spit it out in the search result excerpt. If new … Read more
There is more to do to clean up a site than export/import posts data. The malware can be anywhere. And it could have gotten into your site via many paths. Before you export/import posts, you need to ensure that the current posts are not the source of malware. I’d do a whole cleaning of the … Read more
Instead of going for a complex nested array, I decided that it might be best to keep it to simple two level set of arrays. $x = array( 101 => [ (int $parent_id), (bool $completed) ], 102 => [ (int $parent_id), (bool $completed) ], 103 => [ (int $parent_id), (bool $completed) ], 104 => [ … Read more
Yes it is possible, one simple way is to delete wp-config.php and add wp-config-sample.php then open the site in the browser, it ask you to install the wordpress. So, install a fresh wordpress. After that open your phpmyadmin, select the database which wordpress created for you, then check all tables of this database then select … Read more
Try using 127.0.0.1:3306 instead of using localhost. :3306 is the default port when using PHP7. That should do it.
Is it safe to add INDEX to a column in WordPress database?
Reset post IDs with all post meta