My issue was resolved, not sure if the connection to the database will work, but the error with wpdb connection was fixed. It was quite easy fix once I found out what the file dependence was. This is what you need to do: In the file you are trying to use wpdb you need to … Read more
That is because you’re trying to define a property that is already defined, query a table with a wrong name, loop through an integer while you can use get_results instead of query method of $wpdb … I edited the code, hope it will help with your post duplication process: defined( ‘WP_USE_THEMES’ ) || define( ‘WP_USE_THEMES’, … Read more
I see no reason to use wpdb for this, unless your table is in the WordPress database. Also your code would be much clearer (and therefore less prone to errors) if you separate the fetching of the result into an array, and the processing of this array for transformation, from the generation of the final … Read more
A little example, based on get_posts and get_post_meta. $locations = get_posts( array(‘post_type’ => ‘locations’, ‘posts_per_page’ => -1, ‘post_status’ => ‘publish’ ); echo ‘<ul>’; foreach ($locations as $location) { $location_city = get_post_meta($location->ID, ‘city’, true); $location_state = get_post_meta($location->ID, ‘state’, true); $location_address = get_post_meta($location->ID, ‘address’, true); echo ‘<li>’ . $location_city; echo ‘<li>’ . $location_state . ‘</li>’; echo ‘<li>’ … Read more
You’ve not joined the wp_terms or $wpdb->terms table where WordPress stores the term names. So here is the updated code- $post_type_query = ” AND post_type=”” . $selected_post_type . “””; $posts_per_month = $wpdb->get_results( “SELECT *, DATE_FORMAT(post_date, ‘%Y-%m’) AS month, COUNT(ID) AS count FROM {$wpdb->posts} AS wposts LEFT JOIN {$wpdb->postmeta} AS wpostmeta ON (wposts.ID = wpostmeta.post_id) LEFT … Read more
Try with this: function get_roles_that_cant($capability) { global $wp_roles; if ( !isset( $wp_roles ) ) $wp_roles = new WP_Roles(); $available_roles_names = $wp_roles->get_names();//we get all roles names $available_roles_capable = array(); foreach ($available_roles_names as $role_key => $role_name) { //we iterate all the names $role_object = get_role( $role_key );//we get the Role Object $array_of_capabilities = $role_object->capabilities;//we get the array … Read more
It’s hard to say why without seeing more of your code. So if you’re interested in knowing why, then I’d encourage you to share more of your code. If you’re only looking for a solution, then something like the following will probably work. (I say probably because I don’t know because I don’t have your … Read more
You’re adding an extra wp_ prefix to your table and your using a timestamp instead of a MYSQL datetime. Below is how WP suggests you use $wpdb->query to delete rows, taken from the codex. EDITED global $wpdb; $wpdb->query( “DELETE FROM ” . $wpdb->prefix . “userinfo WHERE timeall < DATE_SUB(CURDATE(),INTERVAL 30 DAY)” ); $wpdb->prefix adds the … Read more
Rough answer to get you started. Inside the loop, use the row’s record number (a field called ‘IDnumber’, unique, auto) to help name the of a . The hidden <input> should have an id of something like <input hidden name=”idnumber” value=”<?php echo $row[idnumber];?>”> which will cause the vaue of that input field to be the … Read more
To anyone interested this is the query that worked for me: INSERT INTO $wpdb->postmeta (post_id,meta_key,meta_value) SELECT p.ID, ‘score’ AS meta_key, 0 AS meta_value FROM $wpdb->posts AS p WHERE p.post_type=”my_cpt” AND p.ID NOT IN ( SELECT p2.ID FROM $wpdb->posts AS p2 INNER JOIN $wpdb->postmeta AS pm ON pm.post_id = p2.ID WHERE pm.meta_key = ‘score’ ) But … Read more