function __construct($host, $username, $password, $db) { $conn_para = "mysql:{$host};{$db};charset=utf8"; $opt = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC); $this->_pdo = new PDO($conn_para, $username, $password, $opt) or die('There is problem in connecting to database'); $this->_pdo->exec("USE " . $db); self::$_instance = $this; }
/** * 获取平均值 * * @param array $param 查询条件 * @param string $field 查询字段 * @return array 数据结果集 */ public static function get_average($param, $field) { PDO_DB::build_where($param, $where_sql, $bind); $sql = "SELECT AVG({$field}) AS {$field} FROM rd_interview_result"; if ($where_sql) { $sql .= " WHERE {$where_sql}"; } return Fn::db()->fetchRow($sql, $bind); }
public static function get_v_schools($where = array()) { $sql = "SELECT * FROM v_school"; PDO_DB::build_where($where, $where_sql, $bind); if ($where_sql) { $sql .= " WHERE {$where_sql}"; } $rows = Fn::db()->fetchAll($sql, $bind); return $rows; }
/** * 获取所有评分项 * * @param array $params 查询条件 * @param string $fields 需要查询的字段,默认为 * * @return array 成功返回结果数组,失败返回空数组 */ public static function get_options_all($params, $fields = '*') { $sql = <<<EOT SELECT {$fields} FROM rd_evaluation_option EOT; PDO_DB::build_where($params, $where_sql, $bind); if ($where_sql) { $sql .= ' WHERE ' . $where_sql; } return Fn::db()->fetchAll($sql, $bind); }
/** * 获取平均值 * * @param array $param 查询条件 * @param string $field 查询字段 * @return array 数据结果集 */ public static function get_average($param, $field) { PDO_DB::build_where($param, $where_sql, $bind); $sql = <<<EOT SELECT AVG({$field}) AS {$field} FROM rd_ruidabei_result EOT; if ($where_sql) { $sql .= " WHERE " . $where_sql; } return Fn::db()->fetchRow($sql, $bind); }
/** * 获取试卷数量 * * @param array $param 查询条件 * @return mixed 指定单个字段则返回该字段值,否则返回关联数组 */ public static function count_papers($param) { PDO_DB::build_where($param, $where_sql, $bind); $sql = <<<EOT SELECT COUNT(*) FROM rd_exam_paper EOT; if ($where_sql) { $sql .= ' WHERE ' . $where_sql; } return Fn::db()->fetchOne($sql, $bind); }
/** * 获取多条 * * @param array $params 查询条件 * @param string $fields 需要查询的字段,默认为 * * @param int $limit 查询的条数,默认为 15 * @return array 成功返回结果数组,失败返回空数组 */ public static function get_multiterm($params, $fields = '*', $limit = 15) { $sql = <<<EOT SELECT {$fields} FROM rd_evaluation_standard EOT; PDO_DB::build_where($params, $where_sql, $bind); if ($where_sql) { $sql .= ' WHERE ' . $where_sql; } $sql .= ' ORDER BY id DESC'; if (is_string($limit)) { $args = explode(',', $limit); $sql .= ' LIMIT ' . $args[1] . ' OFFSET ' . $args[0]; } else { $sql .= ' LIMIT ' . $limit; } return Fn::db()->fetchAll($sql, $bind); }
/** * 更新考试信息 * array $data * mixed $where * return boolean */ public static function update($data, $where) { PDO_DB::build_where($where, $where_sql, $bind); return Fn::db()->update('rd_exam', $data, $where_sql, $bind) > 0; }