I have used this code here:

https://codex.buddypress.org/developer/loops-reference/the-members-loop/

and I want to filter users by certain criteria. The example for the bp-custom page is:

function my_custom_ids( $field_name, $field_value = '' ) {

  if ( empty( $field_name ) )
    return '';

  global $wpdb;

  $field_id = xprofile_get_field_id_from_name( $field_name ); 

  if ( !empty( $field_id ) ) 
    $query = "SELECT user_id FROM " . $wpdb->prefix . "bp_xprofile_data WHERE field_id = " . $field_id;
  else
   return '';

  if ( $field_value != '' ) 
    $query .= " AND value LIKE '%" . $field_value . "%'";
      /* 
      LIKE is slow. If you're sure the value has not been serialized, you can do this:
      $query .= " AND value = '" . $field_value . "'";
      */

  $custom_ids = $wpdb->get_col( $query );

  if ( !empty( $custom_ids ) ) {
    // convert the array to a csv string
    $custom_ids_str = 'include=' . implode(",", $custom_ids);
    return $custom_ids_str;
  }
  else
   return '';

}

Select all Open in new window

Example Usage: Get all members who have filled out the xprofile field ‘dogs’ and selected the value ‘poodles’.

<?php if ( bp_has_members( my_custom_ids( 'dogs', 'poodles' ) ) ) : ?>

Select all Open in new window

How do I add more conditions to the dogs/poodles. What If I also want 'birds', 'parrot' as well as 'dogs', 'poodles' ?

All of the sudden my posts do not show up properly and my navigation drops and you cant see it. I am a novice at WordPress, can someone please assist? The posts are all on the default template set up, which is what I have always used. The facts its affecting every page (other than the home page) makes me feel a setting is off.  Can someone please check out the site and advise?  Thank you!!

**UPDATE I figured out the posts but my navigation isnt showing in the proper spot on all pages except the home page like it use to. Is it maybe too many words?
wise-eats.com

I need a shortcode for WooCommerce 3.6.2 that will show the image, price and add to cart button.  I found this shortcode [add_to_cart id="1984"] but it only shows the following:

https://gyazo.com/c1efad0e35b85a05227db4941ff6cd62

I saw this

https://stackoverflow.com/questions/19930779/woocommerce-custom-shortcodes

Select all Open in new window

discussing how to do a custom shortcode via php.  I know some php but I am not that clear how to create what I am needing.

Thanks,

Hello and thanks in advance for any insight the community can provide. I'm working on a WordPress site hosted on GoDaddy's Business Launch Hosting Plan, so it's a Linux  environment.  The challenge I have is with trying to use a SQL query to display data from an external MS SQL server to the WordPress site.
 
When I started looking into this, I wanted to use a plugin (WPDataTable) to do this. I cleared one error when trying to connect to the server by enabling pdo_sqlsvr. Then I received the following error:

wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE[IMSSP]: This extension requires the Microsoft ODBC Driver 13 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 13 for SQL Server for x64: http://go.microsoft.com/fwlink/?LinkId=163712

I called GoDaddy to see how to resolve the error. They said our website would need to be hosted in their Windows environment (Plesk) in order to communicate with a MS SQL server, otherwise, I'd have to export data from MS SQL to i.e., CSV to then import to MySQL.

- Someone today (not godaddy) said there's potentially an option if I had root access to set up Microsoft’s freetds configuration, which I'm pretty sure I don't have through Godaddy (we're not on the VPS hosting plan) and this goes beyond my level of expertise.
- I'm assuming that whether attempting to do this with a plugin, or writing code, MS SQL server…

Hello, As the title states, I am tying to list the taxonomy categories for a specific custom post type created by this plugin, here is my code so far, no luck.

    <select name="event-dropdown" onchange='document.location.href=this.options[this.selectedIndex].value;'> 
    <option value=""><?php echo esc_attr(__('Select Category')); ?></option> 

    <?php 
        $option = '<option value="' . get_option('home') . '/category/">All Categories</option>'; // change category to your custom page slug
        $categories = get_categories( array(
			'orderby' => 'name',
			'order'   => 'ASC',
			'taxonomy' => 'firm_type'
		) );
		
        foreach ($categories as $category) {
            $option .= '<option value="'.get_option('home').'/category/'.$category->slug.'">';
            $option .= $category->cat_name;
            $option .= ' ('.$category->category_count.')';
            $option .= '</option>';
        }
        echo $option;
    ?>
