PHP Classes
elePHPant
Icontem

PHP MySQL JSON Manager: Build and Execute SQL queries with results in JSON

Recommend this page to a friend!
     
  Info   View files Example   View files View files (168)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog (1)    
Last Updated Ratings Unique User Downloads Download Rankings
2015-11-28 (1 year ago) RSS 2.0 feedNot enough user ratingsTotal: 501 All time: 5,621 This week: 656Up
Version License PHP version Categories
mysql-json-manager 1.9GNU General Publi...5.2.9PHP 5, Databases
Description Author

This package can build and execute SQL queries with results in JSON.

It can compose SQL queries of several types, so the results are returned from the database already formatted in JSON format.

Currently it can extract specific parameters from GET or POST arrays, generate SQL expressions to return JSON formatted strings or object values, execute the queries to return the query results as a single JSON string.

Recommendations

Best Package to Address SQL Injection Vulnerabilities
Upgrading security of existing MySQL code

Innovation Award
PHP Programming Innovation award nominee
February 2016
Number 2

Prize: One copy of the Zend Studio		 Nowadays many applications retrieve data from databases and serve it in JSON format, so it can be easily processed by JavaScript applications like those based on AJAX.

This class can compose and execute queries so they already return JSON encoded results, thus without need to further encode them.

Manuel Lemos
  Performance   Level  

Level 4 StarStarStarStar

 Innovation award
Innovation award
Nominee: 1x

Details

DPManagerJSON

BuildQuerys From Arrays to get Results in format JSON, Array, Array object, Objects. Crossdomain

  Files folder image Files  
File Role Description
Files folder imageadodb (26 files, 9 directories)
Accessible without login Plain text file basic.php Example Example script
Plain text file Conexion.php Class Class source
Plain text file DPManager.php Class Class source
Plain text file DPManagerJSON.php Class Class source
Accessible without login Plain text file dropsize_sql.sql Data Auxiliary data
Accessible without login HTML file example.html Data Example script
Accessible without login Plain text file README.md Data Auxiliary data
Plain text file UnicodeUtf8Replace.php Class Class source

Downloadmysql-json-manager-2015-11-28.zip 478KB
Downloadmysql-json-manager-2015-11-28.tar.gz 337KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:501
This week:0
All time:5,621
This week:656Up
User Comments (1)
peace and love, obviously that guy looks like he doesn´t was...
1 year ago (Marco Antonio Ramos Valencia)		80%StarStarStarStarStar
 

  Applications that use this package  
Codigolimpio
Portal

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


  Related pages  
Dropsize MVCf
Portal Dropsize Framework