PHP Classes

Query To JSON: Convert MySQL query results to JSON format

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
Not enough user ratingsTotal: 1,407 All time: 2,773 This week: 455Up
Version License PHP version Categories
querytojson 0.1BSD License5.2PHP 5, Databases, Text processing, Da...
Description 

Author

L Bharti

This is a very simple class that converts data from MySQL query result to JSON format.

It executes a given MySQL query and extracts the results into a single array.

The class calls the PHP function json_encode to return a string with the whole result set data in the JSON format.

Picture of L Bharti
Name: L Bharti <contact>
Classes: 1 package by
Country: United States United States

 

Details

Author : Loknath Bharti
Email : lbharti at gmail dot com

class : QueryToJson
Functions

queryToJson($result, $header) :
It converts the mysql query result into a JSON string with $header 
as the top header with column header as the header for other data values

Arguments : 

	$result : mysql result returned by mysql_query()
	$header : top header of the JSON object

Return : the JSON string

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file example.php Example example
Plain text file queryToJson.class.php Class class
Accessible without login Plain text file README Doc. README

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
Downloadquerytojson-2008-06-08.zip 1KB
Downloadquerytojson-2008-06-08.tar.gz 979
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,407
This week:0
All time:2,773
This week:455Up

  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.