<?php
// Copyright (c) 2021 ActivePDF, Inc.
// ActivePDF Toolkit 2018
// Example generated 01/20/21
?>
<?php
// Get current path
$strPath = dirname(__FILE__) . "\\";
// Instantiate Object
$oTK = new COM("APToolkit.Object");
// Create the new PDF file
$intOpenOutputFile = $oTK->OpenOutputFile($strPath . "new.pdf");
if ($intOpenOutputFile != 0) {
Error("OpenOutputFile", $intOpenOutputFile);
}
// Specify the template form to populate
$oTK->SetDBInputTemplate($strPath . "dbtemplate.pdf");
// Set query command to a variable
$strSQL = "Select * From Supplier";
// Set connection String to a variable
$strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" . $strPath . "xtreme.mdb" . ";Persist Security Info=False";
// Set master query
$oTK->SetMasterQuery($strConn, "Admin", "", -1, $strSQL);
// Set the row Separator
$oTK->SetDBMultiRowSeparator("");
// Related query separator is only needed if different from default of '|'
$oTK->RelatedQuerySeparator = "|";
// Add related query
$oTK->AddRelatedQuery($strConn, "Admin", "", -1, $strSQL, true);
// If db column names are different then field names a map file is needed
// In this example only the zip/postal code is different
$intLoadDBMapFile = $oTK->LoadDBMapFile($strPath . "dbformmap.txt");
if ($intLoadDBMapFile != 0) {
Error("LoadDBMapFile", $intLoadDBMapFile);
}
// Flatten fields that are populated with data
$oTK->SetDefaultDBMergeFlag(-997);
// Flatten all other fields on the form
$oTK->FlattenRemainingFormFields = 1;
// Fill the template form
$intDBToForm = $oTK->DBToForm(false);
if ($intDBToForm != 0) {
Error("DBToForm", $intDBToForm);
}
// Clear and close used queries
$oTK->ClearQueries();
// Close the output file
$oTK->CloseOutputFile();
// Release Object
$oTK = null;
// Process Complete
echo "Done!";
// Error Handling
function Error($method, $outputCode) {
echo "Error in " . $method . ": " . $outputCode;
}
?>
