PHP: dropdown values from a Database

**winly_ang_batang_bronsy** · 01-08-2011, 01:04 PM

mga PHP gurus. pwede ko mag ask ug simple PHP codes in which ang dropdown sa form kay values from a database. kana lang simple na code para dali ra nako masabtan. ayaw lang na complicated kay beginner pa ko. then if naay mga comments mas maayo para mas sayon nako pag sabot sa codes ninyo.

thnx daan mga PHP gurus.

**dodie** · 01-08-2011, 02:15 PM

Originally Posted by winly_ang_batang_bronsy

mga PHP gurus. pwede ko mag ask ug simple PHP codes in which ang dropdown sa form kay values from a database. kana lang simple na code para dali ra nako masabtan. ayaw lang na complicated kay beginner pa ko. then if naay mga comments mas maayo para mas sayon nako pag sabot sa codes ninyo.

thnx daan mga PHP gurus.

OPEN THIS LINK:
PHP: mysql_fetch_assoc - Manual

same as usual.. u have to use those syntax to access to the database. Within the loop just "concatenate" <option> tags inside. :P
You can understand the codes how the concept goes. You don't need spoon feeding for it

**ChaosOrb** · 01-08-2011, 02:41 PM

Adding from what dodie suggested, one straight forward solution would be to extract the data from DB and display them using a loop. Let's assume that you have the values from the DB stored in an array, then using a looping statement echo each item in the array.

Code:

<select name="fromDB">
<?php
// lets assume that $arrayfromDB has the all the values.

foreach($arrayfromDB as $item){
  echo "<option>".$item."</option>";
}
?>
</select>

**dodie** · 01-08-2011, 05:09 PM

Originally Posted by ChaosOrb

Adding from what dodie suggested, one straight forward solution would be to extract the data from DB and display them using a loop. Let's assume that you have the values from the DB stored in an array, then using a looping statement echo each item in the array.

Code:

<select name="fromDB">
<?php
// lets assume that $arrayfromDB has the all the values.

foreach($arrayfromDB as $item){
  echo "<option>".$item."</option>";
}
?>
</select>

apir choi!!!

modified code for ChaosOrb

Code:

foreach($arrayfromDB as $item){
  echo '<option value="'.addslashes($item).'">'.$item.'</option>';
}

ang container quotes replaced into sinqle quotes.... aron dili na maaglibog2x sa quotes usage, specially in values attribute. hehehe :3

**salbahis** · 01-09-2011, 01:25 AM

Originally Posted by dodie

apir choi!!!

modified code for ChaosOrb

Code:

foreach($arrayfromDB as $item){
  echo '<option value="'.addslashes($item).'">'.$item.'</option>';
}

ang container quotes replaced into sinqle quotes.... aron dili na maaglibog2x sa quotes usage, specially in values attribute. hehehe :3

modify nato gamay, kini pwede maka select ug specific option thru $_REQUEST

PHP Code:


foreach($arrayfromDB as $item){

  echo '<option value="'.addslashes($item).'"'.($_REQUEST['key'] == addslashes($item) ? ' selected="selected"' : '').'>'.$item.'</option>';

}

if libug na, ignore nalang ni...

**winly_ang_batang_bronsy** · 01-11-2011, 12:31 PM

thanks sa mga replies ninyong tanan...

**winly_ang_batang_bronsy** · 01-19-2011, 05:19 PM

hi guys i need your help. please ko usab ani nga code kay mag error. thanks daan guys.

<?php
//Connect to MySQL:
$db_connection = mysql_connect ("localhost","root","");

//Select the database
mysql_select_db("tutorial");

//I have the following SQL statement and execution:
$get_list = "SELECT first_name FROM employee";
$get_list_result = mysql_query($get_list) or die (mysql_error());
?>
//Then I want to display the value from database in the drop down list with the code below:
<html>
<body>
<td><select name="sel_id">
<?php
while ($recs = mysql_fetch_array($get_list_result)){
$id = $recs['AREA_ID'];
$display_list = $recs['RESP_AREA'];
<option value="$id">echo '$display_list';</option>
}// end while
?>
</select>
</td>
</body>
</html>

**krissy86** · 01-19-2011, 05:46 PM

i think nag error ni cya kay tungod sa imo Select, ang iya ra i return is ang "firstname" nya nag kuha ka og "AREA_ID" and "RESP_AREA"

try changing it to *

**winly_ang_batang_bronsy** · 01-19-2011, 06:08 PM

mag error man japon sis/bro. or pwede paki butang daw sample code na naay usa ka dropdown then ang value niya is from a column on a database.

let's just say:

column name is country

so sa dropdown it would be list of country which is sulod sa column country.

from start til end daw na code sis then paki put comments lang para easier for me to understand...

thanks.

**1722** · 01-19-2011, 06:21 PM

Originally Posted by winly_ang_batang_bronsy

hi guys i need your help. please ko usab ani nga code kay mag error. thanks daan guys.

<?php
//Connect to MySQL:
$db_connection = mysql_connect ("localhost","root","");

//Select the database
mysql_select_db("tutorial");

//I have the following SQL statement and execution:
$get_list = "SELECT first_name FROM employee";
$get_list_result = mysql_query($get_list) or die (mysql_error());
?>
//Then I want to display the value from database in the drop down list with the code below:
<html>
<body>
<td><select name="sel_id">
<?php
while ($recs = mysql_fetch_array($get_list_result)){
$id = $recs['AREA_ID'];
$display_list = $recs['RESP_AREA'];
<option value="$id">echo '$display_list';</option>
}// end while
?>
</select>
</td>
</body>
</html>

- murag diri ka nasangit...

<option value="$id">echo '$display_list';</option>
- try daw ug..

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

unya, kadto imu sql statement, ibutang ang * as suggested...

Thread: PHP: dropdown values from a Database

Thread Tools

Search Thread