Select option from database

Dev Shed Forums Sponsor:

March 6th, 2013, 11:33 AM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Select option from database

Hi. I have a database which holds a 'Task status' this can be
- klaar
- bezig
- hold

Now when the users sets a status. I want the user to see what he has set, problem is with my method that it shows
- hold ( currently set )
- klaar
- bezig
- hold

So it's showing the other value again cause it doesn't know that this is the selected one. How can i make sure the select doesn't repeat options.. this is my code

PHP Code:


		
			
<select name="status[]">

<option selected="selected"><?= $project['taskstatus'] ?></option>

<option value="klaar">Klaar</option>

<option value="bezig">Bezig</option>

<option value="hold">Hold</option>

</select>

Thanks.

March 6th, 2013, 12:00 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Folding Points: 417516 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

Send a message via Google Talk to requinix

Set selected on the option that matches the taskstatus.

PHP Code:


		
			
 ?><select name="status[]"> 

<option value="klaar" <?= ($project['taskstatus'] == 'klaar' ? 'selected="selected"' : '') ?>>Klaar</option> 

<option value="bezig"<?= ($project['taskstatus'] == 'bezig' ? 'selected="selected"' : '') ?>>Bezig</option> 

<option value="hold"<?= ($project['taskstatus'] == 'hold' ? 'selected="selected"' : '') ?>>Hold</option> 

</select>

__________________
Site rules and FAQ | Project Suggestions | mod_rewrite guide | PHP New User Guide and FAQ - PHP Stickies | Regex Resources

March 6th, 2013, 12:00 PM

ManiacDan

Likely to be eaten by a grue.

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

PHP Code:


		
			
 $options = array('klaar', 'bezig', 'hold');



foreach ( $options as $option ) {

  echo '<option' 

    . ($option == strtolower($project['taskstatus']) ? ' selected="selected"')

    . ' value="' . $option . '">' . ucfirst($option) . '</option>';

}

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

March 6th, 2013, 12:04 PM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

@requinix : smart solution! why didn't i think of that! thanks!

@ManiacDan : I was also thinking of array but didn't find a working solution. what's ucfirst ?

March 6th, 2013, 12:40 PM

ManiacDan

Likely to be eaten by a grue.

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

The PHP manual has all the information needed to answer "what is this function"

March 6th, 2013, 12:46 PM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Quote:

Originally Posted by ManiacDan

The PHP manual has all the information needed to answer "what is this function"

I know that the manual holds that information. But since this was an open topic i thought i'd just ask it. My apoligies

March 6th, 2013, 12:58 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

It is, and we're totally free to discuss stuff, but questions like "what does this function do?" really are best answered by a trip to the manual. There's much more information there than anyone here would be willing to type out.

March 6th, 2013, 01:19 PM

DonR

Contributing User

Join Date: Oct 2009

Posts: 464

Folding Points: 29722 Folding Title: Starter Folder

Time spent in forums: 2 Weeks 2 Days 1 h 26 m 26 sec
Reputation Power: 216

is that "<?= " considered a legit longform php open tag example now?(I thought only <?php was accepted)

March 6th, 2013, 01:38 PM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Quote:

Originally Posted by DonR

is that "<?= " considered a legit longform php open tag example now?(I thought only <?php was accepted)

PHP Code:


		
			
<?= $var ?>

echo's the var immediatly

it's like

PHP Code:


		
			
<? echo $var ?>

#10

March 6th, 2013, 02:20 PM

requinix

Still alive

Join Date: Mar 2007

Location: Washington, USA

Posts: 12,717

Time spent in forums: 5 Months 1 Week 4 Days 7 h 29 m 55 sec
Reputation Power: 8969

<?= is still technically a short tag but it's now guaranteed to be available (since 5.4 I think) regardless of the short tags setting.

#11

March 6th, 2013, 02:47 PM

ManiacDan

Likely to be eaten by a grue.

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,811

Time spent in forums: 2 Months 3 Weeks 19 h 13 m 52 sec
Reputation Power: 6112

It was supposed to be removed from the language but people like Requinix are old dogs and can't be taught new tricks, and they complained loudly enough that it got put back into the language forever.

#12

March 6th, 2013, 02:51 PM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Quote:

Originally Posted by ManiacDan

It was supposed to be removed from the language but people like Requinix are old dogs and can't be taught new tricks, and they complained loudly enough that it got put back into the language forever.

Are there other nice php shorttags that make typing easier? the <?= is really handy!

Comments on this post

requinix agrees: it really is so don't pay attention to Dan. actually that's a good idea regardless

Select option from database

Developer Shed Advertisers and Affiliates