Order taxonomy terms by the frequency of use in the last 30 days

First thing’s first — You’ll have to add that table. The way you do that if you were writing this in a plugin is as follows: function customtaxorder_init() { global $wpdb; $init_query = $wpdb->query(“SHOW COLUMNS FROM $wpdb->terms LIKE ‘term_order'”); if ($init_query == 0) { $wpdb->query(“ALTER TABLE $wpdb->terms ADD `term_order` INT( 4 ) NULL DEFAULT ‘0’”); … Read more

Get object terms with no children?

I have written this function some time ago, it may be a bit sloppy but it does it’s job: function get_low_level_term( $taxonomy ) { $term = null; if( is_single() ) { global $post; $terms = get_the_terms( $post->ID, $taxonomy ); if( count( $terms ) == 1 ) { foreach( $terms as $t ) { $term = … Read more

Passing values by form to create a query

It all depends on how you’re trying to do it. When it comes to filtering results, i usually setup the form to use $_GET and filter the results when the page loads again: if (isset($_GET[‘term’])) { $term = $_GET[‘term’]; } else { $term = ‘defaultTerm’; } if (isset($_GET[‘childterm’])) { $childterm = $_GET[‘childterm’]; } else { … Read more

Altering term_id and name via $wpdb class

You can do it easily. Your query should be: $querystr = “SELECT `term_id` AS `id`, `name` AS `value`, `slug`, `term_group` FROM {$wpdb->terms} WHERE lower($wpdb->terms.name) like ‘%$s%'”; See, here i’ve mentioned the name of the fields needed. For any other fields, you need to explicitly mention the field names.

Echo used hierarchical taxonomies parent name

Try this: <?php $term = get_term_by( ‘slug’, get_query_var( ‘term’ ), get_query_var( ‘taxonomy’ ) ); $parent = get_term($term->parent, get_query_var(‘taxonomy’) ); echo $parent->name; ?> You have to get the current term slug and then use get_term by the slug and then echo the name.