1

In woocommerce checkout I should need to set values of options in select field to be the city name and not a numbers (as shown in the screenshot below).

Here is a sample of my code:

 $option_cities = $wpdb->get_col( "SELECT name FROM $table_name" );
 $fields['billing']['billing_city']['type'] = 'select';
 $fields['billing']['billing_city']['options'] = $option_cities;

This is what I get:

enter image description here

LoicTheAztec
  • 229,944
  • 23
  • 356
  • 399
Rowan Mamdouh
  • 51
  • 1
  • 1
  • 8

1 Answers1

1

Try the following using array_combine() to get the array values copied as keys in a new array:

 $cities = $wpdb->get_col( "SELECT name FROM $table_name" );

 $option_cities  = array_combine( $cities, $cities );

 $fields['billing']['billing_city']['type'] = 'select';
 $fields['billing']['billing_city']['options'] = $city_options;

It should solve your problem…

LoicTheAztec
  • 229,944
  • 23
  • 356
  • 399