myui/sql.php at master · solitaa/myui · 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
<?php
    require_once(dirname(__FILE__) . "/selectFunc.php");
    require_once(dirname(__FILE__) . "/select.php");


function sql($chosenDbName)
{
    global $db;
    global $baseURL;
    require_once(dirname(__FILE__) . "/view/header.php");
    $db->exec("use $chosenDbName");
    require_once(dirname(__FILE__) . "/leftPart.php");
    require_once(dirname(__FILE__) . "/view/rightDiv/rightDivOpenTag.php");
    require_once(dirname(__FILE__) . "/view/rightDiv/menuBar.php");

    require_once(dirname(__FILE__) . "/view/rightDiv/sqlForm.php");

    require_once(dirname(__FILE__) . "/view/rightDiv/rightDivCloseTag.php");
    require_once(dirname(__FILE__) . "/view/footer.php");

}
function executeQuery($chosenDbName, $pageNumber){
    global $db;
    global $baseURL;
    global $rowsInPage;

    $db->exec("use $chosenDbName");

    if (isset($_POST['sql_query']) && $_POST['sql_query'] != '') {
        $newQuery = $_POST['sql_query'];
        $queryFirstWord = strtolower(substr(trim ($newQuery), 0, 6));
        $queryFirstWordShow = strtolower(substr(trim ($newQuery), 0, 4));

        if ($queryFirstWordShow == "show"){
            require_once(dirname(__FILE__) . "/showResults.php");
        } elseif ($queryFirstWord == "select"){
            $explainQuery = "EXPLAIN ".$newQuery;
            $statement = $db->prepare($explainQuery);
            $statement->execute();
            $fields = $statement->fetchAll(PDO::FETCH_ASSOC);
            if($fields){
                $chosenTableName = $fields[0]['table'];
                $allRowsCount = $fields[0]['rows'];
                $pageNumber = 1;
                require_once(dirname(__FILE__) . "/showResults.php");
            }

        } else {

            $statement = $db->prepare($newQuery);
            $statement->execute();
            $error = $statement->errorInfo();
            require_once(dirname(__FILE__) . "/view/header.php");
            require_once(dirname(__FILE__) . "/leftPart.php");
            require_once(dirname(__FILE__) . "/view/rightDiv/rightDivOpenTag.php");
            require_once(dirname(__FILE__) . "/view/rightDiv/menuBar.php");
            if($error[1] == '')
                require_once(dirname(__FILE__) . "/view/rightDiv/showSuccessResultUpdateInsert.php");
            else
                require_once(dirname(__FILE__) . "/view/rightDiv/showErrorResult.php");

            $queryString = $statement->queryString;
            require_once(dirname(__FILE__) . "/view/rightDiv/showSql.php");
            require_once(dirname(__FILE__) . "/view/rightDiv/rightDivCloseTag.php");
            require_once(dirname(__FILE__) . "/view/footer.php");
        }
    }
}