Michael Beckwith on "CMB2 Taxonomy Select not saving in database"

Hello Micheal,

Since my earlier reply I have had a further look into this issue.

When sanitize is added it adds the entry to the postmeta table. I have also managed to get the category of downloads to display on the page using:

$download_category = get_post_meta(get_the_ID(), '_ct_contact_download_cat', true);

//echo $download_category;
global $wpdb;
                    $sql='select term_id from wp_qzsny57q7q_terms where slug = "'.$download_category.'"';
                    $posts = $wpdb->get_results($sql);
                    //print_r($posts);

                    foreach ($posts as $post)
                    {
                        //$post->FIELD1                         

                        $category_id = $post->term_id;
                    }

?>

However, the drop down meta box (taxonomy select) in the page editor does not pull the correct category id from the postmeta table.

So for instance, you can select a different category from the drop down and save it to the database but this does not update in the metabox on the edit page.

I have stripped back the full websites code until I resolve this issue, please see the metabox.php code below:

<?php
/**
 * Include and setup custom metaboxes and fields. (make sure you copy this file to outside the CMB2 directory)
 *
 * Be sure to replace all instances of 'yourprefix_' with your project's prefix.
 * http://nacin.com/2010/05/11/in-wordpress-prefix-everything/
 *
 * @category YourThemeOrPlugin
 * @package  Demo_CMB2
 * @license  http://www.opensource.org/licenses/gpl-license.php GPL v2.0 (or later)
 * @link     https://github.com/WebDevStudios/CMB2
 */

/**
 * Get the bootstrap! If using the plugin from wordpress.org, REMOVE THIS!
 */

if ( file_exists( diame( __FILE__ ) . '/cmb2/init.php' ) ) {
    require_once diame( __FILE__ ) . '/cmb2/init.php';
} elseif ( file_exists( diame( __FILE__ ) . '/CMB2/init.php' ) ) {
    require_once diame( __FILE__ ) . '/CMB2/init.php';
}

/**
 * Conditionally displays a metabox when used as a callback in the 'show_on_cb' cmb2_box parameter
 *
 * @param  CMB2 object $cmb CMB2 object
 *
 * @retu bool             True if metabox should show
 */
function ct_show_if_front_page( $cmb ) {
    // Don't show this metabox if it's not the front page template
    if ( $cmb->object_id !== get_option( 'page_on_front' ) ) {
        retu false;
    }
    retu true;
}

/**
 * Conditionally displays a field when used as a callback in the 'show_on_cb' field parameter
 *
 * @param  CMB2_Field object $field Field object
 *
 * @retu bool                     True if metabox should show
 */
function ct_hide_if_no_cats( $field ) {
    // Don't show this field if not in the cats category
    if ( ! has_tag( 'cats', $field->object_id ) ) {
        retu false;
    }
    retu true;
}

/**
 * Manually render a field.
 *
 * @param  array      $field_args Array of field arguments.
 * @param  CMB2_Field $field      The field object
 */
function ct_render_row_cb( $field_args, $field ) {
    $classes     = $field->row_classes();
    $id          = $field->args( 'id' );
    $label       = $field->args( 'name' );
    $name        = $field->args( '_name' );
    $value       = $field->escaped_value();
    $description = $field->args( 'description' );
    ?>
    <div class="custom-field-row <?php echo $classes; ?>">
        <p><label for="<?php echo $id; ?>"><?php echo $label; ?></label></p>
        <p><input id="<?php echo $id; ?>" type="text" name="<?php echo $name; ?>" value="<?php echo $value; ?>"/></p>
        <p class="description"><?php echo $description; ?></p>
    </div>
    <?php
}

/**
 * Manually render a field column display.
 *
 * @param  array      $field_args Array of field arguments.
 * @param  CMB2_Field $field      The field object
 */
