This is what worked for me: require_once ‘wp-config.php’; global $wpdb; $args = array( ‘post_type’ => ‘product’, ‘posts_per_page’ => -1, ); $Query= new WP_Query($args); You can use similar way to achieve what you want.
It would be safer to use [wp_insert_comment()][1] rather than manually through MySQL. WP often inserts data in multiple tables – using its core functions helps ensure that all of the data gets added in all of the right tables. I’d suggest creating a query to pull all published posts. Then, set up a foreach loop … Read more
The code I am posting is a modified and simplified version of yours. I got my solution using your code. /** * Filter WP_Term_Query meta query * * @param object $query WP_Term_Query * @return object */ function filter_terms_clauses( $pieces, $taxonomies, $args ) { global $pagenow, $wpdb; if(!is_admin()) { return $pieces; } if( is_admin() && $pagenow … Read more
Normalizing data is more efficient, and storing serialized data in a table field that you want to search / work with on DB level isn’t something for Non-Nosql RDBMS like MySQL/MariaDB. Searching those fields is inefficient, you can’t use indexes on it, can’t join on it, and it’s generally painful to develop imho. If you’ve … Read more
I rewrote the function from the link in your question to SQL. Keep in mind that this script will also clear the page-templates assigned to the pages. Make a backup of the wp_postmeta table first. DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts p ON pm.post_id = p.id WHERE (p.post_type IN (‘post’, ‘page’) AND pm.meta_key … Read more
<?php // primarily get $year, $month and $day $args = array( ‘date_query’ => array( ‘year’ => $year, ‘month’ => $month, ‘day’ => $day, ) ); $query = new WP_Query( $args ); if ( $query->have_posts() ) { while ( $query->have_posts() ) { // do whatever here } }
You could try changing the output type of get_results() to ARRAY_A or ARRAY_N and see what kind of array they give you. E.g. $tables = $wpdb->get_results(“show tables like ‘pro_hist%'”, ARRAY_A); var_dump($tables); foreach( $tables as $table ) { var_dump($table); } If $table is an array and it has the name as the first value, then get … Read more
Try this plugin: http://wordpress.org/extend/plugins/search-and-replace/ – It helped me dozens of times. Or try this query: UPDATE tablename SET tablefield = replace(tablefield, “findstring”, “replacestring”); Or try this method, dump the database, open the SQL file, do a find and replace in a text editor then reimport it. Take care to backup your database prior to making … Read more
I think I know what you mean, and if that is the case it’s actually a straightforward operation. Firstly get all the object_ids from the term_relationship table. $results = $wpdb->get_results(“SELECT `object_id` FROM $wpdb->term_relationships WHERE `term_taxonomy_id` = 18”); And then run through each of those values and update_post_meta to 18. foreach ( $results as $result ) … Read more
Prepare your Queries! global $wpdb; $wpdb->get_results( $wpdb->prepare( “SELECT %s blog_id, last_updated FROM %s WHERE public=”1″ AND archived = ‘0’ AND mature=”0” AND spam = ‘0’ AND deleted =’0′ AND UPPER(blog_name) LIKE ‘%s’ %s %s “, ARRAY_A ), $extra, $wpdb->blogs, $wpdb->esc_like( ‘A%’ ), $order, $limit ); Never ever send data without prepare! Also: There’re some functions … Read more