Zend Mysql获取ENUM值 [英] Zend Mysql get ENUM values

问题描述

我在应用程序中使用Zend Framework.我想知道如何从MySQL表的ENUM字段中获取值.例如:我有permissions字段(ENUM('delete_admin'，'edit_admin')).如何以最好的方式获取array('delete_admin'，'edit_admin')?
谢谢.

I use Zend Framework in my application. And I want to know how to get values from ENUM field in MySQL table.
For example: i have permissions field (ENUM('delete_admin', 'edit_admin')). How to get array('delete_admin', 'edit_admin') in he best way?
Thank you in advance.

推荐答案

这是我的方法:

在您的模型中放入

function getInfoTabella()
    {
        $data = $this->info(self::METADATA);
        return $data;
    }

然后使用此:

$model = new $model_name();
        $description = $model->getInfoTabella();
        $enum = $description[$FIELD_NAME]['DATA_TYPE'];

        $inizia_enum = strpos($enum, "'");
        $finisce_enum = strrpos($enum, "'");
        if ($inizia_enum === false || $finisce_enum  === false)
            throw new Exception('errore enum database');

        $finisce_enum -= $inizia_enum ;


        $enum = substr($enum, $inizia_enum, $finisce_enum+1);
        str_replace("'", '', $enum);
        $enum = explode("," , $enum);
return $enum;

这篇关于Zend Mysql获取ENUM值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！