function ct_display_text_small_column( $field_args, $field ) {
    ?>
    <div class="custom-column-display <?php echo $field->row_classes(); ?>">
        <p><?php echo $field->escaped_value(); ?></p>
        <p class="description"><?php echo $field->args( 'description' ); ?></p>
    </div>
    <?php
}

/**
 * Conditionally displays a message if the $post_id is 2
 *
 * @param  array             $field_args Array of field parameters
 * @param  CMB2_Field object $field      Field object
 */
function ct_before_row_if_2( $field_args, $field ) {
    if ( 2 == $field->object_id ) {
        echo '<p>Testing <b>"before_row"</b> parameter (on $post_id 2)</p>';
    } else {
        echo '<p>Testing <b>"before_row"</b> parameter (<b>NOT</b> on $post_id 2)</p>';
    }
}

add_action( 'cmb2_admin_init', 'yourprefix_register_demo_metabox' );
/**
 * Hook in and add a demo metabox. Can only happen on the 'cmb2_admin_init' or 'cmb2_init' hook.
 */
/***** HOME PAGE START *****/
add_action( 'cmb2_init', 'ct_register_contact_page_metabox' );
/**
 * Hook in and add a metabox that only appears on the 'home' page
 */
function ct_register_contact_page_metabox() {

    // Start with an underscore to hide fields from custom fields list
    $prefix = '_ct_contact_';

    /**
     * Metabox to be displayed on a single page ID
     */
    $cmb_contact_page = new_cmb2_box( array(
        'id'           => $prefix . 'metabox',
        'title'        => __( 'home Page Metabox', 'cmb2' ),
        'object_types' => array( 'page', ), // Post type
        'context'      => 'normal',
        'priority'     => 'high',
        'show_names'   => true, // Show field names on the left
        'show_on'      => array( 'key' => 'page-template', 'value' => 'template-service-default.php' ),
    ) );

    $cmb_contact_page->add_field( array(
        'name'     => __( 'Downloads Categorys', 'cmb2' ),
        'desc'     => __( 'Select the downloads category.', 'cmb2' ),
        'id'       => $prefix . 'download_cat',
        'type'     => 'taxonomy_select',
        'taxonomy' => 'form_category',
        'sanitization_cb' => 'sanitize_text_field',
    ) );

Here is the nessesary code from the php template:

<?php 

/*
Template Name: Single Service Template Default
*/

$download_category = get_post_meta(get_the_ID(), '_ct_contact_download_cat', true);

//echo $download_category;
global $wpdb;
                    $sql='select term_id from wp_qzsny57q7q_terms where slug = "'.$download_category.'"';
                    $posts = $wpdb->get_results($sql);
                    //print_r($posts);

                    foreach ($posts as $post)
                    {
                        //$post->FIELD1                         

                        $category_id = $post->term_id;
                    }

?>

<ul>
        <?php
        // the query
        $args = array(
                'post_type' => 'forms_pt',
                'orderby'=>'title',
                'order'=>'ASC',
                'posts_per_page' => 7,
                'tax_query' => array(
                array(
                        'taxonomy' => 'form_category',
                        'field'    => 'id',
                        'terms'    => $category_id,
                        ),
                ),
        );

        $the_query = new WP_Query( $args ); ?>

                <?php if ( $the_query->have_posts() ) : ?>

                <!-- pagination here -->

                <!-- the loop -->
                <?php while ( $the_query->have_posts() ) : $the_query->the_post();

        ?>

        <li><a href="<?= $file; ?>"><?php the_title(); ?></a></li> 

        <?php endwhile; ?>
        <!-- end of the loop -->

        <!-- pagination here -->

        <?php wp_reset_postdata(); ?>

        <?php else : ?>
                <p><?php _e( 'Sorry, no posts matched your criteria.' ); ?></p>
        <?php endif; ?>

        <li><a href="/downloads/">View All Forms</a></li>
</ul>

Again, many thanks for all of your help and support so far, I feel that we are 90% of the way there now!

WordPress ...