DATA_MIGRATION/SQL/SQLtoJSON/SQLtoJSON_PHP.php at master · ParfaitG/DATA_MIGRATION · GitHub

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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>
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
<?php

$cd = dirname(__FILE__);

try {
// CONNECT TO DATABASE
$dbh = newPDO("sqlite:".$cd."/CLData.db");
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// QUERY DATABASE
$sql = "SELECT * FROM cldata";
$sth = $dbh->query($sql);
$sth->setFetchMode(PDO::FETCH_ASSOC);
$data = $sth->fetchAll();
}
catch(PDOException$e) {
echo$e->getMessage();
}

// WRITE JSON
$json = json_encode($data, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);
file_put_contents($cd."/CLData_PHP.json", $json);

// CLOSE DATABASE
$dbh = null;

echo"Successfully migrated SQL data to JSON!\n";

?>