Database Administration
Add a Generated Column in MySQL
A generated column holds a value MySQL computes from the rest of the row, so it can never drift out of step. This tutorial…
//
Tag: JSON
Database Administration
Store and Query JSON Data in MySQL
Use the JSON column type to store documents MySQL actually understands. This tutorial inserts JSON, reads keys with JSON_EXTRACT and the ->> shorthand, edits…
Programming
Add a Custom Endpoint to the WordPress REST API
A custom REST API endpoint serves your site's own JSON at a URL you choose. Use register_rest_route() to publish a public route that returns…
Programming
Make an HTTP Request in PHP with cURL
Call a JSON API from PHP with the bundled cURL extension. Run a GET and a POST, read the HTTP status code, and decode…
Programming
Populate Dropdown JSON File With jQuery
Learn how to populate dropdown from a JSON file with jQuery. Allow users to select an item from a group of options in a…
Programming
Read and Parse JSON files in PHP
Read and parse JSON files using the functions file_get_contents() and json_decode() in PHP. The function file_get_contents() will read the entire file into a string,…