Zend之多数据库配置使用

2 篇文章 0 订阅
resources.dbcms3.adapter                                            = "pdo_mysql"
resources.dbcms3.params.adapterNamespace                            = "Cms_Db_Adapter"
resources.dbcms3.params.host                                        = "16.245.321.481"
resources.dbcms3.params.port                                        = "3306"
resources.dbcms3.params.username                                    = "ee"
resources.dbcms3.params.password                                    = "ee"
resources.dbcms3.params.dbname                                      = "ee"
resources.dbcms3.params.profiler                                    = false
resources.dbcms3.params.charset                                     = UTF8
resources.dbcms3.params.driver_options.1002                         = "SET NAMES UTF8;"

//此处的数据库连接是为了获取551的计划等级预测等级
    public function getdb()
    {
        if (EMAIL_ENV == 1) {
            $config = new Zend_Config_Ini(APPLICATION_PATH . '/Config/Applicavtion.ini', 'production');
        } elseif (EMAIL_ENV == 0) {
            $config = new Zend_Config_Ini(APPLICATION_PATH . '/Config/Applicfation.dev.ini', 'production');

        }
        $params = $config->resources->dbcms3->params;
        $db = Zend_Db::factory('PDO_MYSQL', $params);

        return $db;
    }

    public function getPlfanGradeInfo($data, $row)
    {
        $commodity_supplier_code = $data['product_code'];
        $sql = "SELECT aa,bbFROM vv
                WHERE rr='{$commodity_supplier_code}' order by update_time desc limit 1;";
        $data = $this->getdb()->fetchRow($sql);

        return $data;
    }

    public function getForfeGradeIfnfo($data, $row)
    {
        $commodity_supplier_code = $data['product_code'];
        $sql = "SELECT aa,bb FROM vv
                WHERE rr='{$ee}' order by update_time desc limit 1;";
        $data = $this->getdb()->fetchRow($sql);
        return $data;
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值