public function indexAction() { //validation from $v = new Lib_FormValidation($this->validation); $res = $v->validate('form1'); if (FALSE === $res) { $e = $v->errors(); var_dump($e); Logging::logMessage('error, validation forom error, detail see other.', Logging::LEVEL_ERROR); exit('用户名不能为空,密码不能是全数字或全字母'); } $params = $v->params(); $name = $params['name']; $passwd = $params['passwd']; $where['name'] = $name; $where['password'] = $passwd; Logging::logMessage('The sing name:' . $name . ', password :' . $passwd); $res = F::$f->Model_User->selectOne($where); var_dump($res); }
protected function _getDbInstance($is_read = TRUE) { $db_choose_name = $this->_db_master_name; //main if (Model_Db::$_forceReadOnMaster || $this->_readOnMaster) { $is_read = FAlSE; } if ($is_read) { $db_choose_name = $this->_db_read_name; //query } if (isset($this->_db_instance[$db_choose_name]) && is_object($this->_db_instance[$db_choose_name])) { return $this->_db_instance[$db_choose_name]; } //获得一个db if (empty($this->_db_zone_name)) { return NULL; } $db_config = Config::get('DB_CONFIG'); if (!isset($db_config[$this->_db_zone_name][$db_choose_name])) { return NULL; } $db_config = $db_config[$this->_db_zone_name][$db_choose_name]; if ($db_choose_name == $this->_db_read_name) { $query_count = count($db_config); if ($query_count > 1) { $i = mt_rand(0, count($db_config) - 1); $db_config = $db_config[$i]; } else { $db_config = $db_config[0]; } } $dsn = "mysql:host={$db_config['host']};dbname={$db_config['database']};"; if (isset($db_config['charset'])) { $dsn .= "charset={$db_config['charset']}"; } $options = array(); if (version_compare(PHP_VERSION, '5.3.6', '<')) { $options[PDO::MYSQL_ATTR_INIT_COMMAND] = "set names {$db_config['charset']}"; } $db = FALSE; try { $db = new PDO($dsn, $db_config['user'], $db_config['password'], $options); } catch (Exception $e) { $db = FALSE; } if (!empty($db)) { $this->_db_instance[$db_choose_name] = $db; return $db; } else { Logging::logMessage('DB_ERROR new PDO error! dsn:' . $dsn, Logging::LEVEL_FATAL); return FALSE; } }
/** * 记录log,默认级别是info, 可以配置文件配置,sys_id默认'-',可全局配置 */ function log_message($log_msg, $level = NULL, $sys_id = NULL) { return Logging::logMessage($log_msg, $level, $sys_id); }
protected function _getDbInstance($is_read = TRUE) { $db_choose_name = $this->_db_master_name; /* if (Model_Db::$_forceReadOnMaster || $this->_readOnMaster) { $is_read = FAlSE; } */ if ($is_read) { $db_choose_name = $this->_db_read_name; } if (isset($this->_db_instance[$db_choose_name]) && is_object($this->_db_instance[$db_choose_name])) { return $this->_db_instance[$db_choose_name]; } //获得一个db if (empty($this->_db_zone_name)) { return NULL; } $db_config = Config::get('DB_CONFIG'); if (!isset($db_config[$this->_db_zone_name][$db_choose_name])) { return NULL; } $db_config = $db_config[$this->_db_zone_name][$db_choose_name]; if ($db_choose_name == $this->_db_read_name) { $query_count = count($db_config); if ($query_count > 1) { $i = mt_rand(0, count($db_config) - 1); $db_config = $db_config[$i]; } else { $db_config = $db_config[0]; } } $dsn = "pgsql:host={$db_config['host']};dbname={$db_config['database']};port={$db_config['port']};"; $options = array(); $db = FALSE; try { $db = new PDO($dsn, $db_config['user'], $db_config['password'], $options); } catch (Exception $e) { $db = FALSE; } if (!empty($db)) { $this->_db_instance[$db_choose_name] = $db; return $db; } else { Logging::logMessage('DB_ERROR new PDO error! dsn:' . $dsn, Logging::LEVEL_FATAL); return FALSE; } }