WP options (which is one of the most basic and used storage APIs) can be stored with or without “autoload” setting. Usually this is reasonable, since many options will be checked on each and every page load, so loading them in bulk during core load is much more efficient than individually. Problems usually start when … Read more
I had the same problem. There is no equivalent function. $wpdb->insert_id works only after $wpdb->insert Alternative way If it’s an update, you can either get the id with a query based on the data you have got, or most of the time, you should have already got the id before update it. global $wpdb; $data … Read more
I don’t see anything wrong with the widget class. The problem you have is that you are displaying the widget area, that contains the widgets, twice in your sidebar.php: <aside id=”secondary” class=”widget-area col-sm-12 col-md-12 col-lg-12″ role=”complementary”> <div class=”col-lg-6 col-md-12″> <?php dynamic_sidebar( ‘main-widget’ ); // this will display all the widgets in your main-widget sidebar ?> … Read more
You should be able to get away with just adding AND $wpdb->posts.post_status=”publish” at the end. $prepare_string = ” SELECT DISTINCT ID FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id ) LEFT JOIN $wpdb->postmeta AS mt1 ON ( $wpdb->posts.ID = mt1.post_id ) WHERE ( ( $wpdb->postmeta.meta_key = ‘event_date’ AND $wpdb->postmeta.meta_value >= %d ) OR … Read more
Basically, i use Contact Form 7 and it’s third party extension for storing values in database i.e.: https://wordpress.org/plugins/contact-form-cfdb7/. Or, if you want to create a custom form and store the value in database you can Create a Custom Post Type and use wp_insert_post() function to insert your respective values.
OK, so the problem is pretty clear to explain. These posts are sorted as three different groups: ‘yes’ ” null That’s because empty value (”) is not the same as null (not existing values). One way to solve it will be to use custom posts_orderby filter. You can use case statement: order by case when … Read more
Summary: WordPress does run date_default_timezone_set( ‘UTC’ );. It does have a timezone option modifiable by the admins and retrieved using get_option( ‘timezone_string’ ). However, none of that has any effect on the query run through $wpdb. You should get the same results from $wpdb as if you had run the MySQL query without WordPress. Details … Read more
There’s the WordPress meta API for retrieving meta values from the wp_postmeta table, but the API doesn’t provide a function for retrieving the post ID (post_id value), but you can use custom SQL as in your code. However, $wpdb->get_col() returns an array of values (upon success), so that’s why you get the “Array” when you … Read more
Looking at your query, I see lots of stuff like wp_posts.post_content LIKE ‘%اهمية%’. You should know that column LIKE ‘%matchstring%’ is a notorious MySQL performance-killer. If you can change your operations to use column LIKE ‘matchstring%’ (with no leading %) this will get better. Or, maybe it makes sense for you to adopt a search … Read more
see: How To Modify New Sub Blog Immediately When Super Administrator Creates It? The code I wanted to post I unfortunately could not post beacause “body is limited to 30000 characters; you entered 62367” so … the following filters are handy (from WordPressMU plugin for site admin to set defaults for new blogs, Deanna Schneider) … Read more