質問編集履歴
2
コード部の変更
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -100,13 +100,13 @@
|
|
|
100
100
|
|
|
101
101
|
if ($genre == "all") { // ジャンル指定なし
|
|
102
102
|
|
|
103
|
-
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE title LIKE '%{$yourname}%'
|
|
103
|
+
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE title LIKE '%{$yourname}%'" );
|
|
104
104
|
|
|
105
105
|
} else { // ジャンル指定あり
|
|
106
106
|
|
|
107
107
|
// プレースホルダへ実際の値を設定する
|
|
108
108
|
|
|
109
|
-
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE genre2 LIKE '%{$genre}%' AND title LIKE '%{$yourname}%'
|
|
109
|
+
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE genre2 LIKE '%{$genre}%' AND title LIKE '%{$yourname}%'" );
|
|
110
110
|
|
|
111
111
|
}
|
|
112
112
|
|
|
@@ -140,11 +140,11 @@
|
|
|
140
140
|
|
|
141
141
|
if ($genre == 'all') { // ジャンル指定なし
|
|
142
142
|
|
|
143
|
-
$sql = $dbh->prepare ( "SELECT * FROM movies
|
|
143
|
+
$sql = $dbh->prepare ( "SELECT * FROM movies" );
|
|
144
144
|
|
|
145
145
|
} else { // ジャンル指定あり
|
|
146
146
|
|
|
147
|
-
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE genre2 LIKE '%{$genre}%'
|
|
147
|
+
$sql = $dbh->prepare ( "SELECT * FROM movies WHERE genre2 LIKE '%{$genre}%'" );
|
|
148
148
|
|
|
149
149
|
}
|
|
150
150
|
|
1
コード部の修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -8,6 +8,8 @@
|
|
|
8
8
|
|
|
9
9
|
###該当のソースコード
|
|
10
10
|
|
|
11
|
+
```ここに言語を入力
|
|
12
|
+
|
|
11
13
|
<?php
|
|
12
14
|
|
|
13
15
|
session_start ();
|
|
@@ -382,6 +384,8 @@
|
|
|
382
384
|
|
|
383
385
|
</html>
|
|
384
386
|
|
|
387
|
+
```
|
|
388
|
+
|
|
385
389
|
|
|
386
390
|
|
|
387
391
|
###試したこと
|