質問編集履歴
2
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -38,7 +38,7 @@
|
|
|
38
38
|
|
|
39
39
|
try{
|
|
40
40
|
|
|
41
|
-
$sql = "UPDATE table SET status = :stat WHERE tdname = :td";
|
|
41
|
+
$sql = "UPDATE tableA SET status = :stat WHERE tdname = :td";
|
|
42
42
|
|
|
43
43
|
$stmt =$pdo->query($sql);
|
|
44
44
|
|
1
追記しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -69,3 +69,15 @@
|
|
|
69
69
|
}
|
|
70
70
|
|
|
71
71
|
```
|
|
72
|
+
|
|
73
|
+
|
|
74
|
+
|
|
75
|
+
<追記>
|
|
76
|
+
|
|
77
|
+
tableは予約語とのご指摘を受けて、tableAに変更したのですが、
|
|
78
|
+
|
|
79
|
+
以下の通り、エラーが引き続き出力されております。
|
|
80
|
+
|
|
81
|
+
|
|
82
|
+
|
|
83
|
+
データベース接続失敗。SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':stat WHERE tdname = :td' at line 1
|