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  
Name: Isaac Trenado Mx <contact>
Classes: 7 packages by
Country: Mexico Mexico
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

  Files folder image Files  /  adodb  
File Role Description
Files folder imagecontrib (1 file)
Files folder imagecute_icons_for_site (2 files)
Files folder imagedatadict (14 files)
Files folder imagedrivers (56 files)
Files folder imagelang (23 files)
Files folder imagepear (1 file, 1 directory)
Files folder imageperf (7 files)
Files folder imagesession (19 files, 1 directory)
Files folder imagexsl (6 files)
  Accessible without login Plain text file adodb-active-record.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-active-recordx.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-csvlib.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-datadict.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-error.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-errorhandler.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-errorpear.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-exceptions.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-iterator.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-lib.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-memcache.lib.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pager.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pear.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-perf.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-php4.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-time.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-xmlschema.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-xmlschema03.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb.inc.php Aux. Auxiliary script
  Accessible without login Plain text file pivottable.inc.php Aux. Auxiliary script
  Accessible without login Plain text file rsfilter.inc.php Aux. Auxiliary script
  Accessible without login Plain text file server.php Aux. Auxiliary script
  Accessible without login Plain text file toexport.inc.php Aux. Auxiliary script
  Accessible without login Plain text file tohtml.inc.php Aux. Auxiliary script
  Accessible without login Plain text file xmlschema.dtd Data Auxiliary data
  Accessible without login Plain text file xmlschema03.dtd Data Auxiliary data

  Files folder image Files  /  adodb  /  contrib  
File Role Description
  Accessible without login Plain text file toxmlrpc.inc.php Aux. Auxiliary script

  Files folder image Files  /  adodb  /  cute_icons_for_site  
File Role Description
  Accessible without login Image file adodb.gif Icon Icon image
  Accessible without login Image file adodb2.gif Icon Icon image

  Files folder image Files  /  adodb  /  datadict  
File Role Description
  Accessible without login Plain text file datadict-access.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-db2.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-firebird.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-generic.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-ibase.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-informix.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-mssql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-mssqlnative.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-mysql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-oci8.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-postgres.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-sapdb.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-sqlite.inc.php Aux. Auxiliary script
  Accessible without login Plain text file datadict-sybase.inc.php Aux. Auxiliary script

  Files folder image Files  /  adodb  /  drivers  
File Role Description
  Accessible without login Plain text file adodb-access.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ado.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ado5.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ado_access.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ado_mssql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ads.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-borland_ibase.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-csv.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-db2.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-db2oci.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-db2ora.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-fbsql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-firebird.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ibase.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-informix.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-informix72.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-ldap.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mssql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mssqlnative.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mssqlpo.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mssql_n.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mysql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mysqli.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mysqlpo.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-mysqlt.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-netezza.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-oci8.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-oci805.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-oci8po.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbc.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbc_db2.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbc_mssql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbc_oracle.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbtp.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-odbtp_unicode.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-oracle.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo_mssql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo_mysql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo_oci.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo_pgsql.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-pdo_sqlite.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-postgres.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-postgres64.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-postgres7.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-postgres8.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-postgres9.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-proxy.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-sapdb.inc.php Aux. Auxiliary script
  Accessible without login Plain text file adodb-sqlanywhere.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sqlite.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sqlite3.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sqlitepo.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sybase.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sybase_ase.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-vfp.inc.php Aux. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  lang  
File Role Description
  Accessible without login Plain text file adodb-ar.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-bg.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-bgutf8.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-ca.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-cn.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-cz.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-da.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-de.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-en.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-es.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-esperanto.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-fa.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-fr.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-hu.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-it.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-nl.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-pl.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-pt-br.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-ro.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-ru1251.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sv.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-uk1251.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb_th.inc.php Aux. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  pear  
File Role Description
Files folder imageAuth (1 directory)
  Accessible without login Plain text file readme.Auth.txt Doc. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  pear  /  Auth  
File Role Description
Files folder imageContainer (1 file)

  Files folder image Files  /  adodb  /  pear  /  Auth  /  Container  
File Role Description
  Accessible without login Plain text file ADOdb.php Aux. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  perf  
File Role Description
  Accessible without login Plain text file perf-db2.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-informix.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-mssql.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-mssqlnative.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-mysql.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-oci8.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file perf-postgres.inc.php Aux. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  session  
File Role Description
Files folder imageold (4 files)
  Accessible without login Plain text file adodb-compress-bzip2.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-compress-gzip.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-cryptsession.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-cryptsession2.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-encrypt-mcrypt.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-encrypt-md5.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-encrypt-secret.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-encrypt-sha1.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sess.txt Doc. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session-clob.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session-clob2.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session2.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sessions.mysql.sql Data ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sessions.oracle.clob.sql Data ADOBPHP Download for more information
  Accessible without login Plain text file adodb-sessions.oracle.sql Data ADOBPHP Download for more information
  Accessible without login Plain text file crypt.inc.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file session_schema.xml Data ADOBPHP Download for more information
  Accessible without login Plain text file session_schema2.xml Data ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  session  /  old  
File Role Description
  Accessible without login Plain text file adodb-cryptsession.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session-clob.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file adodb-session.php Aux. ADOBPHP Download for more information
  Accessible without login Plain text file crypt.inc.php Aux. ADOBPHP Download for more information

  Files folder image Files  /  adodb  /  xsl  
File Role Description
  Accessible without login Plain text file convert-0.1-0.2.xsl Data ADOBPHP Download for more information
  Accessible without login Plain text file convert-0.1-0.3.xsl Data ADOBPHP Download for more information
  Accessible without login Plain text file convert-0.2-0.1.xsl Data ADOBPHP Download for more information
  Accessible without login Plain text file convert-0.2-0.3.xsl Data ADOBPHP Download for more information
  Accessible without login Plain text file remove-0.2.xsl Data ADOBPHP Download for more information
  Accessible without login Plain text file remove-0.3.xsl Data ADOBPHP Download for more information

 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