英文:
Error submitting a hash to sqlite db golang
问题
尝试将表单中的哈希值发送到SQLite数据库
func Signup(r http.ResponseWriter, w *http.Request) {w.ParseForm()email := w.Form.Get("Email")if !govalidator.IsEmail(email) {utils.ServerResponse("email is incorrect", "frontend/index.html", r)return}password := w.Form.Get("Password")hash, err := bcrypt.GenerateFromPassword([]byte("Password"), bcrypt.DefaultCost)if password == "" || len(password) < 6 {utils.ServerResponse("Password length must be longer than 6 letters and must contain numbers and uppercase letters", "frontend/index.html", r)return}query := fmt.Sprintf("INSERT INTO User (email, password) VALUES ('%s', '%s')", email, string(hash))fmt.Println(query, string(hash)) // 用于调试的打印语句statement , err := db.SqliteDatabase.Prepare(query)
终端输出并且没有提交到数据库：
INSERT INTO User (email, password)VALUES ("email" , "hash")%!(EXTRA string=test@example.com, string=21818921) $2a$10$S5DObh/Kwbnl1JMvb.Xzf.Vo9SJsOMDaFugWstf/1xGCPTnZBxr3ynear "%": 语法错误
英文:
Trying to send a hash from a form to an sqlite database
func Signup(r http.ResponseWriter, w *http.Request) {w.ParseForm()email := w.Form.Get("Email")if !govalidator.IsEmail(email) {utils.ServerResponse("email is incorrect", "frontend/index.html", r)return}password := w.Form.Get("Password")hash, err := bcrypt.GenerateFromPassword([]byte("Password"), bcrypt.DefaultCost)if password == "" || len(password) < 6 {utils.ServerResponse("Password length must be longer than 6 letters and must contain numbers and uppercase letters", "frontend/index.html", r)return}query := fmt.Sprintf("INSERT INTO User (email, password)", VALUES "email", "hash")fmt.Println(query, string(hash)) // put this here for debuggingstatement , err := db.SqliteDatabase.Prepare(query)
Output in the terminal and nothing submits to the database:
INSERT INTO User (email, password)VALUES ("email" , "hash")%!(EXTRA string=test@example.com, string=21818921) $2a$10$S5DObh/Kwbnl1JMvb.Xzf.Vo9SJsOMDaFugWstf/1xGCPTnZBxr3ynear "%": syntax error
答案1
得分: 1
发现我在使用fmt.Sprintf函数时出现了错误，并进行了修复。
query := fmt.Sprintf(`INSERT INTO User (email, password)VALUES ("%s" , "%s")`, email, hash)
英文:
Discovered i was using the fmt.Sprinf function incorrectly and fixed it.
query := fmt.Sprintf(`INSERT INTO User (email, password)VALUES ("%s" , "%s")`, email, hash)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论