MySQL to JSON
| Recommend this page to a friend! |  Stumble It! |
 Bookmark in del.icio.us |
| Classes of Adnan Siddiqi | > | MySQL to JSON | > | Download .tar.gz .zip | > |  Support forum (3) |
> |  Blog |
> |   Latest changes |
||
|
|||||||||||||||||||||||||
| Author | ||
 |
|
Innovation award Nominee: 1x | |||||||||||||||||||
Browse all classes by 
This class can be used to convert data from MySQL query results into a JavaScript expression in JavaScript Object Notation.
It takes a MySQL query result handle and retrieves the query result column names and the query result data.
The class generates the definition of a JavaScript object in JSON that contains an array of a rows of query result data.
Each array element represents an object with the properties set to the query result column names. The property values are the query results for the respective row and column.
It takes a MySQL query result handle and retrieves the query result column names and the query result data.
The class generates the definition of a JavaScript object in JSON that contains an array of a rows of query result data.
Each array element represents an object with the properties set to the query result column names. The property values are the query results for the respective row and column.
| Groups | Freshmeat project |  User ratings |
||||
| Trackback | Applications |  Files |
||||
| Groups | ||
 |
Databases | Database management, accessing and searching | View top rated classes |
| Innovation Award | ||
 July 2006 Number 3 |
Since the raise of interest on the development AJAX based applications, JavaScript Object Notation (JSON) has became a relevant topic. JSON is often used by Web server applications to serialize objects that are recreated on the browser side by Javascript code that handles AJAX based interactions. A great part of the AJAX applications are database driven. Frequently, PHP applications retrieve data from MySQL databases to respond to AJAX requests. This class helps implementing AJAX based PHP database driven applications with MySQL by serializing query results using JSON. Manuel Lemos |
| Freshmeat project | ||
| Project record: | mysql2json |
|---|---|
| Popularity score: | 11.45 |
| Vitality score: | 46.39 |
| User ratings | ||
| Ratings | ||||||||
|---|---|---|---|---|---|---|---|---|
| All time: | ||||||||
| Month: | ||||||||
| Trackback links | ||
| Link | Description |
|---|---|
| links for 2006-12-24 | Daily Links... |
| More PHP goodies | Here’s a PHP basic authenticator class by David Wilkinson and a MYSQL recordset to JSON convertor by Adnan Siddiqi. Handy little things... |
| My class in Top 10 | My class Mysql to JSON is ranked 8th this week in Top Downloaded Class section... |
| November 11, 2007 | I have been tinkering with trying to get mysql directly into JSON. |
| PHP-Based MySQL-to-JSON Converter | A new PHP component by Adnan Siddiqi accepts a MySQL result set and converts it into a JSON message... |
| PHP-Based MySQL-to-JSON Converter | A new PHP component by Adnan Siddiqi accepts a MySQL result set and converts it into a JSON message... |
| Applications that use this class | ||
No application links were specified for this class.
If you know an application of this package, send a message to the author to add a link here.| Files |
||
| File | Role | Description |
|---|---|---|
| example.php |
Example | Example |
| jsontest2.html |
Data | HTML file parsing returned JSON data |
| mysql2json.class.php |
Class | Main Class File |
| README.txt |
Doc. | Help File |
| Download all files: mysql2json.tar.gz mysql2json.zip |
For more information send a message to info at phpclasses dot org.
Copyright (c) Icontem 1999-2012