回答編集履歴
2
見直し
test
CHANGED
|
@@ -46,7 +46,7 @@
|
|
|
46
46
|
|
|
47
47
|
$stmt = $pdo->prepare("SELECT * FROM vtw100n WHERE `vn05str` = :iclass ORDER BY `vn02str`,`vn03str`");
|
|
48
48
|
|
|
49
|
-
$stmt->bindValue(':iclass', $iclass, PDO
|
|
49
|
+
$stmt->bindValue(':iclass', $iclass, PDO::PARAM_STR);
|
|
50
50
|
|
|
51
51
|
$stmt->execute();
|
|
52
52
|
|
1
見直し
test
CHANGED
|
@@ -46,7 +46,9 @@
|
|
|
46
46
|
|
|
47
47
|
$stmt = $pdo->prepare("SELECT * FROM vtw100n WHERE `vn05str` = :iclass ORDER BY `vn02str`,`vn03str`");
|
|
48
48
|
|
|
49
|
+
$stmt->bindValue(':iclass', $iclass, PDO_PARAM_STR);
|
|
50
|
+
|
|
49
|
-
$stmt->execute(
|
|
51
|
+
$stmt->execute();
|
|
50
52
|
|
|
51
53
|
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE);
|
|
52
54
|
|
|
@@ -56,7 +58,7 @@
|
|
|
56
58
|
|
|
57
59
|
|
|
58
60
|
|
|
59
|
-
とか書いたらどうだろう？ 知らんけど。
|
|
61
|
+
とか書いたらどうだろう？ 知らんけど。あくまで机上のコードだし、MySQL専門外なので。
|
|
60
62
|
|
|
61
63
|
|
|
62
64
|
|