Actually there is no primary category key. Usually, the first category is primary category by default. So technically, the below are the only fields I will need. Post ID | Post Title | Post Content | Post Excerpt | Post categories | Category Term IDs
A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
wpdb->query() is just running the query. It doesn’t do anything special. And strip_invalid_text_from_query() based on the inline documentation is just stripping invalid characters in the query. And, for your information, something like line-breaks doesn’t break the database. The database can accept any string data. You just have to make sure it correctly escaped when the … Read more
I had this issue some days ago with a multisite, loading a live dump to local development. After some debugging I noticed, that the error message wasn’t right. The database was connected, but the path in the database to the sites was wrong. You can check table <your-prefix>_site and <your-prefix>_blogs if columns domain and path … Read more
Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
You can loop through all your posts and use regex to replace that string. The quick and dirty version would be to just put this in a page template, assign it to a page and then visit said page. If you want something a little cleaner then modify this code to work with something like … Read more
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