Ad:

PHP Discussion Thread
Unsolved
Views: 9914

Dec 22nd, 2008

Using <select> tag with PHP

Expand Post »

i was trying to configure about how to work with <select> tag, when i was stuck with this problem: when i choose the <select> tag with PHP, i just want that that value of the <option> tag on the <select> tag will be the value selected after i submit the form. but the thing is, it will go back to the default value. Just try to look at the code:

PHP Syntax (Toggle Plain Text)
 <select name="project">
   	<option value="">-Select one-</option> -->
        <?php 
        	while($proj = mysql_fetch_array($qryS)){
			$id = $proj['id'];
			$project = $proj['project'];
 
			$i = $i + 1;
			echo "<option value=\"$i\"";
			echo ($i == $id) ? "SELECTED":"";
			echo ">" . $project . "</option>";
 
			}
 
			?>      
    </select>
 <select name="project">
   	<option value="">-Select one-</option> -->
        <?php 
        	while($proj = mysql_fetch_array($qryS)){
			$id = $proj['id'];
			$project = $proj['project'];
			
			$i = $i + 1;
			echo "<option value=\"$i\"";
			echo ($i == $id) ? "SELECTED":"";
			echo ">" . $project . "</option>";
			
			}
			
			?>      
    </select>

so this is my code. I try to fetch some data from my database.

anyone can help. I really need your help guys. thanks

Similar Threads

dynamic drop down menu in php in PHP
2 questions involving scripts, select tag, and loading pages in PHP
php mailto () fuction in PHP
'update' select menu in PHP
using Onchange() in PHP in PHP

ckurtz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2007

Permalink

Dec 23rd, 2008

Re: Using <select> tag with PHP

Hi,
This is very simple. I can help You. Just follow the code given below

php Syntax (Toggle Plain Text)
$con=mysql_connect("localhost","username","password");
		if (!$con)
		die("Couldn't connect to MySQL");
		mysql_select_db("databasename",$con)
		or die("Couldn't open admin: ".mysql_error());
		$q1=mysql_query("SELECT <fieldname> FROM <tablename>");
		?>
        <select name="<fieldname>">
		<?
	    while($row=mysql_fetch_array($q1))
		{
		?>
		<option value="<?php echo $row['<fieldname>'];?>">
        <?php 
		echo $row['<fieldname>'];
 
		 ?>
	    </option>
	    <?
		 }
	    ?>
		</select>
$con=mysql_connect("localhost","username","password");
		if (!$con)
		die("Couldn't connect to MySQL");
		mysql_select_db("databasename",$con)
		or die("Couldn't open admin: ".mysql_error());
		$q1=mysql_query("SELECT <fieldname> FROM <tablename>");
		?>
        <select name="<fieldname>">
		<?
	    while($row=mysql_fetch_array($q1))
		{
		?>
		<option value="<?php echo $row['<fieldname>'];?>">
        <?php 
		echo $row['<fieldname>'];
		
		 ?>
	    </option>
	    <?
		 }
	    ?>
		</select>

Just remove username,password, databasename, tablename,fieldname as you have.
I hope this will work

Last edited by peter_budo; Dec 23rd, 2008 at 7:05 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

ashafaaiz

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

20 posts
since Dec 2008

Permalink

Dec 23rd, 2008

Re: Using <select> tag with PHP

Click to Expand / Collapse Quote originally posted by ashafaaiz ...

Hi,
This is very simple. I can help You. Just follow the code given below

$con=mysql_connect("localhost","username","password");
if (!$con)
die("Couldn't connect to MySQL");
mysql_select_db("databasename",$con)
or die("Couldn't open admin: ".mysql_error());
$q1=mysql_query("SELECT <fieldname> FROM <tablename>");
?>
<select name="<fieldname>">
<?
while($row=mysql_fetch_array($q1))
{
?>
<option value="<?php echo $row['<fieldname>'];?>">
<?php
echo $row['<fieldname>'];

?>
</option>
<?
}
?>
</select>

Just remove username,password, databasename, tablename,fieldname as you have.
I hope this will work

i better try this now. thanks

ckurtz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2007

Permalink

Dec 23rd, 2008

Re: Using <select> tag with PHP

Click to Expand / Collapse Quote originally posted by ckurtz ...

i was trying to configure about how to work with <select> tag, when i was stuck with this problem: when i choose the <select> tag with PHP, i just want that that value of the <option> tag on the <select> tag will be the value selected after i submit the form. but the thing is, it will go back to the default value. Just try to look at the code:
PHP Syntax (Toggle Plain Text)
 <select name="project">
   	<option value="">-Select one-</option> -->
        <?php 
        	while($proj = mysql_fetch_array($qryS)){
			$id = $proj['id'];
			$project = $proj['project'];
 
			$i = $i + 1;
			echo "<option value=\"$i\"";
			echo ($i == $id) ? "SELECTED":"";
			echo ">" . $project . "</option>";
 
			}
 
			?>      
    </select>
