libraries/export/json.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Set of functions used to build dumps of tables as JSON
   5  *
   6  * @package phpMyAdmin-Export
   7  * @subpackage JSON
   8  */
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 /**
  14  *
  15  */
  16 if (isset($plugin_list)) {
  17     $plugin_list['json'] = array(
  18         'text'          => 'JSON',
  19         'extension'     => 'json',
  20         'mime_type'     => 'text/plain',
  21         'options'       => array(
  22             array('type' => 'begin_group', 'name' => 'general_opts'),
  23             array(
  24                 'type' => 'hidden',
  25                 'name' => 'structure_or_data',
  26             ),
  27             array('type' => 'end_group')
  28         ),
  29         'options_text'  => __('Options'),
  30     );
  31 } else {
  32
  33     /**
  34      * Set of functions used to build exports of tables
  35      */
  36
  37     /**
  38      * Outputs export footer
  39      *
  40      * @return  bool        Whether it suceeded
  41      *
  42      * @access  public
  43      */
  44     function PMA_exportFooter()
  45     {
  46         return true;
  47     }
  48
  49     /**
  50      * Outputs export header
  51      *
  52      * @return  bool        Whether it suceeded
  53      *
  54      * @access  public
  55      */
  56     function PMA_exportHeader()
  57     {
  58         PMA_exportOutputHandler(
  59             '/**' . $GLOBALS['crlf']
  60             . ' Export to JSON plugin for PHPMyAdmin' . $GLOBALS['crlf']
  61             . ' @version 0.1' . $GLOBALS['crlf']
  62             . ' */' . $GLOBALS['crlf'] . $GLOBALS['crlf']
  63         );
  64         return true;
  65     }
  66
  67     /**
  68      * Outputs database header
  69      *
  70      * @param string  $db Database name
  71      * @return  bool        Whether it suceeded
  72      *
  73      * @access  public
  74      */
  75     function PMA_exportDBHeader($db)
  76     {
  77         PMA_exportOutputHandler('// Database \'' . $db . '\'' . $GLOBALS['crlf'] );
  78         return true;
  79     }
  80
  81     /**
  82      * Outputs database footer
  83      *
  84      * @param string  $db Database name
  85      * @return  bool        Whether it suceeded
  86      *
  87      * @access  public
  88      */
  89     function PMA_exportDBFooter($db)
  90     {
  91         return true;
  92     }
  93
  94     /**
  95      * Outputs CREATE DATABASE statement
  96      *
  97      * @param string  $db Database name
  98      * @return  bool        Whether it suceeded
  99      *
 100      * @access  public
 101      */
 102     function PMA_exportDBCreate($db)
 103     {
 104         return true;
 105     }
 106
 107     /**
 108      * Outputs the content of a table in JSON format
 109      *
 110      * @param string  $db         database name
 111      * @param string  $table      table name
 112      * @param string  $crlf       the end of line sequence
 113      * @param string  $error_url  the url to go back in case of error
 114      * @param string  $sql_query  SQL query for obtaining data
 115      * @return  bool        Whether it suceeded
 116      *
 117      * @access  public
 118      */
 119     function PMA_exportData($db, $table, $crlf, $error_url, $sql_query)
 120     {
 121         $result      = PMA_DBI_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED);
 122
 123         $columns_cnt = PMA_DBI_num_fields($result);
 124         for ($i = 0; $i < $columns_cnt; $i++) {
 125             $columns[$i] = stripslashes(PMA_DBI_field_name($result, $i));
 126         }
 127         unset($i);
 128
 129         $buffer = '';
 130         $record_cnt = 0;
 131         while ($record = PMA_DBI_fetch_row($result)) {
 132
 133             $record_cnt++;
 134
 135             // Output table name as comment if this is the first record of the table
 136             if ($record_cnt == 1) {
 137                 $buffer .= '// ' . $db . '.' . $table . $crlf . $crlf;
 138                 $buffer .= '[{';
 139             } else {
 140                 $buffer .= ', {';
 141             }
 142
 143             for ($i = 0; $i < $columns_cnt; $i++) {
 144
 145                 $isLastLine = ($i + 1 >= $columns_cnt);
 146
 147                 $column = $columns[$i];
 148
 149                 if (is_null($record[$i])) {
 150                     $buffer .= '"' . addslashes($column) . '": null' . (! $isLastLine ? ',' : '');
 151                 } elseif (is_numeric($record[$i])) {
 152                     $buffer .= '"' . addslashes($column) . '": ' . $record[$i] . (! $isLastLine ? ',' : '');
 153                 } else {
 154                     $buffer .= '"' . addslashes($column) . '": "' . addslashes($record[$i]) . '"' . (! $isLastLine ? ',' : '');
 155                 }
 156             }
 157
 158             $buffer .= '}';
 159         }
 160
 161         if ($record_cnt) {
 162             $buffer .=  ']';
 163         }
 164         if (! PMA_exportOutputHandler($buffer)) {
 165             return false;
 166         }
 167
 168         PMA_DBI_free_result($result);
 169
 170         return true;
 171     }
 172
 173 }