RE: [PHP-DB] retrieve enum values
If I understand you correctly.. you want to loop through a select statement
and put the enum values in the value of the select box?
If that's the case then here is how you would do that...
select
?php
$query = select * from foo where bar;
$result = mysql_query($query);
While($row = mysql_fetch_row($result)) {
$enumVal = $row[0];
$name= $row[1];
Print option value=\$enumVal\$name/option;
}
?
/select
Hope that speaks to your question.
Jason
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 5:54 AM
To: php-db@lists.php.net
Subject: [PHP-DB] retrieve enum values
Hi!
I have a column type enum in mysql.
At the moment the possible values are 1,2 and 3.
I make a form for my user to modify that value, something like:
select
option value='1'1/option
option value='2'2/option
option value='3'3/option
/select
I may need to add a value 4 to the enum, and in that case I would like to
avoid modifying the code.
I would like to know it it is possible to have something like:
select possible_enum_values from table ...
and then having a loop through these values.
I can't select distinct values in that column because one value may not
exist yet and I don't want to have fake records.
I found that in the mysql doc and was wondering if there is an already
implemented php function intsead of having to parse:
If you want to determine all possible values for an ENUM column, use SHOW
COLUMNS FROM tbl_name LIKE enum_col and parse the ENUM definition in the
second column of the output.
Any idea?
Melanie
_
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] retrieve enum values
Melanie,
Here's a function that will parse the SHOW COLUMNS query output and will
return an array of ENUM values, after you have the array it should be
easy to generate the html code you need.
The first two parameters are self explanatory (the table name and the
column name).
Hope this helps,
define(G_ENUM_COLUMN,4); // set this to 4 if you are using SET column
type, and 4 for ENUM column type.
/*
Return the SET or ENUM set of values.
$p_start can be 3 for SET... or 4 for ENUM...
*/
function get_set_column_values ( $p_table, $p_colname ) {
$result = mysql_query($query);
$arr = mysql_fetch_array(
doQuery( SHOW COLUMNS FROM $p_table LIKE '$p_colname';
)
);
$value = substr( $arr[1], G_ENUM_COLUMN );
eval( \$the_array = array $value; ); // let eval do all the
parsing work.
return $the_array;
}
- Aman Patel, Sys Admin / Database / Web Developer, International
Outreach x4076
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 7:54 AM
To: php-db@lists.php.net
Subject: [PHP-DB] retrieve enum values
Hi!
I have a column type enum in mysql.
At the moment the possible values are 1,2 and 3.
I make a form for my user to modify that value, something
like: select option value='1'1/option option
value='2'2/option option value='3'3/option /select
I may need to add a value 4 to the enum, and in that case I
would like to
avoid modifying the code.
I would like to know it it is possible to have something
like: select possible_enum_values from table ... and then
having a loop through these values. I can't select distinct
values in that column because one value may not
exist yet and I don't want to have fake records.
I found that in the mysql doc and was wondering if there is
an already
implemented php function intsead of having to parse:
If you want to determine all possible values for an ENUM
column, use SHOW
COLUMNS FROM tbl_name LIKE enum_col and parse the ENUM
definition in the
second column of the output.
Any idea?
Melanie
_
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] retrieve enum values
A little correction in the code:
define(G_ENUM_COLUMN,4); // set this to 4 if you are using SET column
type, and 4 for ENUM column type.
/*
Return the SET or ENUM set of values.
$p_start can be 3 for SET... or 4 for ENUM...
*/
function get_set_column_values ( $p_table, $p_colname )
{
$query = SHOW COLUMNS FROM {$p_table} LIKE '{$p_colname}';;
$result = mysql_query($query);
$arr = mysql_fetch_array( $result );
$value = substr( $arr[1], G_ENUM_COLUMN );
eval(\$the_array = array $value;); // let eval do all the parsing
return $the_array;
}
Patel, Aman wrote:
Melanie,
Here's a function that will parse the SHOW COLUMNS query output and will
return an array of ENUM values, after you have the array it should be
easy to generate the html code you need.
The first two parameters are self explanatory (the table name and the
column name).
Hope this helps,
define(G_ENUM_COLUMN,4); // set this to 4 if you are using SET column
type, and 4 for ENUM column type.
/*
Return the SET or ENUM set of values.
$p_start can be 3 for SET... or 4 for ENUM...
*/
function get_set_column_values ( $p_table, $p_colname ) {
$result = mysql_query($query);
$arr = mysql_fetch_array(
doQuery( SHOW COLUMNS FROM $p_table LIKE '$p_colname';
)
);
$value = substr( $arr[1], G_ENUM_COLUMN );
eval( \$the_array = array $value; ); // let eval do all the
parsing work.
return $the_array;
}
- Aman Patel, Sys Admin / Database / Web Developer, International
Outreach x4076
-Original Message-
From: mel list_php [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 7:54 AM
To: php-db@lists.php.net
Subject: [PHP-DB] retrieve enum values
Hi!
I have a column type enum in mysql.
At the moment the possible values are 1,2 and 3.
I make a form for my user to modify that value, something
like: select option value='1'1/option option
value='2'2/option option value='3'3/option /select
I may need to add a value 4 to the enum, and in that case I
would like to
avoid modifying the code.
I would like to know it it is possible to have something
like: select possible_enum_values from table ... and then
having a loop through these values. I can't select distinct
values in that column because one value may not
exist yet and I don't want to have fake records.
I found that in the mysql doc and was wondering if there is
an already
implemented php function intsead of having to parse:
If you want to determine all possible values for an ENUM
column, use SHOW
COLUMNS FROM tbl_name LIKE enum_col and parse the ENUM
definition in the
second column of the output.
Any idea?
Melanie
_
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
