Ik heb:
<?php
$someArray = json_decode(file_get_contents("php://input"), true);
?>Deze array is bijvoorbeeld;
(
[0] => Array
(
[number] => 1
[ledger] => Grootboekrekening 1
[project] => project 1
[relation] => relatie
[debit] => 100
[credit] => 100
[tax] => 20
[date] => 2019-19-10
[postingdate] => 2019-19-10
[description] => omschrijving
[period] => periode
[id] => DE2A0B8D-E6A2-B6E3-6618-F1FDBF76DE87
)
[1] => Array
(
[number] => 1
[ledger] => Grootboekrekening 2
[project] => project 2
[relation] => relatie
[debit] => 100
[credit] => 100
[tax] => 20
[date] => 2019-19-10
[postingdate] => 2019-19-10
[description] => omschrijving
[period] => periode
[id] => AE2992D0-11DC-FFB4-1AD5-3E694CC6EEA4
)
)
Nu wil ik deze array omzetten naar sql en in de database plaatsen doormiddel van;
<?php
foreach ($someArray as $key => $value) {
$query = "INSERT INTO journal (number, ledger, project, relation, debet, credit, tax, date, postingdate, description, period, Id) VALUES ('"$value['number']"','"$value['ledger']"','"$value['project']"','"$value['relation']"','"$value['debet']"','"$value['credit']"','"$value['tax']"','"$value['date']"','"$value['postingdate']"','"$value['description']"','"$value['period']"','"$value['Id']"')";
$statement = $connect->prepare($query);
$statement->execute();
$query = "";
}
?>
Nu krijg ik in mijn console de volgende melding;
<b>Parse error</b>: syntax error, unexpected '$value' (T_VARIABLE) in.
Iemand een idee hoe ik dit kan oplossen??
Alvast bedankt mocht iemand reageren.
