質問編集履歴

2

API側のコードを追記

2017/11/15 08:42

投稿

Yashichi
Yashichi

スコア35

test CHANGED
File without changes
test CHANGED
@@ -66,6 +66,8 @@
66
66
 
67
67
  ###該当のソースコード
68
68
 
69
+ 表画面
70
+
69
71
  ```JavaScript
70
72
 
71
73
  // 編集したいところをダブルクリックしたらイベント発動
@@ -140,6 +142,64 @@
140
142
 
141
143
  ```
142
144
 
145
+ API側(read.php)
146
+
147
+ ```PHP
148
+
149
+ <?php
150
+
151
+ // header関数より前にechoなどを使ってはいけない
152
+
153
+ header('content-type: application/json; charset=utf-8');
154
+
155
+ // データベースに接続
156
+
157
+ $dsn = 'mysql:host=localhost;dbname=todolist;charset=utf8';
158
+
159
+ $user = 'secret';
160
+
161
+ $passwd = 'secret';
162
+
163
+
164
+
165
+ try {
166
+
167
+ $db = new PDO($dsn, $user, $passwd);
168
+
169
+ $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
170
+
171
+
172
+
173
+ // プリペアドステートメント発行(最新の10件を取得)
174
+
175
+ $statement = $db->prepare("
176
+
177
+ SELECT * FROM list ORDER BY id DESC LIMIT 10;
178
+
179
+ ");
180
+
181
+ // print_r($db->errorInfo());
182
+
183
+
184
+
185
+ $statement->execute();
186
+
187
+ $rows = $statement->fetchAll();
188
+
189
+ // var_dump($rows);
190
+
191
+ echo json_encode(compact('rows'));
192
+
193
+
194
+
195
+ } catch (PDOException $e) {
196
+
197
+ echo "Error :" . $e->getMessage();
198
+
199
+ }
200
+
201
+ ```
202
+
143
203
 
144
204
 
145
205
  ###試したこと

1

console.logの結果の追記

2017/11/15 08:41

投稿

Yashichi
Yashichi

スコア35

test CHANGED
File without changes
test CHANGED
@@ -1,3 +1,43 @@
1
+ ###追記
2
+
3
+ `console.log(response);`の値を追記しておきます。
4
+
5
+ ```
6
+
7
+ {rows: Array(10)}
8
+
9
+ rows:Array(10)
10
+
11
+ 0:{0: "217", 1: "test", 2: "rest", 3: null, 4: null, id: "217", title: "test", content: "rest", complement: null, deadline: null}
12
+
13
+ 1:{0: "216", 1: "", 2: "", 3: null, 4: null, id: "216", title: "", content: "", complement: null, deadline: null}
14
+
15
+ 2:{0: "215", 1: "", 2: "", 3: null, 4: null, id: "215", title: "", content: "", complement: null, deadline: null}
16
+
17
+ 3:{0: "214", 1: "sentence", 2: "root", 3: null, 4: null, id: "214", title: "sentence", content: "root", complement: null, deadline: null}
18
+
19
+ 4:{0: "213", 1: "clear", 2: "content", 3: null, 4: null, id: "213", title: "clear", content: "content", complement: null, deadline: null}
20
+
21
+ 5:{0: "212", 1: "", 2: "", 3: null, 4: null, id: "212", title: "", content: "", complement: null, deadline: null}
22
+
23
+ 6:{0: "211", 1: "", 2: "", 3: null, 4: null, id: "211", title: "", content: "", complement: null, deadline: null}
24
+
25
+ 7:{0: "210", 1: "", 2: "", 3: null, 4: null, id: "210", title: "", content: "", complement: null, deadline: null}
26
+
27
+ 8:{0: "209", 1: "", 2: "", 3: null, 4: null, id: "209", title: "", content: "", complement: null, deadline: null}
28
+
29
+ 9:{0: "208", 1: "", 2: "", 3: null, 4: null, id: "208", title: "", content: "", complement: null, deadline: null}
30
+
31
+ length:10
32
+
33
+ __proto__:Array(0)
34
+
35
+ __proto__:Object
36
+
37
+ ```
38
+
39
+
40
+
1
41
  ###前提・実現したいこと
2
42
 
3
43
  PHPとjQueryを利用してAjaxでのToDoリストを作成しています。