</select>

Select all Open in new window

Hi there - I have an urgent issue which could lose me a customer if I don't get it resolved this evening. Hope someone is able to help with this.

I had a new CentOS 7 server built for a customer and have moved all their websites to it. They are all Wordpress sites and all (on the old server) used to use MySQL databases. It was a CentOS 6 server. The new server uses MariaDB which I believe works the same as MySQL.

One of the files on the site has this PHP code in it:

<?php
//      CONNECTION DETAILS
        $dataHost_EMO = 'localhost:3306';
        $dataUser_EMO = 'overall_emo_adm';
        $dataPass_EMO = '@1}Zq!!?6]M?_EMO';
        $database_EMO = "overall_emo";

//      Connect to MEMBERS DATABASE
        $connect_EMO = mysqli_connect( $dataHost_EMO, $dataUser_EMO, $dataPass_EMO, $database_EMO );
        if (!$connect_EMO) { die('Connection to db failed because... '.mysqli_error( $connect_EMO ) ); }
//      else { echo "Connected to MEMBERS DATABASE"; }

        // echo "project_emo/connection_for_emo.php HAS BEEN INCLUDED"; 
        // die("TESTING Connection");

?>

Select all Open in new window

The error message "Connection to db failed because..." comes up. Head scratching moment.

I have made sure that the password matches the username in the config.php file and anywhere else I can find it, including in the above PHP code.

If anyone has a suggestion I would be so grateful!

Many thanks
Chris

WooCommerce / WordPress over ride a Plugin function.  I always seem to run into trouble when I try to over ride a plugin function. I have a plugin that makes a Woo Product category password protected.  It is an open source plugin from GIT.  I want to customize the password form.  The form is in a function inside the functions.php file of the plugin.
The Plugin Method

<?php
function wcl_get_the_password_form($category_id = false)
{
//  DO STUFF
}

Select all Open in new window

My Method inside of my child theme functions.php:

<?php
add_action('wcl_get_the_password_form','mogo_password_form');

function mogo_password_form($category_id = false)
{
//  DO STUFF
}

Select all Open in new window

This is the Plugin link: https://wordpress.org/plugins/wc-category-locker/

Hello,  I'm having a litle trouble with the CSS on our location map.  I'm using the WP Google Maps Pro, and had an update. Now if you click on any of the locations, the popup is all squashed together.  

How can i target just the popups, so they are formatted nicely?

Here is the website

I have created a custom widget with fields from advanced custom fields. I just wanted to check that the code is okay or if it could be improved upon (I am sure it can be). I placed this in my functions.php file but don't think it belongs there either. Where would be a better place to put it?

class ACF_Custom_Widget extends WP_Widget {

    /**
    * Register widget with WordPress.
    */
    function __construct() {
        parent::__construct(
            'fair_deal_widget', // Base ID
            __('Fair Deal Widget', 'text_domain'), // Name
            array( 'description' => __( 'A fair deal widget', 'text_domain' ), 'classname' => 'fair-deal-widget' ) // Args
        );
    }

