How to create a dynamic dropdown list
How to create a dynamic dropdown list
Hi Iam new to PHP,how to create a Dynamic drop down list using Mysql. Help me how to code for this.
What do you want the dropdown list to do? Can you please be a little specific?
If you want to make a dropdown box using PHP + mysql, I suppose you can do something similar to:
[PHP]
<?php
// if you want to get data from the database..
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("Database_name", $db);
// query the database for something
$query = "SELECT * FROM table WHERE category = 'computers'";
$qHandler = mysql_query($query);
// list all the results from the database...
while ($data = myql_fetch_array($qHandler)) {
$dropdownlist .= "<option value=\"$data['value']\">$data['value']</option>";
}
// echo out the results from the database within a dropdown list...
echo "<select name=\"Dropdown_List\">" . $dropdownlist . "</select>";
?>
[/PHP]
I haven't tested the code yet... but that's probably what I would do if I need to make a dropdown list according to results from mysql using php.
If you want to make a dropdown box using PHP + mysql, I suppose you can do something similar to:
[PHP]
<?php
// if you want to get data from the database..
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("Database_name", $db);
// query the database for something
$query = "SELECT * FROM table WHERE category = 'computers'";
$qHandler = mysql_query($query);
// list all the results from the database...
while ($data = myql_fetch_array($qHandler)) {
$dropdownlist .= "<option value=\"$data['value']\">$data['value']</option>";
}
// echo out the results from the database within a dropdown list...
echo "<select name=\"Dropdown_List\">" . $dropdownlist . "</select>";
?>
[/PHP]
I haven't tested the code yet... but that's probably what I would do if I need to make a dropdown list according to results from mysql using php.
Create table named "select_links" and it MUST have these fields:
link_target- varchar(255)
link_name- varchar (100)
[PHP]
<?
$query = 'SELECT * FROM select_links';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in select menu
echo "<form name=\"jump\">
<select name=\"menu\" onChange=\"location=****.jump.menu.options[****.jump.menu.selectedIndex].value;\" value=\"GO\">";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
echo "<option value=\"".$line["link_target"]."\">".$line["link_name"]."</option>\n";
echo "</select></form>";
?>[/PHP]
link_target- varchar(255)
link_name- varchar (100)
[PHP]
<?
$query = 'SELECT * FROM select_links';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in select menu
echo "<form name=\"jump\">
<select name=\"menu\" onChange=\"location=****.jump.menu.options[****.jump.menu.selectedIndex].value;\" value=\"GO\">";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
echo "<option value=\"".$line["link_target"]."\">".$line["link_name"]."</option>\n";
echo "</select></form>";
?>[/PHP]
-
- Posts: 12
- Joined: Sat Feb 17, 2007 11:34 pm
You can use pre-made scripts for your site including Drop Down List and many other scripts from http://www.dynamicdrive.com/