[
    {
        "tableName":"table_Name_1",
        "rows":[
                {
                    "t1column1":"valuet1row11",
                    "t1column2":"valuet1row12",
                    "t1columnx":"valuet1row1x"
                },
                {
                    "t1column1":"valuet1row21",
                    "t1column2":"valuet1row21",
                    "t1columnx":"valuet1row2x"
                },
                {
                    "t1column1":"valuet1rowx1",
                    "t1column2":"valuet1rowx2",
                    "t1columnx":"valuet1rowxx"
                }
               ]
    },
        {
        "tableName":"table_Name_2",
        "rows":[
                {
                    "t2column1":"valuet2row11",
                    "t2column2":"valuet2row12",
                    "t2columnx":"valuet2row1x"
                },
                {
                    "t2column1":"valuet2row21",
                    "t2column2":"valuet2row22",
                    "t2columnx":"valuet2row2x"
                },
                {
                    "t2column1":"valuet2rowx1",
                    "t2column2":"valuet2rowx2",
                    "t2columnx":"valuet2rowxx"
                }
               ]
    },
        {
        "tableName":"table_Name_n",
        "rows":[
                {
                    "tncolumn1":"valuetnrow11",
                    "tncolumn2":"valuetnrow12",
                    "tncolumnx":"valuetnrow1x"
                },
                {
                    "tncolumn1":"valuetnrow21",
                    "tncolumn2":"valuetnrow22",
                    "tncolumnx":"valuetnrow2x"
                },{
                    "tncolumn1":"valuetnrowx1",
                    "tncolumn2":"valuetnrowx2",
                    "tncolumnx":"valuetnrowxx"
                }
               ]
    },
]

<?php
    try
    {
        $connect = mysqli_connect("localhost", "fmart", "password", "mart_dbsync");
        $query = '';
        $table_data = '';
        $filename = "single_table.json";

        $data = file_get_contents($filename);
        $array = json_decode($data, true);

        foreach($array as $row)
        {
            $query .= "INSERT INTO purchases(id, invoicenum, supplier, stock_keeper, counter, added_by, is_deleted, description, is_opening_stock, department, added_on, last_updated) VALUES ('".$row["id"]."', '".$row["invoicenum"]."', '".$row["supplier"]."', '".$row["stock_keeper"]."', '".$row["counter"]."', '".$row["added_by"]."', '".$row["is_deleted"]."', '".$row["description"]."', '".$row["is_opening_stock"]."', '".$row["department"]."', '".$row["added_on"]."', '".$row["last_updated"]."') ON DUPLICATE KEY UPDATE invoicenum='".$row["invoicenum"]."', supplier='".$row["supplier"]."', stock_keeper='".$row["stock_keeper"]."', counter='".$row["counter"]."', added_by='".$row["added_by"]."', is_deleted='".$row["is_deleted"]."', description='".$row["description"]."', is_opening_stock='".$row["is_opening_stock"]."', department='".$row["department"]."', added_on='".$row["added_on"]."', last_updated='".$row["last_updated"]."';";
        }

            mysqli_multi_query($connect, $query);

            echo "<h1>All purchases appeded </h1>";
    }

    catch(Exception $e)
    {
        echo $e->getMessage();
    }
?>