<select name="project"> <option value="">-Select one-</option> --> <?php while($proj = mysql_fetch_array($qryS)){ $id = $proj['id']; $project = $proj['project']; $i = $i + 1; echo "<option value=\"$i\""; echo ($i == $id) ? "SELECTED":""; echo ">" . $project . "</option>"; } ?> </select>
so this is my code. I try to fetch some data from my database.

anyone can help. I really need your help guys. thanks

thank you for this code. I tried it and the result is still the same. I just want that the value of the selected option will show in the <select> tag when i submit the form. it will stay in the same as i chose from the selected option.

ckurtz

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

21 posts
since Dec 2007

Permalink

Mar 7th, 2009

Re: Using <select> tag with PHP

hi there..
i almost got the same problem.
i have 3 drop down menus in my page.
i was able to populate the first drop down menu.
the 2nd and 3rd drop down menu was not successfully
populated.
hope you can help me.
my query goes:
$query = "SELECT table1.col1, table2.col2
FROM table1, table2"
the first drop down menu would work, not in the succeeding
drop down menu.

Thanks,
Tintin

================================================

Click to Expand / Collapse Quote originally posted by ashafaaiz ...

Hi,
This is very simple. I can help You. Just follow the code given below
php Syntax (Toggle Plain Text)
$con=mysql_connect("localhost","username","password");
		if (!$con)
		die("Couldn't connect to MySQL");
		mysql_select_db("databasename",$con)
		or die("Couldn't open admin: ".mysql_error());
		$q1=mysql_query("SELECT <fieldname> FROM <tablename>");
		?>
        <select name="<fieldname>">
		<?
	    while($row=mysql_fetch_array($q1))
		{
		?>
		<option value="<?php echo $row['<fieldname>'];?>">
        <?php 
		echo $row['<fieldname>'];
 
		 ?>
	    </option>
	    <?
		 }
	    ?>
		</select>
$con=mysql_connect("localhost","username","password"); if (!$con) die("Couldn't connect to MySQL"); mysql_select_db("databasename",$con) or die("Couldn't open admin: ".mysql_error()); $q1=mysql_query("SELECT <fieldname> FROM <tablename>"); ?> <select name="<fieldname>"> <? while($row=mysql_fetch_array($q1)) { ?> <option value="<?php echo $row['<fieldname>'];?>"> <?php echo $row['<fieldname>']; ?> </option> <? } ?> </select>
Just remove username,password, databasename, tablename,fieldname as you have.
I hope this will work

clmirand

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Feb 2008

Permalink

Mar 8th, 2009

Re: Using <select> tag with PHP

Quote originally posted by clmirand ...

hi there..
i almost got the same problem.
i have 3 drop down menus in my page.
i was able to populate the first drop down menu.
the 2nd and 3rd drop down menu was not successfully
populated.

Well you have only provided one query there so that would be why only one menu is working. Does your script look something like the following:

php Syntax (Toggle Plain Text)
$con=mysql_connect("localhost","username","password");
if (!$con) die("Couldn't connect to MySQL");
mysql_select_db("databasename",$con) or die("Couldn't open admin: ".mysql_error());
$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowa=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowa['<fieldname>'].'">';
    echo $rowa['<fieldname>'].'</option>';
    }
echo '</select>';
 
 
$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowb=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowb['<fieldname>'].'">';
    echo $rowb['<fieldname>'].'</option>';
    }
echo '</select>';
 
 
$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowc=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowc['<fieldname>'].'">';
    echo $rowc['<fieldname>'].'</option>';
    }
echo '</select>';
$con=mysql_connect("localhost","username","password");
if (!$con) die("Couldn't connect to MySQL");
mysql_select_db("databasename",$con) or die("Couldn't open admin: ".mysql_error());
$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowa=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowa['<fieldname>'].'">';
    echo $rowa['<fieldname>'].'</option>';
    }
echo '</select>';


$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowb=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowb['<fieldname>'].'">';
    echo $rowb['<fieldname>'].'</option>';
    }
echo '</select>';


$q1=mysql_query('SELECT table1.col1, table2.col2 FROM `table1`, `table2`');
echo '<select name="<fieldname>">';
while($rowc=mysql_fetch_array($q1))
    {
    echo '<option value="'.$rowc['<fieldname>'].'">';
    echo $rowc['<fieldname>'].'</option>';
    }
echo '</select>';

Note: In the above example replace <fieldname> with the real column name.
And also, just as an opinion, I find the examples in previous posts to be very basic and very non-php in a way. I believe the echo/print functions are the way to go.

cwarn23

Sponsor

Featured Poster

Reputation Points: 410

Solved Threads: 258

Occupation: Genius

Offline

3,004 posts
since Sep 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: Insert record into db by using ajax post method?

Next Thread in PHP Forum Timeline: Hello, someone please HELP me

DaniWeb Message

Cancel Changes

User Name
Password