Databases
StackOverflow2013
Postsdbo
POHow to load select options from external files with PHP
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to load select options from external files with PHP
    text
    copied!<p>I am trying to create a dynamic city drop-down selector, where a user selects a country, then a region, then a city. Right now I have two tables in a MySQL database, one with all the regions, and one with all the cities, and I am using jQuery to first load the regions when a user selects a country, then a city when a region is selected.</p> <p>My site gets quite a bit of traffic, and I am worried this is terribly inefficient... every time someone makes a selection, the database is queried and sometimes hundreds of rows are parsed and returned.</p> <p>Instead of querying the database, since the list of cities will never change, I want to store each country and region as a separate file, and load them when needed.</p> <p>For example: IE.html (Ireland)</p> <pre><code>&lt;option value="0" selected&gt;- Select -&lt;/option&gt; &lt;option value="11287"&gt;Connaught&lt;/option&gt; &lt;option value="11288"&gt;Leinster&lt;/option&gt; &lt;option value="11289"&gt;Munster&lt;/option&gt; &lt;option value="11290"&gt;Ulster&lt;/option&gt; </code></pre> <p>11290.html (Ulster)</p> <pre><code>&lt;option value="xxxxxxx"&gt;Buncrana&lt;/option&gt; &lt;option value="xxxxxxx"&gt;Cavan&lt;/option&gt; &lt;option value="xxxxxxx"&gt;Letterkenny&lt;/option&gt; &lt;option value="xxxxxxx"&gt;Monaghan&lt;/option&gt; </code></pre> <p>The problem is, I can't figure out how to load these files back into the select menus. There are loads of resources out there about creating options with external files, but I can't find anything about loading plain HTML into the form.</p> <p>Is this even possible?</p> <p>Thank you!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload