teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問phpからmysqlへInsertできません。（2）

編集履歴

質問編集履歴

6

error.txtの追加

2018/08/16 14:55

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -157,3 +157,19 @@
157
157
  }
158
158
 
159
159
  ```
160
+
161
+ **error.txt**
162
+
163
+ ```PHP
164
+
165
+ テスト1
166
+
167
+ PDOStatement Object
168
+
169
+ (
170
+
171
+ [queryString] => INSERT INTO markets (board_history_id, symbole, pair, last_price, change_rate, high_price, low_price, bid_price, ask_price, volume, btc_volume, trade_count, buy_order_count, sell_order_count, insert_date, insert_datetime) VALUES (NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
172
+
173
+ )
174
+
175
+ ```

5

ファイルを読み込むほうでURLを間違えていたので、少し状況が変わりました。

2018/08/16 14:55

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -86,9 +86,9 @@
86
86
 
87
87
 
88
88
 
89
- //読み込まれているか確認 → 動作しない
89
+ //読み込まれているか確認 → 動作する
90
90
 
91
- file_put_contents(dirname(__FILE__).'/../../log/error.txt', "テスト", FILE_APPEND );
91
+ file_put_contents(dirname(__FILE__).'/../../log/error.txt', "テスト1", FILE_APPEND );
92
92
 
93
93
 
94
94
 
@@ -130,7 +130,7 @@
130
130
 
131
131
 
132
132
 
133
- //INSERTの内容を確認する → 動作しない
133
+ //INSERTの内容を確認する → 動作する
134
134
 
135
135
  file_put_contents(dirname(__FILE__).'/../../log/error.txt', print_r($stmt,TRUE), FILE_APPEND );
136
136
 
@@ -152,7 +152,7 @@
152
152
 
153
153
  //読み込まれているか確認 → 動作しない
154
154
 
155
- file_put_contents(dirname(__FILE__).'/../../log/error.txt', "読み込みテスト", FILE_APPEND );
155
+ file_put_contents(dirname(__FILE__).'/../../log/error.txt', "テスト2", FILE_APPEND );
156
156
 
157
157
  }
158
158
 

4

変更

2018/08/16 13:23

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -157,149 +157,3 @@
157
157
  }
158
158
 
159
159
  ```
160
-
161
-
162
-
163
- **insertMarketのメソッドを読み込んでいるファイル（cronで10分おきに読み込み）**
164
-
165
- ※Cronの動作は確認済み
166
-
167
- ```PHP
168
-
169
- <?php
170
-
171
-
172
-
173
- if ( is_file(dirname(__FILE__).'/../localhost') ) {
174
-
175
- // localhost
176
-
177
- require_once (dirname(__FILE__).'/../default.php');
178
-
179
- require_once (dirname(__FILE__).'/../class/logic/CoinExchangeLogic.class.php');
180
-
181
- require_once (dirname(__FILE__).'/../class/dao/DBLogic.class.php');
182
-
183
- require_once (dirname(__FILE__).'/../class/dao/MarketSummariesDao.class.php');
184
-
185
- } else {
186
-
187
- // production
188
-
189
- require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/default.php');
190
-
191
- require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/logic/CoinExchangeLogic.class.php');
192
-
193
- require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/dao/DBLogic.class.php');
194
-
195
- require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/dao/MarketSummariesDao.class.php');
196
-
197
- }
198
-
199
-
200
-
201
- // requireしているファイルを確認 → うまく動作
202
-
203
- $included_files = get_included_files();
204
-
205
- foreach ($included_files as $filename) {
206
-
207
- file_put_contents(dirname(__FILE__).'/../public_html/tech-fpro.net/ce/log/error.txt', $filename.'\n', FILE_APPEND );
208
-
209
- }
210
-
211
-
212
-
213
- $logic = new CoinExchangeLogic();
214
-
215
-
216
-
217
- $marketsBuff = $logic->getMarkets();
218
-
219
- $markets = array();
220
-
221
- foreach ( $marketsBuff as $m ) {
222
-
223
- $markets[$m['MarketID']] = $m;
224
-
225
- }
226
-
227
- $marketSum = $logic->getMarketSummaries();
228
-
229
- $date = date('Y/m/d H:i:00');
230
-
231
-
232
-
233
- $db = new DBLogic();
234
-
235
- $pdo = $db->getPDO();
236
-
237
-
238
-
239
- //insertMarketが書かれたClass
240
-
241
- $dao = new MarketSummariesDao();
242
-
243
-
244
-
245
- $pdo->beginTransaction();
246
-
247
-
248
-
249
-
250
-
251
- foreach ( $marketSum as $marketId => $summary ) {
252
-
253
-
254
-
255
- if ( isset( $markets[$marketId] ) ) {
256
-
257
-
258
-
259
- $market = $markets[$marketId];
260
-
261
-
262
-
263
- $data = array();
264
-
265
-
266
-
267
- $data[] = $market['MarketAssetCode'];
268
-
269
- $data[] = $market['BaseCurrencyCode'];
270
-
271
- $data[] = $summary['LastPrice'];
272
-
273
- $data[] = $summary['Change'];
274
-
275
- $data[] = $summary['HighPrice'];
276
-
277
- $data[] = $summary['LowPrice'];
278
-
279
- $data[] = $summary['BidPrice'];
280
-
281
- $data[] = $summary['AskPrice'];
282
-
283
- $data[] = date('Y/m/d', strtotime($date));
284
-
285
- $data[] = $date;
286
-
287
-
288
-
289
- //insertMarketメソッドを読み込み → うまくいってない？
290
-
291
- $dao->insertMarket($pdo, $data, $date);
292
-
293
-
294
-
295
- }
296
-
297
- }
298
-
299
-
300
-
301
- // コミット
302
-
303
- $pdo->commit();
304
-
305
- ```

3

読み込んでいるファイルのコードを追加

2018/08/16 12:53

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -10,6 +10,8 @@
10
10
 
11
11
 
12
12
 
13
+ **MarketSummariesDao.class.php**
14
+
13
15
  ```PHP
14
16
 
15
17
  /**
@@ -155,3 +157,149 @@
155
157
  }
156
158
 
157
159
  ```
160
+
161
+
162
+
163
+ **insertMarketのメソッドを読み込んでいるファイル（cronで10分おきに読み込み）**
164
+
165
+ ※Cronの動作は確認済み
166
+
167
+ ```PHP
168
+
169
+ <?php
170
+
171
+
172
+
173
+ if ( is_file(dirname(__FILE__).'/../localhost') ) {
174
+
175
+ // localhost
176
+
177
+ require_once (dirname(__FILE__).'/../default.php');
178
+
179
+ require_once (dirname(__FILE__).'/../class/logic/CoinExchangeLogic.class.php');
180
+
181
+ require_once (dirname(__FILE__).'/../class/dao/DBLogic.class.php');
182
+
183
+ require_once (dirname(__FILE__).'/../class/dao/MarketSummariesDao.class.php');
184
+
185
+ } else {
186
+
187
+ // production
188
+
189
+ require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/default.php');
190
+
191
+ require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/logic/CoinExchangeLogic.class.php');
192
+
193
+ require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/dao/DBLogic.class.php');
194
+
195
+ require_once (dirname(__FILE__).'/../public_html/tech-fpro.net/wp-content/themes/onetone/ce/class/dao/MarketSummariesDao.class.php');
196
+
197
+ }
198
+
199
+
200
+
201
+ // requireしているファイルを確認 → うまく動作
202
+
203
+ $included_files = get_included_files();
204
+
205
+ foreach ($included_files as $filename) {
206
+
207
+ file_put_contents(dirname(__FILE__).'/../public_html/tech-fpro.net/ce/log/error.txt', $filename.'\n', FILE_APPEND );
208
+
209
+ }
210
+
211
+
212
+
213
+ $logic = new CoinExchangeLogic();
214
+
215
+
216
+
217
+ $marketsBuff = $logic->getMarkets();
218
+
219
+ $markets = array();
220
+
221
+ foreach ( $marketsBuff as $m ) {
222
+
223
+ $markets[$m['MarketID']] = $m;
224
+
225
+ }
226
+
227
+ $marketSum = $logic->getMarketSummaries();
228
+
229
+ $date = date('Y/m/d H:i:00');
230
+
231
+
232
+
233
+ $db = new DBLogic();
234
+
235
+ $pdo = $db->getPDO();
236
+
237
+
238
+
239
+ //insertMarketが書かれたClass
240
+
241
+ $dao = new MarketSummariesDao();
242
+
243
+
244
+
245
+ $pdo->beginTransaction();
246
+
247
+
248
+
249
+
250
+
251
+ foreach ( $marketSum as $marketId => $summary ) {
252
+
253
+
254
+
255
+ if ( isset( $markets[$marketId] ) ) {
256
+
257
+
258
+
259
+ $market = $markets[$marketId];
260
+
261
+
262
+
263
+ $data = array();
264
+
265
+
266
+
267
+ $data[] = $market['MarketAssetCode'];
268
+
269
+ $data[] = $market['BaseCurrencyCode'];
270
+
271
+ $data[] = $summary['LastPrice'];
272
+
273
+ $data[] = $summary['Change'];
274
+
275
+ $data[] = $summary['HighPrice'];
276
+
277
+ $data[] = $summary['LowPrice'];
278
+
279
+ $data[] = $summary['BidPrice'];
280
+
281
+ $data[] = $summary['AskPrice'];
282
+
283
+ $data[] = date('Y/m/d', strtotime($date));
284
+
285
+ $data[] = $date;
286
+
287
+
288
+
289
+ //insertMarketメソッドを読み込み → うまくいってない？
290
+
291
+ $dao->insertMarket($pdo, $data, $date);
292
+
293
+
294
+
295
+ }
296
+
297
+ }
298
+
299
+
300
+
301
+ // コミット
302
+
303
+ $pdo->commit();
304
+
305
+ ```

2

ファイルの読み込み確認（先頭）

2018/08/16 12:49

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -82,6 +82,14 @@
82
82
 
83
83
  public function insertMarket($pdo, $data, $date) {
84
84
 
85
+
86
+
87
+ //読み込まれているか確認 → 動作しない
88
+
89
+ file_put_contents(dirname(__FILE__).'/../../log/error.txt', "テスト", FILE_APPEND );
90
+
91
+
92
+
85
93
  $fields = $this->_getFields();
86
94
 
87
95
 

1

try文外でのファイル書き込み確認

2018/08/16 12:23

投稿

Tcandy
Tcandy

スコア12

test CHANGED
File without changes
test CHANGED
@@ -138,6 +138,12 @@
138
138
 
139
139
  }
140
140
 
141
+
142
+
143
+ //読み込まれているか確認 → 動作しない
144
+
145
+ file_put_contents(dirname(__FILE__).'/../../log/error.txt', "読み込みテスト", FILE_APPEND );
146
+
141
147
  }
142
148
 
143
149
  ```