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

img-1 img-2 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

MySQL to JSON 1

`Introduction 3 <#__RefHeading__718_1852152340>`_

What does it do? 3

`Users manual 4 <#__RefHeading__722_1852152340>`_

FAQ 4

`Installation 5 <#__RefHeading__254_2094181772>`_

`First install the extension from TER. 5 <#__RefHeading__256_2094181772>`_

Installation 5

`Configuration 6 <#__RefHeading__726_1852152340>`_

Reference 6

`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.

img-3

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

img-2 7