This project will extract key value pairs from given json api, construct mysql queries and dumps into database. It has capability to navigate to n level of nesting to extract pairs.
Find out here: https://github.com/hasukmistry/format-json-to-key-value
PHP, Mysql & composer installed and configured.
Download/Clone this repo and do composer install
Under ./inc/config.inc.php , Set environment variables here.
define( 'DB_HOST', 'localhost' );
define( 'DB_USER', '{DB_USER}' );
define( 'DB_PASS', '{DB_PASS}' );
define( 'DB_NAME', 'json_db' );
define( 'TABLE_NAME', 'json_data_bindings' );
Lets first make a request to url which returns json.
$req = new ClassUrl();
// Sample url to make request.
$result = $req->get_response( 'https://jsonplaceholder.typicode.com/users', $host = 'jsonplaceholder.typicode.com' );
Now, lets create an object of ClassSerialize.
$ext = new ClassSerialize();
Following code will illustrate an use for key value extraction and generating queries.
if ( ! empty( $result['success'] ) ) {
// creates mysql connection with environment variables.
$conn = get_mysql_connection();
// Unique identifier to isolate records.
$mapping_id = '59';
// based on api response, generates and executes parent child queries.
$res = $ext->get_queries( $conn, $mapping_id, $result['body'] );
// closes mysql connection.
close_mysql_connection( $conn );
header( 'Cache-Control: no-cache, must-revalidate' ); // HTTP/1.1.
header( 'Content-Type:text/plain' );
// displays generated queries.
echo $res;
}
Lets first create an object of ClassUnserialize.
$ext = new ClassUnserialize();
Following code will illustrate an use for unserialization from database and construct json response.
// creates mysql connection with environment variables.
$conn = get_mysql_connection();
// Unique identifier to isolate records.
$mapping_id = '59';
// reads data from database and add it inside array.
$json = [];
$json = $ext->read_data( $mapping_id, $conn );
// closes mysql connection.
close_mysql_connection( $conn );
// outputs json from database.
header( 'Content-Type: application/json' );
echo json_encode( $json );