Login   Register  
PHP Classes
elePHPant
Icontem

Class: MySQL to JSON

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Adnan Siddiqi  >  MySQL to JSON  >  Download .tar.gz .zip  >  Support forum Support forum (3)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL to JSON
Support forum Support forum
Base name: mysql2json
Description: Convert data from MySQL query results into JSON
Related classes: , , ,
Version: -
PHP version: -
License: The PHP License
All time users: 8183 users
All time rank: 153
Week users: 15 users
Week rank: 193
Picture of Adnan Siddiqi
Author: Adnan Siddiqi is available for providing paid consulting. Contact Adnan Siddiqi .
Packages: 1 Browse this author's classes Browse this author's classes
Country: Pakistan Pakistan - PHP jobs in Pakistan
Age: 111
All time rank: 2452 in Pakistan Pakistan
Week rank: 2384 in Pakistan Pakistan
Innovation award
Innovation award
Nominee: 1x


  Detailed description  
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.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes

  Freshmeat project   Rate classes User ratings   Trackback   Applications   Files Files  

  Innovation Award  
PHP Programming Innovation award nominee
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.49
Vitality score: 45.2

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (66.7%)
Sufficient (75.0%)
Sufficient (66.7%)
Good (83.3%)
-
-
Not sure (55.8%)
1097
Month:
Not yet rated by the users

  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...
Latest blog trackback links Latest blog trackback links

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file example.php Example Example
Plain text file jsontest2.html Data HTML file parsing returned JSON data
Plain text file mysql2json.class.php Class Main Class File
Plain text file README.txt Doc. Help File

Download all files: mysql2json.tar.gz mysql2json.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.