    /**
    * Front-end display of widget.
    *
    * @see WP_Widget::widget()
    *
    * @param array $args     Widget arguments.
    * @param array $instance Saved values from database.
    */
    public function widget( $args, $instance ) {
      // outputs the content of the widget
      if ( ! isset( $args['widget_id'] ) ) {
        $args['widget_id'] = $this->id;
      }
        
        $widget_id = 'widget_' . $args['widget_id'];

        $bgImage = get_field('background_image', $widget_id);
        $profilePic = get_field('profile_pic', $widget_id);
        $name = get_field('name', $widget_id);
        $description = get_field('description', $widget_id);
        $cta = get_field('call_to_action', $widget_id);
        $contactNum = get_field('contact_number', $widget_id);


   

Select all Open in new window

…

I am unable to use the featured image. My site is running WordPress 5.1.1. I have tried to use the “image” as shown in the attached screenshot, but I cannot find a featured image control. Please help.

I thought this would be super easy to do but I can't seem to find an easy way.

When I go to my blog page I want to list all the categories available in a custom layout, so I don't want to use a widget.

I did this:

    <?php wp_list_categories( array(
        'orderby' => 'name'
    ) ); ?> 

Select all Open in new window

But the formatting is awful.

Then I tried this:

    <?php $cats = get_categories(); ?>
    <div class="blog">
        <a href="#" class="button blog-category">show all</a>
        <?php foreach($cats as $cat): ?>
        <a href="<?php echo site_url() . '/category/' . $cat->slug; ?>" class="button blog-category"><?php echo $cat->name; ?></a>
        <?php endforeach; ?>
    </div>

Select all Open in new window

But not sure that href is ideal. And the other problem is that I want the category I am on to add an active class to the nav item.

I need a sort that uses the parent id which is called jk_sku.  I am on 5.1.1 WordPress and 3.5.7 for WooCommerce.  I only need this as an option for sort.  So following two articles on the net.  I put together this code

function jk_add_custom_sku() {
$args = array(
'label' => __( 'Parent ID', 'woocommerce' ),
'placeholder' => __( 'Enter custom SKU here', 'woocommerce' ),
'id' => 'jk_sku',
'desc_tip' => true,
'description' => __( 'This SKU is for internal use only.', 'woocommerce' ),
);
woocommerce_wp_text_input( $args );
}
add_action( "woocommerce_product_options_sku", "jk_add_custom_sku" );

function jk_save_custom_sku( $post_id ) {
// grab the custom SKU from $_POST
$custom_sku = isset( $_POST[ 'jk_sku' ] ) ? sanitize_text_field( $_POST[ 'jk_sku' ] ) : '';

// grab the product
$product = wc_get_product( $post_id );

// save the custom SKU using WooCommerce built-in functions
$product->update_meta_data( 'jk_sku', $custom_sku );
$product->save();
}

add_action( "woocommerce_process_product_meta", "jk_save_custom_sku" );
//add_action( "save_post_product", "jk_save_custom_sku" );

####### Custom Sort Option ######################

// 1. Create new product filter
 
add_filter( 'woocommerce_get_catalog_ordering_args', 'bbloomer_sort_by_name_woocommerce_shop' );
 
function bbloomer_sort_by_name_woocommerce_shop( $args ) {
     
    $orderby_value = isset( $_GET['orderby'] ) ? wc_clean( (string) wp_unslash( $_GET['orderby'] ) ) : wc_clean( get_query_var( 'orderby' ) );
   

Select all Open in new window

…

Hello,

I am trying to build a custom Wordpress use search, it is displaying  every user and ignoring my search criteria

Search form  ( LINK: http://oalaca.nextmp.net/member-search/ )

<form role="search" method="get" class="search-form" action="http://oalaca.nextmp.net/member-search-results/">
	<label>
		<input type="search" class="search-field" placeholder="" value="" name="main_fields" title="">
	</label>
	<input type="submit" class="search-submit" value="Search Users">
</form>

Select all Open in new window

Search results

        <?php 
	
	function myplugin_register_query_vars( $vars ) {
    $vars[] = 'main_fields';
    $vars[] = 'default_fields';
    return $vars;
}
add_filter( 'query_vars', 'myplugin_register_query_vars' );
	
	
	$default_fields = $_POST['main_fields'];
		
		
		// WP_User_Query arguments
$args = array (
 
    'order'      => 'ASC',
    'orderby'    => 'display_name',
    'search'     => '*' . esc_attr( $default_fields ) . '*',
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key'     => 'first_name',
            'value'   => $default_fields,
            'compare' => 'LIKE'
        ),
        array(
            'key'     => 'last_name',
            'value'   => $default_fields,
            'compare' => 'LIKE'
        ),
        array(
            'key'     => 'description',
            'value'   => $default_fields ,
            'compare' => 'LIKE'
        )
    )
);

// Create the WP_User_Query object
$wp_user_query = new

Select all Open in new window

…