DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
EXT: Readable name of your extension¶
Created: | 2010-02-18T17:33:18 |
---|---|
Changed by: | Mattias Nilsson |
Changed: | 2012-03-01T10:33:18.320000000 |
Classification: | extensionkey |
Description: | The keywords help with categorizing and tagging of the manuals. You can combine two or more keywords and add additional keywords yourself. Please use at least one keyword from both lists. If your manual is NOT in english, see next tab "language" ---- forEditors (use this for editors / german "Redakteure") forAdmins (use this for Administrators) forDevelopers (use this for Developers) forBeginners (manuals covering TYPO3 basics) forIntermediates (manuals going into more depth) forAdvanced (covering the most advanced TYPO3 topics) see more: http://wiki.typo3.org/doc_template#tags ---- |
Keywords: | keywords comma-separated |
Author: | Author Name |
Email: | your@email.com |
Info 4: | |
Language: | en |
MySQL to JSON - mn_mysql2jsonMySQL to JSON
MySQL to JSON¶
Extension Key: mn_mysql2json
Language: en
Keywords: MySQL, JSON, Mobile development
Copyright 2000-2012, Mattias Nilsson, <tollepjaer@gmail.com>
This document is published under the Open Content License
available from http://www.opencontent.org/opl.shtml
The content of this document is related to TYPO3
- a GNU/GPL CMS/Framework available from www.typo3.org
Table of Contents¶
`Introduction 3 <#__RefHeading__718_1852152340>`_
`Users manual 4 <#__RefHeading__722_1852152340>`_
`Installation 5 <#__RefHeading__254_2094181772>`_
`First install the extension from TER. 5 <#__RefHeading__256_2094181772>`_
`Configuration 6 <#__RefHeading__726_1852152340>`_
`To-Do list 7 <#__RefHeading__730_1852152340>`_
Introduction¶
What does it do?¶
A extension for getting content from any database table in TYPO3 (default tt_content and pages). This extension is mostly thought to be used for mobile webdevelopment. For example if you are using a framework for creating a mobile version of your TYPO3 page (example Senacha Touch or jQuery Mobile) and are only making AJAX requests. Then this extension provides and easy solution for getting the content of any database table.
Users manual¶
First of all just install the extension and you have all the functionality already without any configuration.
FAQ¶
For a more information how to use the extension read more in the Configuration section.
Installation¶
First install the extension from TER.
Installation¶
Then configure in the extension manager for the extension which database table should be accessable, use comma separation between table names. Defaullt tables are pages and tt_content. Then hit the update button.
Configuration¶
- Target group: Developers
- A request to the extension can look like this: http://yourdomain/?eID= tx_mnmysql2json_Table&tx_mnmysql2json[action]=getTable&tx_mnmysql2 json[tableName]=pages&tx_mnmysql2json[fields]=title,pid,uid
Reference¶
Reference
tx_mnmysql2json[tableName]¶
Property
tx_mnmysql2json[tableName]
Data type
string
Description
From which MySQL table to get content from. MUST BE INCLUDED IN REQUEST!
Default
tx_mnmysql2json[fields]¶
Property
tx_mnmysql2json[fields]
Data type
string
Description
From which columns in the table to get content from. MUST BE INCLUDED IN REQUEST!
Default
tx_mnmysql2json[where]¶
Property
tx_mnmysql2json[where]
Data type
string
Description
The where clause in request. For example tx_mnmysql2json[where]=pid = 1
Default
empty
tx_mnmysql2json[groupBy]¶
Property
tx_mnmysql2json[groupBy]
Data type
string
Description
The group by clause, for example tx_mnmysql2json[groupBy]=pid
Default
empty
tx_mnmysql2json[orderBy]¶
Property
tx_mnmysql2json[orderBy]
Data type
string
Description
The order by clause, for example tx_mnmysql2json[orderBy]=title ASC
Default
empty
tx_mnmysql2json[limit]¶
Property
tx_mnmysql2json[limit]
Data type
string
Description
The limit clause, for example tx_mnmysql2json[limit]=10
Default
empty
To-Do list¶
- Build a better configuration of what kind of data in a table whould be available in the request.
- TYPO3 Forge
7