php import from JSON (converted to values array) and inserted to php database - Book Club app

insert_json_data_to_php_database

<?php
	$jsondata = file_get_contents("books.json");
	$json = json_decode($jsondata, true);
    include('dbconnection.php');
    foreach($json['books'] as $key => $value){
        $array = array();
        foreach($value as $prop){
            array_push($array, "'". $prop ."'");
        }
        $a = implode(' ,', $array);
        $query="INSERT INTO books(id,cover_image,title,author,rating,length,shelf,amazon_link,date_added,date_read,reviews)VALUES($a)";
        $run_query = mysqli_query($connection, $query);
        if($run_query){
            echo "Data has been inserted into your Database.";
        } else {
            echo "Data could not be inserted";
        }
        echo $a;
    }
    mysqli_close($connection);
?>

Pretty chuffed to have figured this out super quickly this morning and automate transfering the Data from a JSON to database, although of course it is not so much, who needs extra typing or copy pasting :)