Retrieving a PDF file from a MSSQL data base with php
Posted on 2003-03-01
Here my code:
//connect data base and select the table....
$SQuery = "select len,pdfdata from PDFTable where nid = 34"
// the entry exist
// fetch the only row
$row = mssql_fecth_row($SQuery);
The script launch the PDF program, but it remains in the list of process getting the 100% of the CPU.
I think that the data are not completed, due to when i delete the headers lines, the binary code appears into the browser, but is not complete!!!, i think only it show 4096 bytes of the file instead of the 65470 of its real lenght.....
I did the same test using ASP .NET and the code, similar from the above works fine, but i need make it in PHP.
Any limitations?, any wrong in the php code? or maybe this language script is not ready to work with MSSQL Server?.
Thank´s in advantage.