libraries/export/json.php

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