CODEWITHSUNDEEP
phpwordpresswoocommercecheckoutcity
Rowan Mamdouh
Rowan Mamdouh

Reputation: 61

Get cities as values and names for a custom checkout select field in Woocommerce

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

Upvotes: 1

Views: 1087

Answers (1)

LoicTheAztec
LoicTheAztec

Reputation: 253886

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…

Upvotes: 1

Related Questions