Exporting Structure and Data (Backup) - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 136

PHP array
In PHP, associative arrays can hold text data; therefore, a PHP-array export format is
available. The following is a PHP array export of the author table:
<?php
// marc_book.author
$author = array(
array('id'=>1,'name'=>'John Smith','phone'=>'[phone]'),
array('id'=>2,'name'=>'Maria Sunshine','phone'=>'333-3333')
);
MediaWiki tab le
MediaWiki ( http://www.mediawiki.or g/wiki/MediaWiki ) is a popular wiki
package, which supports the ubiquitous Wikipedia. This wiki software implements
a formatting language in which it's possible to describe data in tabular format.
Choosing this export format in phpMyAdmin produces a file which can be pasted on
a wiki page we are editing.
JSON
The JavaScrip t Object Notatio n ( http://json.org ) is a data-interchange format
popular in the web world. Exporting the author table in this format is shown in the
following block of code:
/**
Export to JSON plugin for PHPMyAdmin
@version 0.1
*/
/* Database 'marc_book' */
/* marc_book.author */
[{"id": 1,"name": "John Smith","phone": "+01 445 789-1234"}, {"id":
2,"name": "Maria Sunshine","phone": "333-3333"}]