Populating dropdowns

Dev Shed Forums Sponsor:

March 5th, 2004, 08:19 PM

zci

Registered User

Join Date: Mar 2004

Posts: 17

Time spent in forums: 58 m 31 sec
Reputation Power: 0

Populating dropdowns

I'm trying to dynamically populate a dropdown fom a database MySQL db using Python. I am stuck. Can somebody please help on how to get started or point in right direction? Thanks in advance!

March 5th, 2004, 09:44 PM

jimmy2k1

Contributing User

Join Date: Mar 2002

Posts: 89

Time spent in forums: 8 h 48 m 50 sec
Reputation Power: 7

so what exactly don't you understand? you grab the info out of the db and write it in the HTML form.

March 6th, 2004, 06:34 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,532

Time spent in forums: 1 Week 2 Days 17 h 38 m 15 sec
Reputation Power: 63

As 2k said, there isn't really a lot to get stuck on here

but anyway here's a little example - this doesn't use any db since i don't have any data to populate this t with.

Code:

#!/usr/bin/env python

print 'Content-Type: text/html\n'

values = ['Name1', 'Name2', 'Name3', 'Name4']

print'<form name="form">'
print'<select name="names">'
print'<option selected>Netytan</option>'

for value in values:
    print'<option>%s</option>' % value

print'</select>'
print'</form>'

Note: 'values' can be a simple cursor or list/tuple object. needs a little reworking if you want to use dictionaries but it shows you exactly what you need.... so, a loop

Mark.

__________________
programming language development: www.netytan.com – Hula

March 19th, 2004, 11:48 AM

zci

Registered User

Join Date: Mar 2004

Posts: 17

Time spent in forums: 58 m 31 sec
Reputation Power: 0

Thanks netytan. I kinda figured out myself but appreciate your example!

Quote:

Originally Posted by netytan

As 2k said, there isn't really a lot to get stuck on here

but anyway here's a little example - this doesn't use any db since i don't have any data to populate this t with.

Code:

#!/usr/bin/env python

print 'Content-Type: text/html\n'

values = ['Name1', 'Name2', 'Name3', 'Name4']

print'<form name="form">'
print'<select name="names">'
print'<option selected>Netytan</option>'

for value in values:
    print'<option>%s</option>' % value

print'</select>'
print'</form>'

Note: 'values' can be a simple cursor or list/tuple object. needs a little reworking if you want to use dictionaries but it shows you exactly what you need.... so, a loop

Mark.

Viewing: Dev Shed Forums > Programming Languages > Python Programming > Populating dropdowns

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump