Doc to PDF with mssql

Doc to PDF with mssql

am 03.11.2009 13:03:48 von Rafael Costa Pimenta

--00c09f95562a6cd76204777649a0
Content-Type: text/plain; charset=ISO-8859-1

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?

--00c09f95562a6cd76204777649a0--

Re: Doc to PDF with mssql

am 03.11.2009 23:01:33 von 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/14 75641/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

Re: Doc to PDF with mssql

am 04.11.2009 11:28:21 von Rafael Costa Pimenta

--000e0cdfc512ed1f8d0477891185
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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

> 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/14 75641/Storing=
-and-Retrieving-Binary-Data-in-SQL-Server.htm
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
>


--=20
Rafael Costa Pimenta
Analista de Sistemas
Fresenius Medical Care - RJ - Brasil
Tel. 55 21 2179-2484 (Escrit=F3rio central)

--000e0cdfc512ed1f8d0477891185--

Re: Doc to PDF with mssql

am 04.11.2009 23:00:21 von dmagick

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

Re: Doc to PDF with mssql

am 04.11.2009 23:00:56 von dmagick

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

Re: Doc to PDF with mssql

am 08.11.2009 07:56:52 von Philip Thompson

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