48 lines
1.6 KiB
PHP
48 lines
1.6 KiB
PHP
|
|
<?php
|
|
$prodplacelist = new WA_MySQLi_RS("prodplacelist", $cmctrfdb, 0);
|
|
$prodplacelist->setQuery("SELECT * FROM contacts_td WHERE contacts_td.idtd='$idtd' ORDER BY contacts_td.sitenumber");
|
|
$prodplacelist->execute();
|
|
?>
|
|
<?php
|
|
$totprodplace = $prodplacelist->TotalRows;
|
|
?>
|
|
<?php if ($totprodplace > 0) { ?>
|
|
<?php
|
|
|
|
|
|
$pdf->SetFont('', 'B', '10');
|
|
|
|
|
|
$pdf->Cell(190, 6, $chemicalagentpdf, 1, 0, 'C');
|
|
|
|
$pdf->Ln();
|
|
$pdf->SetFont('', '', '9'); ?>
|
|
<?php
|
|
$wa_startindex = 0;
|
|
while (!$prodplacelist->atEnd()) {
|
|
$wa_startindex = $prodplacelist->Index;
|
|
|
|
$companyname = convertToPDFEncoding($prodplacelist->getColumnVal("companyname"));
|
|
$companyaddress = convertToPDFEncoding($prodplacelist->getColumnVal("address"));
|
|
$companycity = convertToPDFEncoding($prodplacelist->getColumnVal("city"));
|
|
$companycap = convertToPDFEncoding($prodplacelist->getColumnVal("cap"));
|
|
$companycountry = convertToPDFEncoding($prodplacelist->getColumnVal("country"));
|
|
$companytelephone = convertToPDFEncoding($prodplacelist->getColumnVal("telephone"));
|
|
$companyemail = convertToPDFEncoding($prodplacelist->getColumnVal("email"));
|
|
$contactname = convertToPDFEncoding($prodplacelist->getColumnVal("contactname"));
|
|
$companyfax = convertToPDFEncoding($prodplacelist->getColumnVal("fax"));
|
|
$pdf->Cell(190, 6, $companyname, 1, 0, 'L', TRUE);
|
|
$pdf->Ln();
|
|
|
|
$prodplacelist->moveNext();
|
|
}
|
|
$prodplacelist->moveFirst(); //return RS to first record
|
|
unset($wa_startindex);
|
|
unset($wa_repeatcount);
|
|
|
|
|
|
|
|
|
|
?><?php } ?>
|