Ad:

PHP Discussion Thread
Unsolved
Views: 7253

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jul 19th, 2008

populating drop down menu from MySQL

Expand Post »

hi guys.

i hav this drop down menu, which i need to populate with data from one column of a particular table of MySQL dbase.

i hav read a lot on this, but have not been able to come up wid any code.

any and all help in this regard will be greatly appreciated.

thx a ton.

akshit

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

46 posts
since Jun 2008

Permalink

Jul 19th, 2008

Re: populating drop down menu from MySQL

Use this code in your application:

php Syntax (Toggle Plain Text)
<? 
$query="SELECT sub_cat_id, sub_cat_name FROM category";
 
/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */
 
$result = mysql_query ($query);
echo "<select name=category value=''></option>";
// printing the list box select command
 
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[sub_cat_id]>$nt[sub_cat_name]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box 
?>
<? 
$query="SELECT sub_cat_id, sub_cat_name FROM category";

/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */

$result = mysql_query ($query);
echo "<select name=category value=''></option>";
// printing the list box select command

while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[sub_cat_id]>$nt[sub_cat_name]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box 
?>

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Jul 19th, 2008

Re: populating drop down menu from MySQL

I you want to display the second dropdown from first dropdown,then see this thread:
http://www.daniweb.com/forums/thread77281.html

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Oct 25th, 2009

Could I ask for help please

Hi to all
I have a drop down list that is populated from my mysql database, and works fine.
How to eliminate duplicate entries. I have seen the answer a 100 times but cant get it to work.
Here is the snip of code that I have

php Syntax (Toggle Plain Text)
$result = mysql_query ($query);
echo "<select name=Location value=''>Location</option>";
// printing the list box select command
 
while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[Town]>$nt[Location]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box
 
mysql_free_result($result) ;
$result = mysql_query ($query);
echo "<select name=Location value=''>Location</option>";
// printing the list box select command

while($nt=mysql_fetch_array($result)){//Array or records stored in $nt
echo "<option value=$nt[Town]>$nt[Location]</option>";
/* Option values are added by looping through the array */
}
echo "</select>";// Closing of list box

mysql_free_result($result) ;

Last edited by peter_budo; Oct 25th, 2009 at 7:05 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

phobia1

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Aug 2007

Permalink

Oct 26th, 2009

Re: populating drop down menu from MySQL

0. $query="SELECT DISTINCT * FROM Garant GROUP BY Location";

Thanks for all that helped and apologies that I upset the moderators

phobia1

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

25 posts
since Aug 2007

Permalink

Nov 22nd, 2011

-1

Re: populating drop down menu from MySQL

Hello,
I have the drop down box as follows:
<label for="country">Country</label>
<select name="countryID"><?php echo $HTML['country_options_escape'];?></select>

how can I display data from mysql, I tried the following but did not work:
<label for="country">Country</label>
<select name="countryID"><?php $query="select country from countries where active ='YES'";
$result = mysql_query($query, $GLOBALS['DB']);

while($nt=mysql_fetch_array($result)){ //Array or records stored in $nt

$HTML['country_options_escape']=$nt[country];

//<option value=$nt[country]></option>;

}

echo $HTML['country_options_escape'];?></select>

Thanks

rse

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Nov 2011

Permalink

Nov 23rd, 2011

Re: populating drop down menu from MySQL

@rse

fix this first, and then repost your codes. Unless, you define it somewhere it would make sense, but right now, I don't see it making any sense at all. Can you please elaborate or shades some light on where this line of codes coming from??

PHP Syntax (Toggle Plain Text)
$HTML['country_options_escape']=$nt[country];
$HTML['country_options_escape']=$nt[country];

The only time I remember writing such arrangement was for smarty array, but not like yours.

this is valid
//while begins here
$something['it_is'] = (string) $so['this_is'];
$something['am_i'] = (string) $so['am_i'];
$assignItHere[] = $something;

//end of while loop

return $assignItHere;

veedeoo

Reputation Points: 39

Solved Threads: 10

Junior Poster in Training

Offline

88 posts
since Oct 2011

Permalink

Nov 23rd, 2011

Re: populating drop down menu from MySQL

@ rse,

Try using this simple example. Maybe, it will help you locate the problems on your codes.

PHP Syntax (Toggle Plain Text)
 
<?php
 
## we can do it the simpler way, and if it is working properly, we can add more into
## it to make it fancier. For now it is always nice to start in simpler form.
 
## define your database connection credentials
mysql_connect( $db_host, $db_user, $db_password ) or die(mysql_error());
mysql_select_db( $db_database ) or die(mysql_error());
 
## make sure that 'YES' can be found as shown on in the country rows under active column
$countries = mysql_query("SELECT * country FROM countries WHERE active='YES'")
or die(mysql_error());
 
## lets loop the crap out of the toid
while($country = mysql_fetch_array( $countries ))
{
 
## I am assuming here that your countries table has the following columns
##  id    | name      | active    
##  100   | Bundagle  |  YES 
##  200   | Somewhere |  YES
    $country_id = $country['id'];
    $country_name = $country['name'];
## Now, let's assign the country inside the option form tags.
## the country named bundagle and somewhere should be now inside the option tags.
    $country_block .= '<OPTION value="'.$country_id.'">'.$country_name.'</OPTION>'; 
 
} ## end while loop
 
