sql - Read For Learn

Is it possible to select against a post’s parent’s fields with WP_Query?

You should use posts_join and posts_where filters to modify JOIN and WHERE clauses. add_filter( ‘posts_join’ , ‘se333659_posts_join’, 20, 2 ); add_filter( ‘posts_where’ , ‘se333659_posts_where’, 20, 2 ); function se333659_posts_join( $join, $query ) { global $wpdb; if ( isset($query->query_vars[‘_rev_of_publ’]) && $query->query_vars[‘_rev_of_publ’] == ‘1’ ) { $join .= ” LEFT JOIN {$wpdb->posts} AS rev_p ON ({$wpdb->posts}.post_parent = … Read more

What’s the easiest way to duplicate an entire navigation menu?

UPDATE: The “easiest” way is to use my new plugin: http://wordpress.org/extend/plugins/enhanced-menu-editor/ It’s not approved yet, but once it is I’ll publish the widget. Not only does it allow for copying menus, but you can also synchronize the menu structure you establish in the menu editor to the page heirarchy of the pages themselves. So you … Read more

wpdb->prepare function remove single quote for %s in SQL statment

You cannot suppress the quotes in $wpdb. Run mysqli_real_escape_string() in your script on these variables.

Get the exact SQL query that get_posts() generated

The get_posts() function creates an instance of WP_Query inside the function and simply returns the array of results. This WP_Query instance doesn’t override the global $wp_query and is out of scope by the time you need it. In short, I don’t see a way how you can get the requested SQL via get_posts(). An alternative … Read more

How to get the list of WooCommerce product image of a certain category from database?

The post thumbnail is not stored as a URL. The post thumbnail is stored as the attachment ID in the _thumbnail_id post meta. The actual file is stored as the _wp_attached_file post meta for that attachment post. WordPress does not store the full URL for attachments in the database. It only stores the path to … Read more

Display data from a non wordpress database on a page template

As Ben suggested, you need to pass the connection details when creating the wpdb class: $newdb = new wpdb( ‘user’, ‘password’, ‘database’, ‘hostname’ ); You should also test that the query actually returned something before using the result in a foreach loop: if ($rows) { foreach ($rows as $obj) { … } }

Sharing database for collaborative development

Yes. Use WP_HOME and WP_SITEURL in your wp-config.php, so the URLs in the database won’t mess (a lot) with local site development. define (‘WP_HOME’, ‘http://local/site/url’); define (‘WP_SITEURL’, ‘http://local/site/url’); Also, some other good practices: Put in your .gitignore things like: wp-config.php wp-content/uploads wp-content/cache wp-content … # Everything that is created by users .htaccess Make a copy … Read more

Getting wrong relationship value in $args in wp_Query?

add : $inner_arrays[‘relation’] = ‘OR’; and then query will be like : $args = array( ‘post_type’ => ‘products’, ‘post_status’=> ‘publish’, ‘meta_query’ => $inner_arrays ); this works …. 🙂

Is it possible to wrap Geo Location search around WP_Query?

I would duplicate the coordinates of the posts in a separate table (post_id, lat, lon), with an index on (lat, lon). With all the joins and the casts I doubt the database can use an efficient index with your query. I once wrote an answer to a similar question using this approach.

Export WordPress Posts and Meta Information in CSV format

What is the SQL query you are using? What are more details of the export and end format you need? The obvious things are 1) http://wordpress.org/extend/plugins/navayan-csv-export/ “Navayan CSV Export is a wordpress plugin to export all your table data in CSV (Comma Separate Value) format.” and 2), exporting with phpmyadmin – the database utility – … Read more

+ More