Populating form item from SQL enum set

[Pjotr Wedersteers]

Hi

I am not even sure if it is at all possible, and I can't find the stuff I am
looking for, probably using the wrong search keys. WAMP machine (XP,
2.50.2, 4.1.5, 5.0.2)

I have a field in the MySQL table 'members':
"membertype " enum ('adult','stude nt','senior','c hild','honour')

Sofar the form used for the db only has text fields, and the data entry user
relies on IE's autocomplete to always select a valid entry for the field. I
quick fixed this script so it at least checks the validity.

I'd prefer to have a general solution where the input field is a dropdown
box or something (or radio buttons) populated directly with all valid enum
fields. In case the db later is altered, enum set is modified, all the forms
should change automatically.

(How) can I retrieve the enum values from the db and use them in a dropdown
? Or who has a pointer to the right place where I can find how to do this ?
Or an example simlar snippet maybe ?
THANKS!

Pjotr

[brommer]

Re: Populating form item from SQL enum set

I've used this once, but it's a bit ugly so here's to hoping a better
solution comes along :)

<?php

$sql = "SHOW COLUMNS FROM members LIKE 'membertype'";
$qry = mysql_query($sq l);
$res = mysql_fetch_obj ect($qry);
// This returns a row with a field 'Type' containing 'enum(...)'

$res->Type = str_replace('en um', 'array', $res->Type);

eval(" \$memberTypes = $res->Type; ");


foreach($member Types as $type) {
echo "<option...etc. "
}


?>


Pjotr Wedersteers wrote:[color=blue]
> Hi
>
> I am not even sure if it is at all possible, and I can't find the stuff I am
> looking for, probably using the wrong search keys. WAMP machine (XP,
> 2.50.2, 4.1.5, 5.0.2)
>
> I have a field in the MySQL table 'members':
> "membertype " enum ('adult','stude nt','senior','c hild','honour')
>
> Sofar the form used for the db only has text fields, and the data entry user
> relies on IE's autocomplete to always select a valid entry for the field. I
> quick fixed this script so it at least checks the validity.
>
> I'd prefer to have a general solution where the input field is a dropdown
> box or something (or radio buttons) populated directly with all valid enum
> fields. In case the db later is altered, enum set is modified, all the forms
> should change automatically.
>
> (How) can I retrieve the enum values from the db and use them in a dropdown
> ? Or who has a pointer to the right place where I can find how to do this ?
> Or an example simlar snippet maybe ?
> THANKS!
>
> Pjotr
>
>[/color]

[Andy Hassall]

Re: Populating form item from SQL enum set

On Fri, 29 Oct 2004 18:31:07 +0200, "Pjotr Wedersteers" <pjotr@wederste ers.com>
wrote:
[color=blue]
>I am not even sure if it is at all possible, and I can't find the stuff I am
>looking for, probably using the wrong search keys. WAMP machine (XP,
>2.50.2, 4.1.5, 5.0.2)
>
>I have a field in the MySQL table 'members':
>"membertype " enum ('adult','stude nt','senior','c hild','honour')
>
>Sofar the form used for the db only has text fields, and the data entry user
>relies on IE's autocomplete to always select a valid entry for the field. I
>quick fixed this script so it at least checks the validity.
>
>I'd prefer to have a general solution where the input field is a dropdown
>box or something (or radio buttons) populated directly with all valid enum
>fields. In case the db later is altered, enum set is modified, all the forms
>should change automatically.
>
>(How) can I retrieve the enum values from the db and use them in a dropdown
>? Or who has a pointer to the right place where I can find how to do this ?
>Or an example simlar snippet maybe ?
>THANKS![/color]

http://groups.google.com/groups?selm=cj07rtg0ge7ov3ksjc6pe19u5och3n58t7%404ax.com&oe=ISO-8859-1&output=gplain

--
Andy Hassall / <andy@andyh.co. uk> / <http://www.andyh.co.uk >
<http://www.andyhsoftwa re.co.uk/space> Space: disk usage analysis tool

[Pjotr Wedersteers]

Re: Populating form item from SQL enum set

brommer wrote:[color=blue]
> I've used this once, but it's a bit ugly so here's to hoping a better
> solution comes along :)
>
> <?php
>
> $sql = "SHOW COLUMNS FROM members LIKE 'membertype'";
> $qry = mysql_query($sq l);
> $res = mysql_fetch_obj ect($qry);
> // This returns a row with a field 'Type' containing 'enum(...)'
>
> $res->Type = str_replace('en um', 'array', $res->Type);
>
> eval(" \$memberTypes = $res->Type; ");
>
>
> foreach($member Types as $type) {
> echo "<option...etc. "
> }
>
>[color=green]
>>[/color][/color]
TY, it works, and indeed doesn't look very elegant, but hey, it will do. The
other hint (by andy) has the same principle. I'll dive into the MySQL stuff
another time to see if I can find some more useful stuff on this matter.

again Thanks, both!