connect_mysql.go

func connectionString() string {
	conn := fmt.Sprintf("%s:%s@(%s:3306)/%s?charset=utf8", config["db_user"], config["db_pass"], config["db_host"], config["db_name"])
	return conn
}

func authenticateUser(username string, password string) string {

	db, err := sql.Open("mysql", fmt.Sprintf("%s", connectionString()))
	checkError(err)

	query, err := db.Prepare("SELECT usergroup FROM users WHERE name =? AND password =?")
	checkError(err)

	var groupname string
	err = query.QueryRow(username, password).Scan(&groupname)
	if err != nil || groupname == "" {
		return "failed"
	}
	return groupname

}