Ad:

PHP Discussion Thread
Unsolved
Views: 1156

Permalink

Dec 19th, 2007

dynamic dropdown

Expand Post »

hi

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

Similar Threads

dynamic dropdown selection in PHP
Dynamic dropdown list in ASP.NET
Storing dynamic form values in Arrays for display & insert in PHP
Dropdown box in Python in Python
Making T.Greer's JavaScript-synthesised combobox dynamic in JavaScript / DHTML / AJAX

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

polute ? What do you mean by that ?

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

try this code it works for me

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>

tirivamwe

Reputation Points: 11

Solved Threads: 2

Light Poster

Offline

36 posts
since Oct 2005

Permalink

Dec 19th, 2007

Re: dynamic dropdown

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

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

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

tirivamwe

Reputation Points: 11

Solved Threads: 2

Light Poster

Offline

36 posts
since Oct 2005

Permalink

Dec 19th, 2007

Re: dynamic dropdown

thanks

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

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

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>

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

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>

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

Click to Expand / Collapse Quote 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>

$id=$_REQUEST['id'] should be $id=$_REQUEST['Names']

And Please, next time you post your code, place it within [ code] ... [ / code] tags !

Last edited by nav33n; Dec 19th, 2007 at 7:10 am.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Dec 19th, 2007

Re: dynamic dropdown

sorry.......

thanks

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: upload files

Next Thread in PHP Forum Timeline: Access hidden values by javascript

DaniWeb Message

Cancel Changes

User Name
Password