Populate a select box with data stored in the database?

You should import the schools as a table in the database, separate from the other WordPress tables.
You can than write a function that selects and returns schools and eventually link it to the field via ajax using something like select2 or jquery autocomplete.

Related Posts:

  1. Separate table or usermeta
  2. update_user_meta(): invisible data storage
  3. So much data in postmeta
  4. Can I count the number of users matching a value in a multiple value key?
  5. Save custom user meta on registration
  6. How to get users by a custom field / by user meta data?
  7. What is the advantage of the wp_options design pattern?
  8. Remove old custom field after import
  9. How do you add a custom option to user data?
  10. Edit Custom Database Tables in WordPress
  11. importing data from non-wordpress mysql db
  12. How to delete custom field “suggestions” from dropdown list
  13. Show User Their Password
  14. How to update serialized data in the user meta data
  15. Register new user and add custom data row value for it
  16. How can I sort get_users() by any value (last_name, user defined fields and more)
  17. After moving my site from a dev subdomain, to root, all my custom meta data is gone
  18. Front-end update_post_meta with ajax
  19. Advice needed for importing custom field data and database structure
  20. Displaying additional User Contact Information
  21. get_user_meta Short Profile Section
  22. Leader board for game on homepage
  23. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  24. Default WordPress taxonomy (Tag) – How to add a custom field to form and save it to the database
  25. meta_query for a string inside a meta field containing a comma-separated list
  26. How to update custom user meta field in wp?
  27. Custom User Profile Fields
  28. Get all posts that do not have a specific custom field without using a subquery
  29. WordPress User Profile Upload – If page is saved file reset
  30. ACF: How to get the full field name (meta_key) by a field key?
  31. How do I create a column in Users list and display user data from custom registration field
  32. Custom fields not getting saved in the databse when added to the add new user profile page
  33. How to save multiple options from a dropdown in user profile
  34. WP_User_Query pulling ACF to loop
  35. Users Select inside custom metabox
  36. query usermeta from custom field
  37. custom avatar removal
  38. Is there any way to get all meta and standard columns for any WordPress object after searching based on meta key and value
  39. How to add upload video option in wordpress for user?
  40. Passing args to WP_User_Query am I using meta correctly?
  41. Is there a better way to list all database terms alphabetically?
  42. Linking Custom Fields to Database Records
  43. How to save the date/time of last update of an extra user profile field?
  44. How to populate custom field dropdown box based on prior selection?
  45. When creating a metabox do you have to create DB fields for the data?
  46. Limit of char count in WP custom fields
  47. Show image if author meta (profile fields) exists outside loop
  48. Adding custom field and querying from post table
  49. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  50. How to add fields in custom registration form, validate it and aave to db? [closed]
  51. check for duplicate user meta data before updating
  52. Custom Field Repeating When Using foreach
  53. How to copy data from a custom field to the post_content?
  54. Increment user meta data by 1 each time a page is visited
  55. Diamond question mark in text after migrating content
  56. Front-End User Profile
  57. Get emails from users by custom field SQL
  58. award points to a user each time they update their cpt post
  59. How to update user profile custom fields
  60. How do I convert all custom_field php timestamps in the database to js timestamps?
  61. Save custom field types with this function…?
  62. Getting and calculating averge value of custom fields of the same tag
  63. Display Additional Info
  64. Populate custom checkout fields with data from previous orders
  65. How To Save Data From Remote APIs To ACF?
  66. Add WordPress user custom meta to chartjs vertically stacked chart in Divi theme
  67. User query – getting values for custom meta keys/fields
  68. Delete user meta but only if found in array
  69. How to get data from user meta custom fields created with acf-pro plugin?
  70. How to save multiple values with same meta_key, each value linked to another tag id
  71. author.php not showing content if Author has no Posts
  72. Getting user’s data, by custom field lookup (meta)
  73. Get meta_query value by user meta array
  74. select user with all meta field and field value. I am use Below Query for this ,So any of know another way to fast query instead of below query?
  75. Retrieving and inserting data in custom fields
  76. I have a form with a custom button ,i want to add the field data to an database when clicking the custom button
  77. Redirecting to an external URL
  78. Extend WP_User_Query or WP_User to return all custom fields?
  79. Updating custom fields with external data
  80. Create custom fields/meta data gender+country – radiobuttons and dropdown on register screen for these fields
  81. Custom Meta Boxes and Fields for WordPress: Change directory upload based on user-edit page
  82. Is it possible in WordPress
  83. wordpress simple post multi rating with post_meta and user_meta
  84. Download stuff after filling fields?
  85. How do i get a specific user metadata using custom metavalue outside of wordpress?
  86. Echo text if field under user_meta is empty with get_users()
  87. Custom registration form and custom field
  88. how to add radio field on user meta on function.php?
  89. Website that sells statistics
  90. Can’t sort custom column on user.php by number / meta_value_num?
  91. How to create a searchable database with a single-field search box at the front end? [closed]
  92. Add custom field to the archive page?
  93. Need small coding with Custom Fields Search
  94. How to store the value of a custom field dropdown select for post referencing?
  95. Adding extra fields to front end signup form
  96. Problem uploading different files as custom fields with front end post form
  97. make a dropdown custom field with ‘cities’ list in it
  98. Custom field on Quick Edit using select/dropdown – almost working right but not showing currently selected value
  99. Add nofollow to custom field link and make domain exceptions?
  100. How can i put a custom field inside this php
error code: 523