PHP Classes

MyJSON: Return MySQL query results in JSON format

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2025-05-08 (3 hours ago) RSS 2.0 feedNot enough user ratingsTotal: 377 All time: 6,751 This week: 48Up
Version License PHP version Categories
myjson 1.0.10GNU General Publi...5.3PHP 5, Databases
Description 

Author

Shibly

This class can return MySQL query results in JSON format.

It connects to a given MySQL server using the PDO extension and executes a given SQL query.

The class can return the query result values in JSON format. Optionally it may add line breaks and spaces to make the resulting JSON string more readable.

Picture of Shibly
Name: Shibly <contact>
Classes: 7 packages by
Country: Bangladesh Bangladesh
Age: 39
All time rank: 69011 in Bangladesh Bangladesh
Week rank: 195 Up5 in Bangladesh Bangladesh Up

Details

# MySql_to_Json

`mysql_to-json` is a php class that will allow you to create json string from a mysql query with the MySQLtoJSON method with 1 or 2 parameters.

1. $query - The mysql query (required)
2. $indented - If true, the return string will be indented

`mysql_to_json` is build with the top of PDO. It is still in development stage. This is the first release. Feel free to fork.

  Files folder image Files (3)  
File Role Description
Accessible without login Plain text file .gitignore Data Auxiliary data
Plain text file MyJSON.php Class Class source
Accessible without login Plain text file readme.md Doc. Documentation

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
Downloadmyjson-2025-05-08.zip
Downloadmyjson-2025-05-08.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:377
This week:0
All time:6,751
This week:48Up

  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.