From the Codex, 2nd parameter for the prepare() method: (int|string|array) The value to substitute into the placeholder. Many values may be passed by simply passing more arguments in a sprintf()-like fashion. Alternatively the second argument can be an array containing the values as in PHP’s vsprintf() function. Care must be taken not to allow direct … Read more
Mysql’s Month function can help you on this. Assuming that your meta value is in SQL date format. ORDER BY MONTH($wpdb->postmeta.meta_value) ASC
You can’t insert multiple rows via wpdb’s insert, you have to do it with raw SQL: INSERT into $meta_table (post_id, meta_key, meta_value) VALUES (‘val1’, ‘val2’, ‘val3’), (‘otherval1’, ‘otherval2’, ‘otherval3’) However- You should always use the API where a function exists- use add_post_meta so your plugin integrates with the WordPress environment and its behavior can be … Read more
$wpdb is a global variable. You have to take it into your function’s scope first … global $wpdb; $wpdb->insert(); … or access it per $GLOBALS … $GLOBALS[‘wpdb’]->insert(); And I would use always lowercase keys; this is just a useful convention.
The function bbp_forum_id() will directly echo its value, you want to use bbp_get_forum_id() which will return the value for use in the context of an API call.
If you’re not using WP’s built in Ajax handlers, which includes things for you, you will need to include the WP core yourself. Try adding define(‘WP_USE_THEMES’, false); global $wpdb; require(BASE_PATH . ‘wp-load.php’); to the top of your file. I should point out that the path to wp-load.php may not be the same and hard coding … Read more
prepare() takes at least 2 parameters. Most of your calls to prepare() are not needed. For example: $blogids = $wpdb->get_col($wpdb->prepare(“SELECT blog_id FROM $wpdb->blogs”)); In this code, if the call to $wpdb->prepare() were valid, it wouldn’t do anything. The function doesn’t do anything to the first parameter. It manipulates the values in the other parameters passed … Read more
“the errors (…) don’t show a stack trace” – they would if you were using xdebug. It means $wpdb is not loaded yet, not loaded properly, or gone: If you added code that calls it to your wp-config file or something to that order, remove it. If you’ve a db.php file in wp-content, it’s probably … Read more
I’m pretty sure that you ARE incorrect. Let’s taka a closer look at this code you mentioned in your question. In first line it sets $where variable: $where=”WHERE ID IN (” . substr(str_repeat(‘%d,’, count($my_options[‘acf_posts’])), 0, -1) . ‘)’; So what this line really does is: get the number of some options (let’s call it ‘N’) … Read more
Newer New solution: function wpse153622_transition_solution( $new_status, $old_status, $post ) { if ( $new_status != $old_status && ‘publish’ === $new_status && ‘my-solution’ === $post->post_type ) { update_post_meta( $post_id, ‘my_json’, ‘json’ ); } } add_action( ‘transition_post_status’, ‘wpse153622_transition_solution’, 10, 3 ); This should trigger only when 1. the new post status isn’t the same as the old one … Read more