我正在try 为WooCommerce注册表中的每个用户验证Company Name字段的唯一值,但我遇到了麻烦:
// That's what I got, but it doesn't work...
add_action( 'woocommerce_created_customer', 'custom_billing_company_validation');
function custom__billing_company_validation( $data, $errors ) {
$billing_company = isset( $data['billing_company'] ) ? sanitize_text_field( $data['billing_company'] ) : '';
if ( ! empty( $billing_company ) ) {
global $wpdb;
$count =$wpdb->get_row("SELECT 1 FROM $wpdb->usermeta WHERE
$wpdb->usermeta.meta_key = 'billing_company' AND $wpdb->usermeta.meta_value = '$billing_company' AND $wpdb->usermeta.user_id != $user->ID");
if ( $count > 0 ) {
$errors->add( 'validation', __('The "Name Company " already exists, please contact us.') );
}
}
}