Skip to content

Instantly share code, notes, and snippets.

@guylaor
Created April 13, 2017 00:43
Show Gist options
  • Save guylaor/eaf03c33aa5c2a9cb7f57527d6f41e28 to your computer and use it in GitHub Desktop.
Save guylaor/eaf03c33aa5c2a9cb7f57527d6f41e28 to your computer and use it in GitHub Desktop.
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
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment