Query To JSON Support forum querytojson Convert MySQL query results to JSON format 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 ...
MySQL 2 JSON Support forum mysql_to_json Generate JSON output from MySQL query results This class can be use to Generate JSON output from MySQL query results. It takes an handle of a previously executed MySQL database query and retrieves the results to generate a JSON string with the values of all ...
MySQL to JSON Support forum mysql2json Convert data from MySQL query results into JSON 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 ...
MySQL2JSON Support forum simple_mysql2json Generate JSON representation from MySQL queries This class can be used to generate a JSON representation of data returned by MySQL queries. It can execute given MySQL and traverse the result set to generate a JSON representation of the data in the result ...
Easy PHP MySQL DB Support forum easy-php-mysql-db MySQL database access wrapper This class implements a MySQL database access wrapper. It can: - Establish connections to a given MySQL server host - Create databases and tables - Execute SQL queries - Retrieve query results as arrays, objects, JSON ...
This class implements the singleton design pattern to access SQL databases using the PDO extension. It can connect to several possible SQL databases using the available PDO drivers. Currently it supports CUBRID, MySQL, PostgreSQL, Oracle, Microsoft SQL server and Sybase. The class can also execute ...
MySQL query, paging and caching helper Support forum mysql-paging-cache Query and cache MySQL results to be paginated This class can query and cache MySQL results to be paginated. It can execute arbitrary SQL queries or assemble SELECT, INSERT, UPDATE and DELETE queries from lists of parameters ...
This package can be used to generate and update an hierarchical tree of elements from MySQL database content. A HTML page with some Javascript performs an AJAX request to obtain the list of elements of the tree from a MySQL database query. The tree of elements is returned to the browser in JSON format ...
This class is the ultimate MySQL database access wrapper. It can: - Establish MySQL server connections - Execute SQL queries - Query a single value or a single row - Retrieve query results into arrays or resource objects - Retrieve the last inserted ID - Manage transactions (transaction processing ...
This class can store up or down user votes in MySQL or files. It can record user votes as up or down values for a certain item in either a MySQL database or in files. The class can also retrieve the current vote count for a certain item and return its information in JSON formatted string suitable ...