Populate select list with meta values from all posts of a Custom Post Type

Here is the solution I came up with, that works properly. <form method=”get” action=”” onchange=”submit();”> <div class=”input-group”> <?php global $wpdb; $meta_key = ‘item_oem’; $data = $wpdb->get_results($wpdb->prepare( “SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = %s”, $meta_key) , ARRAY_N ); ?> <select class=”custom-select” id=”oems” aria-label=”oems” name=”item_oem” > <option selected>Search By OEM</option> <?php foreach( $data as $value … Read more

WordPress sorting posts by date and title using a dropdown

Here I put orderby attributes as option values – date and title. <form method=”GET”> <select name=”orderby” id=”orderby”> <option value=”date”>Newest to Oldest</option> <option value=”title”>Alphabetical</option> <button type=”submit”>Apply</button> <form> On the same page you can recieve select value and set as orderby attribute $wpb_all_query = new WP_Query(array( ‘post_type’=>’post’, ‘posts_per_page’=>-1, ‘order’=>’ASC’, ‘orderby’=> esc_attr($_GET[‘orderby’]) ); Use your loop to show … Read more