質問編集履歴
2
API側のコードを追記
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の結果の追記
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リストを作成しています。
|