DaniWeb Forum Index > Web Development > PHP

dynamic dropdown

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

dynamic dropdown

Dec 19th, 2007

hi

how to polute my drop down using the database content...........

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: dynamic dropdown

Dec 19th, 2007

polute ? What do you mean by that ?

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Oct 2005

Posts: 36

Reputation: tirivamwe is an unknown quantity at this point

Solved Threads: 2

tirivamwe

Offline

Light Poster

Re: dynamic dropdown

Dec 19th, 2007

try this code it works for me

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="forum"; // Database name
$tbl_name="test_mysql"; // Table name
 
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
 
$sql="SELECT * FROM test_mysql";
$result=mysql_query($sql);
 
?>
 
<form name="form1" method="post" action="">
  <select name="Names" id="Names">
<?php
 
while($rows=mysql_fetch_array($result, MYSQL_ASSOC))
 
{
 
 
 
echo"<option>". $rows['name']."</option>"; //to display names from database in field called name
 
 
}
 
mysql_close();
?>
 
 
  </select>
</form>
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="forum"; // Database name
$tbl_name="test_mysql"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM test_mysql";
$result=mysql_query($sql);

?>

<form name="form1" method="post" action="">
  <select name="Names" id="Names">
<?php

while($rows=mysql_fetch_array($result, MYSQL_ASSOC))

{



echo"<option>". $rows['name']."</option>"; //to display names from database in field called name


}

mysql_close();
?>
 
 
  </select>
</form>

If you find this useful you can add to my reputation

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: dynamic dropdown

Dec 19th, 2007

sorry how to retrieve the table content and display in a dropdown

•

Join Date: Oct 2005

Posts: 36

Reputation: tirivamwe is an unknown quantity at this point

Solved Threads: 2

tirivamwe

Offline

Light Poster

Re: dynamic dropdown

Dec 19th, 2007

can you please be specific.

Do you want to put content from database into drop down or from a table. If from a table where is the content coming from

If you find this useful you can add to my reputation

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: dynamic dropdown

Dec 19th, 2007

thanks

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: dynamic dropdown

Dec 19th, 2007

You can do something like tirivamwe has mentioned. Or you can use a function so that you can reuse the code whenever you want.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
function dropdown($colname,$tablename){
	$query="select ".$colname." from ".$tablename;
	$result=mysql_query($query);
	$option="";
	while($row=mysql_fetch_array($result)){
		$option.="<option value=".$row[0].">".$row[0]."</option>";
	}
	return $option;
}
?>
<html>
<body>
<form>
<select name='test'>
<?php echo $options=dropdown("Column_name","Table_name"); 
//the column name of table_name which you want to display in the options 
 ?>
</select>
<select name='test1'>
<?php echo $options=dropdown("Column_name1","Table_name2"); 
 ?>
</select>
</form>
</body>
</html>
<?php
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
function dropdown($colname,$tablename){
	$query="select ".$colname." from ".$tablename;
	$result=mysql_query($query);
	$option="";
	while($row=mysql_fetch_array($result)){
		$option.="<option value=".$row[0].">".$row[0]."</option>";
	}
	return $option;
}
?>
<html>
<body>
<form>
<select name='test'>
<?php echo $options=dropdown("Column_name","Table_name"); 
//the column name of table_name which you want to display in the options 
 ?>
</select>
<select name='test1'>
<?php echo $options=dropdown("Column_name1","Table_name2"); 
 ?>
</select>
</form>
</body>
</html>

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: dynamic dropdown

Dec 19th, 2007

hi
this works but how to get the dropwown value in the next page..
i tried with $id=$_REQUEST['id']; but this is not working
<form method="get" action="sort2.php">
<?php
$hostname = "localhost";
$username = "";
$password = "";
$dbid = "";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");

$sql="SELECT id,name FROM personal";
$result=mysql_query($sql);

?>
<table>

<tr>
<td>Splendor Id</td><td><select name="Names">
<?php

while($rows=mysql_fetch_array($result))

{
echo"<option value=".$rows[0].">". $rows[1]."</option>";
}

mysql_close();
?>

</select></td>
</tr>
<tr>
<td>From</td><td><input type="text" name="from"></td>
<td>To</td><td><input type="text" name="to"></td>
<td><input type="submit" name="submit" value="submit"></td></tr>

</table>
</form>

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: dynamic dropdown

Dec 19th, 2007

•

Originally Posted by lydia21

hi
this works but how to get the dropwown value in the next page..
i tried with $id=$_REQUEST['id']; but this is not working
<form method="get" action="sort2.php">
<?php
$hostname = "localhost";
$username = "";
$password = "";
$dbid = "";
$link=mysql_connect($hostname, $username, $password);
mysql_select_db($dbid) or die("unable to connect");

$sql="SELECT id,name FROM personal";
$result=mysql_query($sql);

?>
<table>

<tr>
<td>Splendor Id</td><td><select name="Names">
<?php

while($rows=mysql_fetch_array($result))

{
echo"<option value=".$rows[0].">". $rows[1]."</option>";
}

mysql_close();
?>

</select></td>
</tr>
<tr>
<td>From</td><td><input type="text" name="from"></td>
<td>To</td><td><input type="text" name="to"></td>
<td><input type="submit" name="submit" value="submit"></td></tr>

</table>
</form>