Please try with below code : $pro_args = []; $pro_args[‘post_type’] = ‘post’; //Replace your post type $pro_args[‘post_status’] = ‘publish’; $pro_args[‘posts_per_page’] = -1; $pro_args[‘tax_query’] = array( array( ‘taxonomy’ => ‘category’, //Replace your taxonomy name ‘field’ => ‘id’, ‘terms’ => array( 66 ), ) ); // Optional $pro_args[‘meta_query’] = array( ‘relation’ => ‘AND’, array( ‘key’ => ‘key1’, … Read more
Why is this function so slow?
MySQL Actibity without any active visitors via Google Analytics
I have encountered the same issue but with product attributes, since I had more than 20000 products and much more product attributes, the queries were very slow. What I did was, in order to make it faster, wrote an small plugin converting tags to custom fields and then displayed those on the page, but in … Read more
After a bit of research, this can be achieved by using the function https://developer.wordpress.org/reference/functions/get_user_meta/
After i posted the question, i was told the staging site which i was working on, and the production site’s code was out of sync. The answer ended up being simple: ‘posts_per_page’ => 8, (which was actually working but was out of sync with repos / server) was actually set to ‘posts_per_page’ => -1, which … Read more
What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
WordPress mysql deos not work with php7
if you want to check username and password fields, try below code if (isset($_POST[‘submit-btn’])) { $username = filter_var($_POST[‘username’], FILTER_SANITIZE_STRING); $password = filter_var($_POST[‘password’], FILTER_SANITIZE_STRING); if(empty($username)) { echo “Username empty”; return false; } if(empty($password)) { echo “Password empty”; return false; } if($username && $password) { $login_array = array(); $login_array[‘user_login’] = $username; $login_array[‘user_password’] = $password; $verify_user = wp_signon($login_array, … Read more
It is likely there are very few rows WHERE AND ( wp_posts.post_date >= ‘2019-09-04 21:45:00’ ) there are likely many thousands of rows WHERE AND ( wp_posts.post_date < ‘2019-09-04 21:45:00’ ) and a table scan is required. EXPLAIN SELECT SQL_NO_CACHE remainder of query for each and examine results carefully. Post the TEXT RESULTS of EACH … Read more