質問編集履歴
7
\.
test
CHANGED
File without changes
|
test
CHANGED
@@ -76,7 +76,7 @@
|
|
76
76
|
|
77
77
|
r.ParseForm()
|
78
78
|
|
79
|
-
fmt.Println("
|
79
|
+
fmt.Println("name:", template.HTMLEscapeString(r.Form.Get("name")))
|
80
80
|
|
81
81
|
fmt.Println("cardnum:",template.HTMLEscapeString(r.Form.Get("cardnum")))
|
82
82
|
|
6
へんこう
test
CHANGED
File without changes
|
test
CHANGED
@@ -76,7 +76,7 @@
|
|
76
76
|
|
77
77
|
r.ParseForm()
|
78
78
|
|
79
|
-
fmt.Println("sname:", template.HTMLEscapeString(r.Form.Get("
|
79
|
+
fmt.Println("sname:", template.HTMLEscapeString(r.Form.Get("name")))
|
80
80
|
|
81
81
|
fmt.Println("cardnum:",template.HTMLEscapeString(r.Form.Get("cardnum")))
|
82
82
|
|
5
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -96,7 +96,7 @@
|
|
96
96
|
|
97
97
|
func insert(db *sql.DB) {
|
98
98
|
|
99
|
-
query := "INSERT INTO student values(n
|
99
|
+
query := "INSERT INTO student values(null, ?, ?, ?, ?)"
|
100
100
|
|
101
101
|
result, err := db.Exec(query,"name","cardnum", "seminar", "password")
|
102
102
|
|
4
dbのテーブル定義
test
CHANGED
File without changes
|
test
CHANGED
@@ -46,6 +46,22 @@
|
|
46
46
|
|
47
47
|
|
48
48
|
|
49
|
+
type student struct{
|
50
|
+
|
51
|
+
//id int `db:"id, primarykey, autoincrement"`
|
52
|
+
|
53
|
+
name string `db:"name size:255, uni"`
|
54
|
+
|
55
|
+
cardnum string `db:"cardnum, size:255, unique"`
|
56
|
+
|
57
|
+
seminar string `db:"seminar, size:255"`
|
58
|
+
|
59
|
+
password string `db:"password, size:255, unique"`
|
60
|
+
|
61
|
+
}
|
62
|
+
|
63
|
+
|
64
|
+
|
49
65
|
func login(w http.ResponseWriter, r *http.Request){
|
50
66
|
|
51
67
|
fmt.Println("method:", r.Method)
|
3
文の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -2,7 +2,7 @@
|
|
2
2
|
|
3
3
|
login画面で入力したものをデータベースに保存したい。
|
4
4
|
|
5
|
-
|
5
|
+
db.execのqueryの後の値は保存されますが、formで入力した値が保存されていないので改善したいです。
|
6
6
|
|
7
7
|
###発生している問題・エラーメッセージ
|
8
8
|
|
2
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -104,7 +104,7 @@
|
|
104
104
|
|
105
105
|
|
106
106
|
|
107
|
-
db, err := sql.Open("mysql", "root:pass@/
|
107
|
+
db, err := sql.Open("mysql", "root:passwprd@/dbname")
|
108
108
|
|
109
109
|
if err !=nil{
|
110
110
|
|
1
一つエラーが解消されました、ありがとうございます。
test
CHANGED
File without changes
|
test
CHANGED
@@ -14,8 +14,6 @@
|
|
14
14
|
|
15
15
|
insert error: sql: expected 5 arguments, got 4
|
16
16
|
|
17
|
-
insert error: Error 1062: Duplicate entry 'name' for key 'name'
|
18
|
-
|
19
17
|
```
|
20
18
|
|
21
19
|
|