How to Populate Dropdowns with Enum Values from a MySQL Database?

Populating Dropdowns with Enum Values from a MySQL Database

Populating dropdowns with enum possible values from a MySQL database can be done using functions that interact with the database. One such function is provided below:

function get_enum_values( $table, $field )
{
    $type = fetchRowFromDB( "SHOW COLUMNS FROM {$table} WHERE Field = '{$field}'" )->Type;
    preg_match("/^enum\(\'(.*)\'\)$/", $type, $matches);
    $enum = explode("','", $matches[1]);
    return $enum;
}

This function takes a table and field as parameters and returns an array of possible enum values for that field. It does this by fetching the column type for the specified field and parsing it to extract the enum values.

The fetchRowFromDB function is not shown here, but it is assumed to be a function that fetches a single row from a MySQL database.

The above is the detailed content of How to Populate Dropdowns with Enum Values from a MySQL Database?. For more information, please follow other related articles on the PHP Chinese website!