PHP 7.4.33
Preview: LintController.php Size: 1.73 KB
/usr/share/phpmyadmin/libraries/classes/Controllers/LintController.php
<?php
/**
 * Represents the interface between the linter and the query editor.
 */

declare(strict_types=1);

namespace PhpMyAdmin\Controllers;

use PhpMyAdmin\Core;
use PhpMyAdmin\Linter;

use function json_encode;

/**
 * Represents the interface between the linter and the query editor.
 */
class LintController extends AbstractController
{
    public function __invoke(): void
    {
        $params = [
            'sql_query' => $_POST['sql_query'] ?? null,
            'options' => $_POST['options'] ?? null,
        ];

        /**
         * The SQL query to be analyzed.
         *
         * This does not need to be checked again XSS or MySQL injections because it is
         * never executed, just parsed.
         *
         * The client, which will receive the JSON response will decode the message and
         * and any HTML fragments that are displayed to the user will be encoded anyway.
         *
         * @var string
         */
        $sqlQuery = ! empty($params['sql_query']) ? $params['sql_query'] : '';

        $this->response->setAjax(true);

        // Disabling standard response.
        $this->response->disable();

        Core::headerJSON();

        if (! empty($params['options'])) {
            $options = $params['options'];

            if (! empty($options['routineEditor'])) {
                $sqlQuery = 'CREATE PROCEDURE `a`() ' . $sqlQuery;
            } elseif (! empty($options['triggerEditor'])) {
                $sqlQuery = 'CREATE TRIGGER `a` AFTER INSERT ON `b` FOR EACH ROW ' . $sqlQuery;
            } elseif (! empty($options['eventEditor'])) {
                $sqlQuery = 'CREATE EVENT `a` ON SCHEDULE EVERY MINUTE DO ' . $sqlQuery;
            }
        }

        echo json_encode(Linter::lint($sqlQuery));
    }
}

Directory Contents

Dirs: 11 × Files: 25
Name Size Perms Modified Actions
Config DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Database DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Export DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Import DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Server DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Setup DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Sql DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
Table DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
View DIR
- drwxr-xr-x 2023-02-07 16:26:36
Edit Download
2.53 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
2.41 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
3.44 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
2.25 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
809 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
1.04 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
275 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
6.05 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
5.09 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
1.19 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
17.05 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
36.16 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
940 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
1.73 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
421 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
3.20 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
5.54 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
685 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
426 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
667 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
820 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
772 B lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
1.23 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
3.30 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
1.20 KB lrwxr-xr-x 2023-02-07 16:26:36
Edit Download
If ZipArchive is unavailable, a .tar will be created (no compression).