Categories > OpenTBS with DOCX >

Geberating the docx and updating mysql table

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Lily
Date: 2012-11-20
Time: 15:23

Geberating the docx and updating mysql table

Hi,

I am using the TBS for generating docx and works perfect. Now I need to update one mysql table when the docx file is open or save , actually to save the file name and the date to a mysql table. Is that possible?

When I use:
$sql_update=mysql_query("UPDATE tbl_issued SET issued_date='$date_title', file_name='$file_name' WHERE ag_id='$agid' ") or die("Unable to issue query sql_update: ".mysql_error()); 
I am getting corrupted docx file.

Thanks for your support!
Lily

By: Skrol29
Date: 2012-11-22
Time: 15:58

Re: Geberating the docx and updating mysql table

Hi, Lily,

If you are using OPENTBS_DOWNLOAD or OPENTBS_NOHEADER then any PHP notification is output with DOCX binary stream. Therefore it produces a corrupted DOCX file.
You can debug by activating the line  of code having the $TBS->Show(), and then have a look if you have any PHP notice coming from your SQL statement.