In order to figure the issue out, I ran unserialize on both data strings and saw that the top example saved as an associative array like: Need help with format of nested array in MySQL => Title 1 [point] => 55.635656,12.506767 and the second array was flat like: [0] => title [1] => Title 0 … Read more
Solved! I follow this tutorial: https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/writing-your-first-block-type/ https://wordpress.org/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/creating-dynamic-blocks/ And complimented with this: https://gist.github.com/mattheu/7cf235b4f932de891bc21cb5f3ff3de6
Featured image from custom to WordPress database
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
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
It seems your wp is not connecting with database. There can be some reasons. 1. username, password and host from database are not correct. 2. Check mysql connection in PHP by some small php script for mysql connection. As you told you have followed #1. Then try to check mysql connection in PHP. There should … Read more
As Birgire mentioned in the comments, you can hook into the gallery output rather than performing a search/replace on the database. From the WordPress Codex: Function Reference/shortcode atts gallery Provides the ability to filter the array returned from shortcode_atts(). You want something like this: add_filter( ‘shortcode_atts_gallery’, ‘gallery_shortcode_exclude_thumbnail’, 10, 3 ); function gallery_shortcode_exclude_thumbnail( $result, $defaults, $atts … Read more
WordPress MySQL Search and replace with wildcard?
Is it possible to replace MySQL with JSON files for WordPress
Display multiple meta_key/meta_values by single SQL query