Server IP : 85.214.239.14 / Your IP : 18.218.3.204 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/3/root/var/www/wordpress/phpMyAdmin/libraries/classes/Plugins/Export/ |
Upload File : |
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * Set of methods used to build dumps of tables as JSON * * @package PhpMyAdmin-Export * @subpackage JSON */ declare(strict_types=1); namespace PhpMyAdmin\Plugins\Export; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Export; use PhpMyAdmin\Plugins\ExportPlugin; use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyMainGroup; use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyRootGroup; use PhpMyAdmin\Properties\Options\Items\BoolPropertyItem; use PhpMyAdmin\Properties\Options\Items\HiddenPropertyItem; use PhpMyAdmin\Properties\Plugins\ExportPluginProperties; /** * Handles the export for the JSON format * * @package PhpMyAdmin-Export * @subpackage JSON */ class ExportJson extends ExportPlugin { private $first = true; /** * Constructor */ public function __construct() { parent::__construct(); $this->setProperties(); } /** * Encodes the data into JSON * * @param mixed $data Data to encode * * @return string */ public function encode($data) { $options = 0; if (isset($GLOBALS['json_pretty_print']) && $GLOBALS['json_pretty_print'] ) { $options |= JSON_PRETTY_PRINT; } if (isset($GLOBALS['json_unicode']) && $GLOBALS['json_unicode'] ) { $options |= JSON_UNESCAPED_UNICODE; } return json_encode($data, $options); } /** * Sets the export JSON properties * * @return void */ protected function setProperties() { $exportPluginProperties = new ExportPluginProperties(); $exportPluginProperties->setText('JSON'); $exportPluginProperties->setExtension('json'); $exportPluginProperties->setMimeType('text/plain'); $exportPluginProperties->setOptionsText(__('Options')); // create the root group that will be the options field for // $exportPluginProperties // this will be shown as "Format specific options" $exportSpecificOptions = new OptionsPropertyRootGroup( "Format Specific Options" ); // general options main group $generalOptions = new OptionsPropertyMainGroup("general_opts"); // create primary items and add them to the group $leaf = new HiddenPropertyItem("structure_or_data"); $generalOptions->addProperty($leaf); $leaf = new BoolPropertyItem( 'pretty_print', __('Output pretty-printed JSON (Use human-readable formatting)') ); $generalOptions->addProperty($leaf); $leaf = new BoolPropertyItem( 'unicode', __('Output unicode characters unescaped') ); $generalOptions->addProperty($leaf); // add the main group to the root group $exportSpecificOptions->addProperty($generalOptions); // set the options for the export plugin property item $exportPluginProperties->setOptions($exportSpecificOptions); $this->properties = $exportPluginProperties; } /** * Outputs export header * * @return bool Whether it succeeded */ public function exportHeader() { global $crlf; $meta = [ 'type' => 'header', 'version' => PMA_VERSION, 'comment' => 'Export to JSON plugin for PHPMyAdmin', ]; return $this->export->outputHandler( '[' . $crlf . $this->encode($meta) . ',' . $crlf ); } /** * Outputs export footer * * @return bool Whether it succeeded */ public function exportFooter() { global $crlf; return $this->export->outputHandler(']' . $crlf); } /** * Outputs database header * * @param string $db Database name * @param string $db_alias Aliases of db * * @return bool Whether it succeeded */ public function exportDBHeader($db, $db_alias = '') { global $crlf; if (empty($db_alias)) { $db_alias = $db; } $meta = [ 'type' => 'database', 'name' => $db_alias, ]; return $this->export->outputHandler( $this->encode($meta) . ',' . $crlf ); } /** * Outputs database footer * * @param string $db Database name * * @return bool Whether it succeeded */ public function exportDBFooter($db) { return true; } /** * Outputs CREATE DATABASE statement * * @param string $db Database name * @param string $export_type 'server', 'database', 'table' * @param string $db_alias Aliases of db * * @return bool Whether it succeeded */ public function exportDBCreate($db, $export_type, $db_alias = '') { return true; } /** * Outputs the content of a table in JSON format * * @param string $db database name * @param string $table table name * @param string $crlf the end of line sequence * @param string $error_url the url to go back in case of error * @param string $sql_query SQL query for obtaining data * @param array $aliases Aliases of db/table/columns * * @return bool Whether it succeeded */ public function exportData( $db, $table, $crlf, $error_url, $sql_query, array $aliases = [] ) { $db_alias = $db; $table_alias = $table; $this->initAlias($aliases, $db_alias, $table_alias); if (! $this->first) { if (! $this->export->outputHandler(',')) { return false; } } else { $this->first = false; } $buffer = $this->encode( [ 'type' => 'table', 'name' => $table_alias, 'database' => $db_alias, 'data' => "@@DATA@@", ] ); list($header, $footer) = explode('"@@DATA@@"', $buffer); if (! $this->export->outputHandler($header . $crlf . '[' . $crlf)) { return false; } $result = $GLOBALS['dbi']->query( $sql_query, DatabaseInterface::CONNECT_USER, DatabaseInterface::QUERY_UNBUFFERED ); $columns_cnt = $GLOBALS['dbi']->numFields($result); $fieldsMeta = $GLOBALS['dbi']->getFieldsMeta($result); $columns = []; for ($i = 0; $i < $columns_cnt; $i++) { $col_as = $GLOBALS['dbi']->fieldName($result, $i); if (! empty($aliases[$db]['tables'][$table]['columns'][$col_as])) { $col_as = $aliases[$db]['tables'][$table]['columns'][$col_as]; } $columns[$i] = stripslashes($col_as); } $record_cnt = 0; while ($record = $GLOBALS['dbi']->fetchRow($result)) { $record_cnt++; // Output table name as comment if this is the first record of the table if ($record_cnt > 1) { if (! $this->export->outputHandler(',' . $crlf)) { return false; } } $data = []; for ($i = 0; $i < $columns_cnt; $i++) { if ($fieldsMeta[$i]->type === 'geometry') { // export GIS types as hex $record[$i] = '0x' . bin2hex($record[$i]); } $data[$columns[$i]] = $record[$i]; } $encodedData = $this->encode($data); if (! $encodedData) { return false; } if (! $this->export->outputHandler($encodedData)) { return false; } } if (! $this->export->outputHandler($crlf . ']' . $crlf . $footer . $crlf)) { return false; } $GLOBALS['dbi']->freeResult($result); return true; } }