RBA Cash Rate: 4.35% · 1AUD = 0.67 USD · Inflation: 4.1%

Leading Digital Marketing Experts</strong | 1300 235 433 | Aggregation Enquires Welcome | Book Appointment

Example Interest Rates: Home Loan Variable: 5.69% (5.89%*) • Home Loan Fixed: 5.39% (6.59%*) • Fixed: 5.39% (6.59%*) • Variable: 5.69% (5.89%*) • Investment IO: 5.69% (6.48%*) • Investment PI: 5.39% (6.59%*)

Populate Dropdown Box from Array (or DB) with PHP

Populating a HTML dropdown box given the values of an array, or populating a dropdown box from values in a database, is a very easy and useful tool that demonstrates the simplistic power of PHP. Below are a few examples. This was written in 2005. Since then, of course, the MySQL functions are largely unsupported... but we'll keep them for the sake of the examples.

The end result of the below code will give you something that looks like this:

The following code will populate a dropdown box with an option name.
Example: <option value="Sydney">Sydney</option>

<?php

/* Array Contents */

$array1 = array('Sydney','Melbourne','Brisbane','Tasmania','Adelaide','Perth','Darwin','ACT');

echo '<select name="cities">';

/* For each value of the array assign variable name "city" */

foreach($array1 as $city){

echo '<option value="' . $city . '">' . $city . '</option>';

}

echo'</select>';

The following code will populate a dropdown box with an option value and name.
Example: <option value="s">Sydney</option>

<?php

/* Array contents */

$array2 = array('s'=>'Sydney','m'=>'Melbourne','b'=>'Brisbane','T'=>'Tasmania','a'=>'Adelaide','p'=>'Perth','d'=>'Darwin','t'=>'ACT');

echo '<select name="cities">';

foreach($array2 as $cityid => $city) {

echo '<option value="' . $cityid . '">' . $city . '</option>';

}

echo '</select>';

More often than not, you'll want to populate a dropdown box based on the values retrieved from a database.

<?php

$result = mysql_query("select DISTINCT id, cities from locations");

echo '<select name="city"><OPTION>';

echo "Select an option</OPTION>";

while ($row = mysql_fetch_array($result)) {

$id = $row["id"];

$city = $row["cities"];

echo '<OPTION value="' . $id . '">' . $city . '</OPTION>';

}

echo '</SELECT>';

It's almost always best to build these features into a function and return the result.

General Enquires: 1300 235 433 • Support: (02) 8765 8887

The comparison rate is calculated on a secured loan of $150,000 with a term of 25 years with monthly principal and interest payments. WARNING: This comparison rate is true only for examples given and may not include all fees and charges. Different terms, fees or other loan amounts might result in a different comparison rate. Important Information: Applications are subject to credit approval. Full terms and conditions will be included in our loan offer. Fees and charges are payable. Interest rates are subject to change. Offer does not apply to internal refinances and is not transferable between loans. As this advice has been prepared without considering your objectives, financial situation or needs, you should consider its appropriateness to your circumstances before acting on the advice. [ Example Credit Guide Link ]

BeliefMedia Pty Limited

Populate Dropdown Box from Array (or DB) with PHP

Like this article?

Martin Khoury

Leave a comment