-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathdata_import.php
More file actions
58 lines (49 loc) · 1.35 KB
/
data_import.php
File metadata and controls
58 lines (49 loc) · 1.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php
include_once("login_session.php");
if (($handle = fopen(dir_path() . "/data/games_export_1.csv", "r")) !== FALSE) {
$game_arr = array();
// echo '10';
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
$game_name = $data[0];
$game_url = $data[1];
$game_detail = $data[2];
// $card_nb = array();
$card_total = 0;
// $sleeve_size = array();
$sleeve_arr = array();
echo $data[0] . '<br>';
echo $data[1] . '<br>';
// echo $data[2] . '<br>';
$game_data = explode("\n", $game_detail);
foreach($game_data as &$row) {
if(strpos($row, "Number of cards:") !== false) {
echo $row . '<br>';
$card_total = $row;
// array_push($card_nb, $row);
}
elseif(strpos($row, " sleeve size:") !== false) {
$sleeve_detail = array(
'card_total' => $card_total,
'sleeve_brand' => $row,
'sleeve_size' => $row
);
echo $row . '<br>';
array_push($sleeve_arr, $sleeve_detail);
}
elseif(strpos($row, "Expansion") !== false || strpos($row, "----") !== false) {
break;
}
}
$game_arr[] = array(
'game_name' => $game_name,
'game_url' => $game_url,
// 'card_nb' => $card_nb,
'sleeves' => $sleeve_arr,
);
$json_data = json_encode($game_arr);
}
fclose($handle);
$json_data = json_encode($game_arr);
file_put_contents(dir_path() . "/data/new.json",$json_data);
}
?>