|
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.
|