Doc to PDF with mssql

[Rafael Costa Pimenta]

Hi
someone knows how to convert a word .doc to a PDF using PHP?

and how to store and retrieve a .doc file in a mssql database?

[chris smith-9]

Rafael Costa Pimenta wrote:
> Hi
> someone knows how to convert a word .doc to a PDF using PHP?

There are external tools available to do it.

http://doc2pdf.sourceforge.net/overview.html is one such tool.

After installing it you exec the binary:

exec('pdf2doc blah blah');

where 'blah blah' is whatever pdf2doc tells you to put in.

> and how to store and retrieve a .doc file in a mssql database?

I searched for 'mssql binary data' and found this article:

http://www.databasejournal.com/features/mssql/article.php/1475641/Storing-and-Retrieving-Binary-Data-in-SQL-Server.htm

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Rafael Costa Pimenta]

But the link http://doc2pdf.sourceforge.net/overview.html seems to use
e-mail, i did not understand, I just want to extract a word .doc file from
the mssql database, save in a temp directory, convert to the PDF format and
let the user download the PDF file.

2009/11/3 Chris <dmagick@...>

> Rafael Costa Pimenta wrote:
>
>> Hi
>> someone knows how to convert a word .doc to a PDF using PHP?
>>
>
> There are external tools available to do it.
>
> http://doc2pdf.sourceforge.net/overview.html is one such tool.
>
> After installing it you exec the binary:
>
> exec('pdf2doc blah blah');
>
> where 'blah blah' is whatever pdf2doc tells you to put in.
>
>
>  and how to store and retrieve a .doc file in a mssql database?
>>
>
> I searched for 'mssql binary data' and found this article:
>
>
> http://www.databasejournal.com/features/mssql/article.php/1475641/Storing-and-Retrieving-Binary-Data-in-SQL-Server.htm
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>

--
Rafael Costa Pimenta
Analista de Sistemas
Fresenius Medical Care - RJ - Brasil
Tel. [phone] (Escritório central)

[chris smith-9]

Rafael Costa Pimenta wrote:
> But the link http://doc2pdf.sourceforge.net/overview.html seems to use
> e-mail, i did not understand, I just want to extract a word .doc file
> from the mssql database, save in a temp directory, convert to the PDF
> format and let the user download the PDF file.

There's a lot of stuff in there. Concentrate on each part separately and
don't worry about the next part just yet.

try http://www.phplivedocx.org/2009/02/06/convert-doc-to-pdf-in-php/ for
changing your doc to a pdf.

To get a doc in/out of mssql, there seems to be some magic you have to do:

http://www.webdeveloper.com/forum/archive/index.php/t-213799.html

If they don't work you're going to have to be more specific about what
you're having problems with.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[chris smith-9]

Chris wrote:

> Rafael Costa Pimenta wrote:
>> But the link http://doc2pdf.sourceforge.net/overview.html seems to use
>> e-mail, i did not understand, I just want to extract a word .doc file
>> from the mssql database, save in a temp directory, convert to the PDF
>> format and let the user download the PDF file.
>
> There's a lot of stuff in there. Concentrate on each part separately and
> don't worry about the next part just yet.
>
> try http://www.phplivedocx.org/2009/02/06/convert-doc-to-pdf-in-php/ for
> changing your doc to a pdf.
>
> To get a doc in/out of mssql, there seems to be some magic you have to do:
>
> http://www.webdeveloper.com/forum/archive/index.php/t-213799.html
>
> If they don't work you're going to have to be more specific about what
> you're having problems with.

See also http://www.rochester.edu/it/web/WebHelp/mssql/datatypes.html

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Philip Thompson-4]

On Nov 4, 2009, at 4:00 PM, Chris wrote:

> Chris wrote:
>> Rafael Costa Pimenta wrote:
>>> But the link http://doc2pdf.sourceforge.net/overview.html seems to  
>>> use e-mail, i did not understand, I just want to extract a  
>>> word .doc file from the mssql database, save in a temp directory,  
>>> convert to the PDF format and let the user download the PDF file.
>> There's a lot of stuff in there. Concentrate on each part  
>> separately and don't worry about the next part just yet.
>> try http://www.phplivedocx.org/2009/02/06/convert-doc-to-pdf-in- 
>> php/ for changing your doc to a pdf.
>> To get a doc in/out of mssql, there seems to be some magic you have  
>> to do:
>> http://www.webdeveloper.com/forum/archive/index.php/t-213799.html
>> If they don't work you're going to have to be more specific about  
>> what you're having problems with.
>
> See also http://www.rochester.edu/it/web/WebHelp/mssql/datatypes.html

Could you not just encode the doc file before putting it in the  
database. Decode it when you get it out.

http://php.net/base64_encode
http://php.net/base64_decode

Hope that helps.
~Philip


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php