PHP Classes

MySQL to JSON: Convert data from MySQL query results into JSON

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 51%Total: 9,540 All time: 152 This week: 488Down
Version License Categories
mysql2json 1.0.0The PHP LicenseDatabases
Description 

Author

Adnan Siddiqi

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.

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
Picture of Adnan Siddiqi
Name: Adnan Siddiqi <contact>
Classes: 1 package by
Country: Pakistan Pakistan
Innovation award
Innovation award
Nominee: 1x

Details

class name: mysql2json

FUNCTION
=========
getJSON($result,$num)

The method which returns sql returned data from MYSQL database into JSON format.It takes two parameters:

a)$result:resultset data returns from mysql_query() method.
b)$num:Number of affected rows.Usually value returns from mysql_affected_rows().


If you find this piece of code useful, and need enhancements or find bugs... please do write to me,

Thanks

Adnan Siddiqi

  Files folder image Files (4)  
File Role Description
Accessible without login Plain text file example.php Example Example
Accessible without login Plain text file jsontest2.html Data HTML file parsing returned JSON data
Plain text file mysql2json.class.php Class Main Class File
Accessible without login Plain text file README.txt Doc. Help File

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadmysql2json-2010-11-07.zip 2KB
Downloadmysql2json-2010-11-07.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:9,540
This week:0
All time:152
This week:488Down
User Ratings User Comments (2)
 All time
Utility:62%StarStarStarStar
Consistency:68%StarStarStarStar
Documentation:62%StarStarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:51%StarStarStar
Rank:2484
  

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
Daily Links...
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 Mysql to JSON is ranked 8th this week in Top Downloaded Class section...
I have been tinkering with trying to get mysql directly into JSON.
A new PHP component by Adnan Siddiqi accepts a MySQL result set and converts it into a JSON message...
A new PHP component by Adnan Siddiqi accepts a MySQL result set and converts it into a JSON message...

Latest pages that reference packages Latest pages that reference packages