I need to convert the data in the MYSQL database to Word.
My code
require './modules/vendor/autoload.php';
require 'core.php';
$templateProcessor = new \PhpOffice\PhpWord\TemplateProcessor(__DIR__ . '/wordfile.docx');
$topshiriqnoma = $connection->table('topshiriqnoma')->where('chiqinn', $id)->orderBy('id', 'desc')->paginate(50);
$nomi = $connection->table('topshiriqnoma')->where('chiqinn', $id)->orderBy('id', 'desc')->first();
unlink(UPLOAD_PATH . '/porucheniya/' . $item->chiqnm." ".shaklqisqa($item->chiqsh, $item->chiqnm) . '.docx');
foreach ($topshiriqnoma as $item) {
$summahamma = str_replace(" ", "", $item->sum); // 70
if (strpos($summahamma, ',') == true) {
$mas = explode(',', $summahamma);
$summasoz = convertNumberToWord($mas['0']) . " сўм " . $mas['1'] . " тийин";
$summaraqam = number_format((float)$summahamma, 2, '.', ' ');
} elseif (strpos($summahamma, '.') == true) {
$mas = explode('.', $summahamma);
$summasoz = convertNumberToWord($mas['0']) . " сўм " . $mas['1'] . " тийин";
$summaraqam = number_format((float)$summahamma, 2, '.', ' ');
} else {
$summasoz = convertNumberToWord($item->sum) . " сўм";
$summaraqam = number_format((float)$summahamma, 2, ',', ' ');
}
$replacements[] = [
'no' => $item->no,
'sana' => $item->sana,
'tashkilot' => $item->chiqnm." ".shaklqisqa($item->chiqsh, $item->chiqnm),
'chiqxr' => $item->chiqxr,
'chiqinn' => $item->chiqinn,
'chiqbk' => $item->chiqbk,
'chiqmfo' => $item->chimfo,
'summa' => $summaraqam,
'kirtash' => $item->kirnm." ".shaklqisqa($item->kirsh, $item->kirnm),
'kirxr' => $item->kirxr,
'kirinn' => $r = (0 != $item->kirinn) ? $item->kirinn : '',
'kirbk' => $item->kirbk,
'kirmfo' => $item->kirmfo,
'summasoz' => $summasoz,
'maqsad' => $item->maqsad,
'boshliq' => $item->bosh,
'xisobchi' => $item->bux
];
}
$templateProcessor->cloneRow('nameblock', count($replacements));
$templateProcessor->saveAs(UPLOAD_PATH . '/porucheniya/' . $item->chiqnm." ".shaklqisqa($item->chiqsh, $item->chiqnm) . '.docx');
header('Location: ' . $home . '/upload/porucheniya/' . $item->chiqnm." ".shaklqisqa($item->chiqsh, $item->chiqnm) . '.docx');
But if the Word file is like this, everything works fine. The problem is that it has to work in Table mode (first picture) mode for me.
It didn't work because I used a much older PHPWord. I have installed a new PHPword and everything is working fine