$row['article_identificationparts'], 'color-identificationsparts' => $row['color_identificationparts'], 'description-identificationparts' => $row['description_identificationparts'], ]; } // Itera sui risultati della query e popola $standards $standardsDetails = []; while ($rowstd = mysqli_fetch_assoc($stdinfo)) { $standardsDetails[] = [ 'standard_name' => $rowstd['standardname'], 'standard_code' => $rowstd['standardcode'], ]; } // Preparazione dei dati per la conversione in JSON $dataToConvertToJson = [ 'idtrf' => $idtrfdetails, 'trfnumber' => $trfnumber, 'revision' => $revision, 'descriptionart' => $trfData['sample_description'], 'article-type' => $trfData['name_articletype'], 'model-description' => $modeldesc, 'measurerange' => $trfData['measurefrom'] . '-' . $trfData['measureto'], 'client_certification' => $headercertid, 'client_test' => $headertestid, 'client_billing' => $headerbillingid, 'reportlanguage' => $reportlanguage, 'certificatelanguage' => $certificatelanguage, 'certificate_renew_review' => $prevreportnumber, 'revisionwhy' => $revisionfor, ]; // Aggiungi i dettagli delle parti di identificazione all'array principale $dataToConvertToJson['identification-parts-details'] = $identificationPartsDetails; $dataToConvertToJson['standards-details'] = $standardsDetails; // Conversione dei dati in JSON $jsonData = json_encode($dataToConvertToJson, JSON_PRETTY_PRINT); // Output the JSON echo $jsonData;