質問編集履歴

4

2017/01/18 05:07

投稿

RyotaOgiyama
RyotaOgiyama

スコア12

test CHANGED
File without changes
test CHANGED
@@ -48,7 +48,9 @@
48
48
 
49
49
  success: function(data, dataType){
50
50
 
51
- console.log(data);
51
+ data = eval(data);
52
+
53
+ $('#img').css('background-image','url('+data[0].img+')');
52
54
 
53
55
  }
54
56
 

3

;

2017/01/18 05:07

投稿

RyotaOgiyama
RyotaOgiyama

スコア12

test CHANGED
File without changes
test CHANGED
@@ -18,7 +18,7 @@
18
18
 
19
19
  ```php
20
20
 
21
- $query = "SELECT id,img FROM table WHERE id=$id"
21
+ $query = "SELECT id,img FROM table WHERE id=$id";
22
22
 
23
23
  $stmt = $pdo->prepare($query);
24
24
 

2

a

2017/01/18 04:41

投稿

RyotaOgiyama
RyotaOgiyama

スコア12

test CHANGED
File without changes
test CHANGED
@@ -16,10 +16,42 @@
16
16
 
17
17
 
18
18
 
19
- セレクト文は以下になってます
20
-
21
19
  ```php
22
20
 
23
- SELECT id,img FROM table WHERE id=$id
21
+ $query = "SELECT id,img FROM table WHERE id=$id"
22
+
23
+ $stmt = $pdo->prepare($query);
24
+
25
+ $stmt->execute();
26
+
27
+ $rows = array();
28
+
29
+ while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
30
+
31
+ $rows[] = $row;
32
+
33
+ }
34
+
35
+ echo (json_encode($rows));
24
36
 
25
37
  ```
38
+
39
+ ```javascript
40
+
41
+ $.ajax({
42
+
43
+ type: "POST",
44
+
45
+ url: "***.php",
46
+
47
+ data: data,
48
+
49
+ success: function(data, dataType){
50
+
51
+ console.log(data);
52
+
53
+ }
54
+
55
+ });
56
+
57
+ ```

1

select文の挿入

2017/01/18 04:38

投稿

RyotaOgiyama
RyotaOgiyama

スコア12

test CHANGED
File without changes
test CHANGED
@@ -11,3 +11,15 @@
11
11
 
12
12
 
13
13
  それを解決する方法が思いつかないのですが何か方法はあるのでしょうか?
14
+
15
+
16
+
17
+
18
+
19
+ セレクト文は以下になってます
20
+
21
+ ```php
22
+
23
+ SELECT id,img FROM table WHERE id=$id
24
+
25
+ ```