OpenTBS/php problems with output

Question

I've writing a php application on a LAMP server that takes a document(.odt) and populates it with the right information in the appropriate spots. While the code compiles it presents me with a print out of the header on one page and a stream of apparent gibberish on the other as follows:

''mimetypeapplication/vnd.oasis.opendocument.textPK?H?1?ﾡҡThumbnails/thumbnail.pngﾉPNG IHDR?g?ﾞﾡﾙIDATxﾜ???﾿?ﾧrҩ?Kﾖﾋ\䆻ﾱ ﾶ?l?R ﾤ )?ﾄﾄ?jﾨ&lcﾊ{??ٲz??ﾖovg?6?ﾰ=yoovvv?3ﾯ?R0B#4tD~?ﾡ+ﾍF 5BCL#ﾐﾡ!ﾦHﾍ??ﾤFhﾈiR#4?ﾩbﾁ? 1ﾍ@jﾄﾆﾘF 5BCL#ﾐﾡ!ﾦHﾍ??ﾇﾔL?Dﾸă? ﾞ?BﾂD?~??HgﾤKﾂ PWﾟﾽﾛ?ﾵ?>oLR+?쟰.ﾾ?w???ﾶ8Q???ﾀ??8&ﾠ/ﾌ?Ć??a?8/Wﾨﾥ?,tﾥP[tﾱ캁?Is.!??.7?BN?ﾨ?0\ﾂ%ﾎ>? }?!4?ﾃ'0?5ﾸ?xLﾀ؀Eﾸ?x^?4?Gﾬﾈ#ﾞ??+?<4ﾛ?ﾛﾰ<???ﾗz??ﾥﾛ?Dﾜxkﾞ??Fa'ﾌŜ -4ﾰg\ﾐ6z^°??ﾤ?yﾩ

I suspect it might be an encoding issue and I've tried different approaches but so far nothing. I haven't had much luck looking for similar situations online so any suggestions/recommendations/help would be appreciated

<?php 

session_start(); 
include 'conn.php'; 

if(empty($_SESSION['username']) || empty($_SESSION['password'])) 
    print("Access to database denied"); 
else { 
    $username = $_SESSION['username']; 
    $password = $_SESSION['password']; 
    $type = $_SESSION['type']; 

    if($type == "admin") { 
        include '../includes/aheader.html'; 
    } 
    if($type == "user") { 
        include '../includes/uheader.html'; 
    } 
    if(isset($_POST["searchButton"])) { 
        print_r($_POST);
        $keyword = $_POST['keyword']; 
        $choice = $_POST['choice'];

    if($choice == "company_name") 
        $sql = $mysqli -> prepare("SELECT * FROM clients WHERE company_name LIKE ?"); 

    if($choice == "project_code") 
        $sql = $mysqli -> prepare("SELECT * FROM clients WHERE project_code LIKE ?"); 

    $keyword = '%'.$keyword.'%'; 
    $sql -> bind_param('s', $keyword); 
    $sql -> execute(); 
    $result = $sql -> get_result(); 

        if(!$result) 
            print("<p>Select query failed</p>"); 
        else { 
            if($result -> num_rows == 0) 
            print("<p>No match found</p>");

        else {
            while($row = mysqli_fetch_array($result)) {
                $company_name = $row['0'];
                $phone = $row['1'];
                $address = $row['2'];
                $approximate_employees = $row['3'];
                $project_code = $row['4'];
                extract($row);
            }

            include_once('tbs_class.php');
            include_once('tbs_plugin_opentbs.php');

            $TBS = new clsTinyButStrong;
            $TBS -> Plugin(TBS_INSTALL, OPENTBS_PLUGIN);

            $TBS -> LoadTemplate('document.odt');
            $TBS -> Show(OPENTBS_FILE, 'document.odt');             

            $TBS -> MergeField('company_name', $company_name);
            $TBS -> MergeField('address', $address);
            $TBS -> MergeField('phone', $phone);

        }
    }
}
    else {
        include '../includes/searchForm.html';
        include '../includes/footer.html';
    }
}
$mysqli -> close();

?>

Answer 1

You have to merge fields before to render the result. And the result must be a file different from the template.

        $TBS = new clsTinyButStrong;
        $TBS -> Plugin(TBS_INSTALL, OPENTBS_PLUGIN);

        // Load the template
        $TBS -> LoadTemplate('document.odt');

        // Merge fields
        $TBS -> MergeField('company_name', $company_name);
        $TBS -> MergeField('address', $address);
        $TBS -> MergeField('phone', $phone);

        // Render the result
        $TBS -> Show(OPENTBS_FILE, 'document_result.odt');