Tag Archives: json

MySQL Stored Procedure for CRUD Dynamic Queries

The new MySQL 5.7 version has some great features. One of them is the ‘JSON data’ type. We can use it for column of table like ‘Virtual Colunm’ with Indexing. But, ‘JSON data’ is also useful for stored procedure. Because we can compact parameters and the procedure could be more flexible.I made the procedures for table insert/update via JSON parameter. When I apply them to my project, data-handling codes in the application decreased dramatically. (These procedures impliment ‘MySQL Procedure Pattern for Nested Transaction‘) The code below is an old version. The ‥‥‥

Using request of JSON Payload in Slim framework

Slim Framework

How to enable JSON-Payload input in Slim Framework… SlimMiddlewareContentTypes.php



MSSQL table to json procedure

Return json string from table data. — Author: Matthew D. Erwin (Snaptech, LLC) — Create date: May 9, 2013   — Modify: Aiden Kim, May 30, 2014