## now lets show the result from the table countries.
?>
<!-- notice the country_block is outside the crap, of which will give you more freedom to modify the html tags without so much clutter-->
 
<label for="country">Country</label>
<select name="countryID"><?php echo $country_block; ?></select>
<?php

## we can do it the simpler way, and if it is working properly, we can add more into
## it to make it fancier. For now it is always nice to start in simpler form.

## define your database connection credentials
mysql_connect( $db_host, $db_user, $db_password ) or die(mysql_error());
mysql_select_db( $db_database ) or die(mysql_error());

## make sure that 'YES' can be found as shown on in the country rows under active column
$countries = mysql_query("SELECT * country FROM countries WHERE active='YES'")
or die(mysql_error());

## lets loop the crap out of the toid
while($country = mysql_fetch_array( $countries ))
{

## I am assuming here that your countries table has the following columns
##  id    | name      | active    
##  100   | Bundagle  |  YES 
##  200   | Somewhere |  YES
    $country_id = $country['id'];
    $country_name = $country['name'];
## Now, let's assign the country inside the option form tags.
## the country named bundagle and somewhere should be now inside the option tags.
    $country_block .= '<OPTION value="'.$country_id.'">'.$country_name.'</OPTION>'; 

} ## end while loop

## now lets show the result from the table countries.
?>
<!-- notice the country_block is outside the crap, of which will give you more freedom to modify the html tags without so much clutter-->

<label for="country">Country</label>
<select name="countryID"><?php echo $country_block; ?></select>

Last edited by veedeoo; Nov 23rd, 2011 at 3:57 am.

veedeoo

Reputation Points: 39

Solved Threads: 10

Junior Poster in Training

Offline

88 posts
since Oct 2011

Permalink

Nov 23rd, 2011

Re: populating drop down menu from MySQL

wonderful thanks

rse

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Nov 2011

Permalink

13 Days Ago

Re: populating drop down menu from MySQL

Ok guys I need some help... I am having a similar issue let me tell you a little bit of what I am wanting to do.

I have a MySQL database with my data in it that I want on my web page.

What I need is a table with all of the data that is in that database listed and above it I want drop downs people can select from to filter the table to display just what they are looking for. With each drop down options coming from my data base and depending on what the first drop down had selected...

What I have so far on the MAIN page is this.

PHP Syntax (Toggle Plain Text)
<?
 
$sql="SELECT id, bar_name FROM barlist"; 
$result=mysql_query($sql); 
 
$options=""; 
 
while ($row=mysql_fetch_array($result)) { 
 
    $id=$row["id"]; 
    $thing=$row["bar_name"]; 
    $options.="<OPTION VALUE=\"$id\">$bar_name</option>";
} 
?>
 
<SELECT NAME=id> 
<OPTION VALUE=0>Choose 
<? echo $options?> 
</SELECT>
<?

$sql="SELECT id, bar_name FROM barlist"; 
$result=mysql_query($sql); 

$options=""; 

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

    $id=$row["id"]; 
    $thing=$row["bar_name"]; 
    $options.="<OPTION VALUE=\"$id\">$bar_name</option>";
} 
?>

<SELECT NAME=id> 
<OPTION VALUE=0>Choose 
<? echo $options?> 
</SELECT>

and on the data base connection page I have this

PHP Syntax (Toggle Plain Text)
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Untitled 1</title>
</head>
 
<body>
<?php
$q=$_GET["q"];
 
$con = mysql_connect('DATABASE', 'USER', 'PASSWORD');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("DATABASE", $con);
 
$sql="SELECT * FROM bar WHERE id = '".$q."'";
 
$result = mysql_query($sql);
 
echo "<table border='1'>
<tr>
<th>Bar Name</th>
<th>Address</th>
<th>Time they open</th>
<th>Time they close</th>
</tr>";
 
while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['bar_name'] . "</td>";
  echo "<td>" . $row['address'] . "</td>";
  echo "<td>" . $row['bar_open'] . "</td>";
  echo "<td>" . $row['bar_close'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
 
mysql_close($con);
?>
</body>
 
</html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Untitled 1</title>
</head>

<body>
<?php
$q=$_GET["q"];

$con = mysql_connect('DATABASE', 'USER', 'PASSWORD');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("DATABASE", $con);

$sql="SELECT * FROM bar WHERE id = '".$q."'";

$result = mysql_query($sql);

echo "<table border='1'>
<tr>
<th>Bar Name</th>
<th>Address</th>
<th>Time they open</th>
<th>Time they close</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['bar_name'] . "</td>";
  echo "<td>" . $row['address'] . "</td>";
  echo "<td>" . $row['bar_open'] . "</td>";
  echo "<td>" . $row['bar_close'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
</body>

</html>

The above code gives me the following errors on the main page

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/40/8248640/html/murfreesboro.php on line 96

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/40/8248640/html/murfreesboro.php on line 96

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/40/8248640/html/murfreesboro.php on line 100

I know a lot of reading I am sorry if you guys could help me out I would greatly appreciate it!

jgilliam

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Feb 2012

Page 1
2
Next

Previous Thread in PHP Forum Timeline: Class and Function Confusion

Next Thread in PHP Forum Timeline: php rearange issue

DaniWeb Message

Cancel Changes

User Name
Password