WordPress数据库语句,查询分类信息名和id
<?php //获取所有站点分类id function Bing_show_category() { //$wpdb数据库实例化的对象 global $wpdb; $request = "SELECT $wpdb->terms.term_id, name FROM $wpdb->terms "; $request .= " LEFT JOIN $wpdb->term_taxonomy ON $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id "; $request .= " WHERE $wpdb->term_taxonomy.taxonomy = 'category' "; $request .= " ORDER BY term_id asc"; $categorys = $wpdb->get_results($request); foreach ($categorys as $category) { //调用菜单 $output = '<span>' . $category->name . "=(<b>" . $category->term_id . '</b>)</span> '; echo $output; } } ?>
执行函数Bing_show_category() 为输出如下格式的分类信息
未分类=(1) 分类一=(7) 未分类二=(10)