webConvertr/tplButton.php at main · nord07/webConvertr · 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
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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?php
    include "connection.php";

    //В перменную записывается название кнопки которую нажали
    $Button = $_POST['button'];

//Если нажали кнопку Принять запрос
    if($Button == "Принять запрос") {
        $optionActive = $_POST['querydb'];
        $sql = "SELECT * FROM `querytupl` where NameQuery = '$optionActive'";
        $result = mysqli_query($conn, $sql);
        $result_query = mysqli_fetch_assoc($result);
        echo json_encode($result_query);
    }

//Если нажали кнопку Сохранить запрос
    if($Button == "Сохранить запрос"){
        $nq = $_POST['nq'];
        $g = $_POST['group'];
        $ln = $_POST['lastname'];
        $tv = $_POST['typevar'];
        $tl = $_POST['targetlist'];
        $qb = $_POST['algquery'];
        $dq = $_POST['descquery'];

        $nameQuery = $nq . "_" . $g . "_" . $ln;

        $sql = "INSERT INTO querytupl (`NameQuery`, `TableVar`, `GoalList`, `QueryBody`, `DescQuery`) VALUES ('"
            . $nameQuery ."', '"
            . $tv ."', '"
            . $tl ."', '"
            . $qb ."', '"
            . $dq . "')";
            $result_query = mysqli_query($conn, $sql);
    }

//Если нажали кнопку Изменить запрос
    if($Button == "Изменить запрос"){
        $nq = $_POST['nq'];
        $g = $_POST['group'];
        $ln = $_POST['lastname'];

        $nameQuery = $nq . "_" . $g . "_" . $ln;

        $sql = "UPDATE querytupl SET
        TableVar = '" . $_POST['typevar'] . "',
        GoalList = '" . $_POST['targetlist'] . "',
        QueryBody = '" . $_POST['algquery'] ."',
        DescQuery = '" . $_POST['descquery'] . "'
        WHERE NameQuery = '" . $nameQuery  . "'";

        $result_query = mysqli_query($conn, $sql);
    }

//Если нажали кнопку Удалить запрос
    if($Button == "Удалить запрос"){
        $nq = $_POST['nq'];
        $g = $_POST['group'];
        $ln = $_POST['lastname'];

        $nameQuery = $nq . "_" . $g . "_" . $ln;

        $sql = "DELETE FROM querytupl WHERE NameQuery='$nameQuery'";
        $result_query = mysqli_query($conn, $sql);
    }

//Если нажали кнопку Выполнить SQL
    if($Button == "Выполнить SQL"){
        //$sql = $_POST['action'];

        $sql = $_POST['query'];
        echo "<table width=100% cellpadding=5>";
        echo "<tr align=center bgcolor=#808080>";
        $result_query = mysqli_query($conn, $sql);
        echo "<br>";
        while($name = mysqli_fetch_field($result_query) -> name)
        {
            echo "<th>".$name."</th>";

        }

        echo "</tr>";

        while($get_query = mysqli_fetch_assoc($result_query))
        {

        echo "<tr align=center bgcolor=#cccccc>";
        foreach($get_query as $k => $val)
            {
                echo "<td>".$val. "</td>";
            }

        echo "</tr>";

        }
        echo "</table>";
    }

//Если нажали кнопку создать View
if($Button == "Создать View"){
    $nameView = $_POST['select'];
    $sqlView = $_POST['query'];
    $sql = "create algorithm = UNDEFINED view `" . $nameView . "` as " . $sqlView;
    $result_query = mysqli_query($conn, $sql);
}
?>