/
get.php
85 lines (57 loc) · 2.43 KB
/
get.php
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<?php
require 'db.php';
class Get {
public function getEnvironment() {
$db = new db();
$connection = $db->connection();
mysql_select_db($db::DBNAME);
$sqlGetProjects = "SELECT id, name, domain, user_email FROM envs_project WHERE removed=0";
$queryGetProjects = mysql_query($sqlGetProjects, $connection);
$arrayGetProjects = array();
while ($row = mysql_fetch_array($queryGetProjects, MYSQL_ASSOC)) {
$arrayGetProjects[] = $row;
}
return json_encode(array("elements" => $arrayGetProjects));
}
public function getSubEnvironment() {
$db = new db();
$connection = $db->connection();
mysql_select_db($db::DBNAME);
$sqlGetSubProjects = "SELECT id, name, domain FROM envs_environments WHERE for_remove=0";
$queryGetSubProjects = mysql_query($sqlGetSubProjects, $connection);
$arrayGetSubProjects = array();
while ($row = mysql_fetch_array($queryGetSubProjects, MYSQL_ASSOC)) {
$arrayGetSubProjects[] = $row;
}
return json_encode(array("subelements" => $arrayGetSubProjects));
}
public function removeEnvironment($removeId) {
$db = new db();
$connection = $db->connection();
mysql_select_db($db::DBNAME);
$sqlUpdateEnvs = "UPDATE envs_environments SET for_remove=1 WHERE project_id=" . $removeId . ";";
$queryUpdateEnvs = mysql_query($sqlUpdateEnvs, $connection);
if(!$queryUpdateEnvs) {
return json_encode(array('error' => die('Could not enter data: ' . mysql_error())));
}
/*
$sqlSelectEnvs = "SELECT name, path, dbname FROM envs_environments WHERE project_id=" . $removeId . ";";
$querySelectEnvs = mysql_query($sqlSelectEnvs, $connection);
$arraySelectEnvs = array();
while ($envsRow = mysql_fetch_array($querySelectEnvs, MYSQLI_ASSOC)) {
//$arraySelectEnvs[] = ('name' => $envsRow['name'], 'path' => $envsRow['path'], 'dbname' => $envsRow['dbname']);
$arraySelectEnvs[] = $envsRow;
}
print_r($arraySelectEnvs);
*/
//return json_encode(array('return' => $arraySelectEnvs ));
/*
$sqlRemoveProject = "DELETE FROM envs_project WHERE id=" . $removeId . ";";
$queryRemoveProject = mysql_query($sqlRemoveProject, $connection);
if(!$queryRemoveProject) {
return json_encode(array('error' => die('Could not enter data: ' . mysql_error())));
}
*/
}
}
?>