I use the following code to extract the attached images from a post with ID: $args = array( ‘post_type’ => ‘attachment’, ‘post_parent’ => $product_id, ‘post_mime_type’ => ‘image’, ‘orderby’ => ‘menu_order’, ‘order’ => ‘ASC’, ‘numberposts’ => -1 ); $attachments = get_posts($args); The problem is that the above code return all the attached files. Is there a … Read more
How do I gee the numbered pagination of custom wpdb result? below code will show one latest post from each authors in the site. I want to show 20 posts per page with a numbered pagination. $postids = $wpdb->get_results( ” SELECT a.ID, a.post_title, a.post_author, a.post_date FROM $wpdb->posts a JOIN ( SELECT max(post_date) post_date, post_author FROM … Read more
I need to get a return from a query that provides me with email, username or nicename as well as post title based on author id. The query is to run once daily via cron and look for posts that have spent a specific live time before they come up for removal (the query is … Read more
I write code to save data in to the database table. I want Replace a row in a table if it exists or insert a new row in a table if the row did not already exist. http://codex.wordpress.org/Class_Reference/wpdb I use $wpdb->replace function and then add $wpdb->insert_id to end of code. For Update all fields , … Read more
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 3 years ago. Improve this question I manually added a table to my wordpress database using sql using CREATE TABLE. I … Read more
I am trying to get some data from WordPress database tables in a plugin. For that, I am using the below code… global $wpdb; $findID = $wpdb->get_var(“SELECT ID FROM wp_posts WHERE post_name=”hello-world””); echo $findID; But it not giving me the post ID in echo? Is there anything wrong…??? 2 Answers 2 Just to clarify the … Read more
Since WP3.5, prepare() accepts placeholders as a security measure, instead of just appending the argument to the query. Therefore, $wpdb->prefix needs to become a second parameter, called by %s: $count = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(id) FROM %s WHERE answer !=’ ‘”, $wpdb->prefix . “faq_questions” ) ); However, doing that returns the table name in quotes: … Read more
I have following piece of code, which inserts usernames and other details of users in the database. After inserting the usernames I want to email them using wp_mail();. I am unable to do so. How can I do this? $member_details->user_login = array_map( ‘sanitize_text_field’, $_POST[‘user_login’] ); $member_details->user_role = array_map( ‘sanitize_text_field’, $_POST[‘user_role’] ); $member_details->status = array_map( ‘sanitize_text_field’, … Read more
I cleaned up an old-site from pasted tags, manually created lists, etc, and I’d like to keep the old posts as “revisions”, so we can easily “compare” with the old posts and retrieve/revert the original content if needed. So I should either injecting the revision rows in the new DB or just naturally create them … Read more
I’m trying to resolve the problem with event displaying. An event has its start and end dates, written in meta. For example, event starts on (dmY) 03.04.2013 and ends up on 08.04.2013. Using WP_query and meta_query I can exclude this event if I am trying to get data by 09.04.2013. At the same time this … Read more
