Need help with CPT/Taxonomy set up WordPress

phppoet answers:

Only way to do this is by setting up a category hierarchy or tag hierarchy if you want to this with custom post type . You can add category support to your custom post type in this way .









class my_events_type {

public function __construct()

{

$this->register_post_type();



}

public function register_post_type() {













register_taxonomy

(

'events-tag',

array('events'),

array

(

'hierarchical' => false,

'labels' => array

(

'name' => _x( 'events Tags', 'taxonomy general name' ),

'singular_name' => _x( 'events Tag', 'taxonomy singular name' ),

'search_items' => __( 'Search events Tags' ),

'all_items' => __( 'All events Tags' ),

'edit_item' => __( 'Edit events Tag' ),

'update_item' => __( 'Update events Tag' ),

'add_new_item' => __( 'Add New events Tag' ),

'new_item_name' => __( 'New events Tag Name' ),

'menu_name' => __( 'events Tags' ),

),

'show_ui' => true,

'query_var' => true,

'rewrite' => array('slug' => 'events-tag', 'with_front' => true),

)

);







register_taxonomy('events_cat','events', array(

'hierarchical' => true,

'show_ui' => true,

'query_var' => true,



)); // add unique categories to portfolio section





$args = array (



'labels'=> array (

'name' => 'eventss',

'singular_name' => 'events',

'add_new' => 'Add New events',

'add_new_item' => 'Add New events',

'edit_item' => 'Edit events',

'new_item' => 'Add new events ',

'view_item' => 'View events',

'search_items' => 'Search events',

'not_found' => 'no events found ',

'not_found_in_trash' => 'no events found in trash'



),

'query_var' => 'eventss',









'public' => true,



'supports'=> array( 'title', 'editor', 'thumbnail','excerpt'),

'taxonomies' => array('events'),









);

register_post_type('events',$args);



}



}



add_action('init', function() {

new my_events_type();





} );



then you need to css/restructure your themes category.php and tag.php files .

---

---

---

---

---

Dbranes answers:

Hi, you can also use fx:


$sql = "SELECT DATE_FORMAT(post_date, '%Y') as post_year
FROM {$wpdb->posts}
WHERE post_type = 'events' AND post_status = 'publish' AND post_date >= CURRENT_DATE
GROUP BY post_year
ORDER BY post_year ASC";

$years = $wpdb->get_results($sql,ARRAY_A);

print_r($years);


to get the array of all the years that are greater or equal to current date.

Similar:


$sql = "SELECT DATE_FORMAT(post_date, '%m') as post_month, DATE_FORMAT(post_date, '%Y') as post_year, ID as post_id
FROM $wpdb->posts
WHERE post_type = 'events' AND post_status = 'publish' post_date >= CURRENT_DATE
GROUP BY post_year, post_month
ORDER BY post_year ASC, post_month ASC";

$data = $wpdb->get_results($sql,ARRAY_A);

print_r($data);


to get the archive array with year/month/post_id.

Then you can loop this arrays to fetch the corresponding post data from the post_id.

---

---

---