I’m in the middle of doing some fairly complex queries involving metadata from a custom post type. Unfortunately if any posts are deleted the metadata stays put which complicates matters as I am counting it. I was wondering how best to go about deleting the orphan metadata in the event that the post is deleted. … Read more
I want to exclude Subscribers from a user list. My code is: $users = $wpdb->get_results( “SELECT display_name FROM $wpdb->users ORDER BY display_name ASC” ); How can I change that so subscribers are excluded from the list? I also looked at the get_users function in codex but it did not have an exclude by role parameter. … Read more
I want to export my members table to csv format on my default download location. So I used a shortcode in functions.php and called it on a page. I am getting an already sent header warning and csv file is not exported but data is printed on the screen with header already sent error warning. … Read more
I’m trying to convert this to using a $wpdb class. It will return all the enums possible and i have to use this $wpdb due to mysql_query giving me weird error (no database selected) Code is following function getEnumValues($table, $field) { $enum_array = array(); $query = ‘SHOW COLUMNS FROM `’ . $table . ‘` LIKE … Read more
I have two fields. The first is for plain text (but with special characters) and the second for html content (wp_editor is used). Both are later needed for phpmailer. <textarea style=”width:100%;height:200px;” name=”doi-altbody”><?php echo $epn_doi_altbody; ?></textarea> wp_editor( $epn_doi_body, ‘doi-body’, array( ‘editor_height’ => ‘300px’ ) ); 1) How do i correctly secure them after submitting the form … Read more
How can I loop through my WordPress query, and check each posts if one meta_value of meta_key user_ip_reservering match the $ipadres Code $args = array( ‘post_type’ => ‘reserveringen’, ); $reservation_query = new WP_Query( $args ); if ( $reservation_query->have_posts() ) : ?> <ul> <!– the loop –> <?php while ( $reservation_query->have_posts() ) : $reservation_query->the_post(); ?> <li><?php … Read more
I am currently working on this plugin, which is similar to Query Monitor in which i Have displayed all the Details present in the $wpdb object. Now i need to find which plugin is Triggering the Query. Code is Here :- global $wpdb; $data = $wpdb->queries; $query_time = 0; $total_time = round(timer_stop(false, 22 ),4); if … Read more
When I post a post to my site though webapi,there already had a same post_title in my post list, So I just want to update my post_content or replace all data to the old post but not let wp create a new post which post_name became post_name-1. I got this code with wpdb, but it’s … Read more
I have this code: $query = “SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id INNER JOIN $wpdb->term_relationships ON $wpdb->posts.ID = $wpdb->term_relationships.object_id WHERE ((post_type=”projects”) OR (post_type=”post_cost_codes”));”; $results = $wpdb->query($query); // Takes 1.5 seconds I also tried this: $query = “SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id INNER JOIN $wpdb->term_relationships … Read more
Trying to create a table in the wpdb when activating the plugin I am working on and getting the error “The plugin generated 2694 characters of unexpected output…” I’ve been over the code and done heaps of googling to try and figure out what I’ve done wrong with no success. Can someone take a look … Read more
