5951592-MySQL Conversion Class.zip

MySQL Conversion Class

• easy way to Import/Export MySQL Data;
• easy way to create API;
• get result of MySQL query as XML, JSON or associative array;
• print result (with headers) of MySQL query as XML, JSON or associative array;
• insert, update or delete data on MySQL table using XML, JSON or associative array;
• support MySQL and MySQLi driver;
• the JSON created can be indented or not, you choose;
• easy to get class-failure errors;
• examples of both functions are included.

Example

Get JSON data from MySQL query ($query)

DB::init($params)->query($query)->as_json(true);


Insert JSON data into MySQL table

DB::init($params)->from_json($data)->insert('test');


For more examlpes please read description.

Changelog

Version 1.1

• Add method update($table,$where)
• Add method delete($table,$where)

Version 1.0

• Released