[RESOLVED] PHP not printing my text

whobutsb

Hello,

I'm working on creating a article management system for my website and I ran into a little snafu. Every time I try to output my text on to a page it only prints about 1/2 of what is actually there.

My setup is I'am using MSSQL server and writing the body of the article in to a row set to text format. The way i'm writing to the database is I'am using the NicEdit plugin for font formatting and then I'm cleaning and inputting the text into the database using the following code:

$body = htmlspecialchars($body, ENT_QUOTES);
$query = mssql_query("INSERT INTO tbl (body) VALUES ('$body')");

Pretty straight forward. When I go in MS Visual Studio and copy the text it is all there. But when I output it using the following:

$body = htmlspecialchars_decode($body, ENT_QUOTES); 
		echo $body;

It only shows 1/2 of what is in the database. Has anyone else run into this problem before? am I missing something?

Horizon88

Try viewing your source code in the browser after the page has loaded. Is it possible the htmlspecialchars_decode is picking up a "<" somewhere and trying to output some of the text as HTML code, so you don't actually see the full text?

whobutsb

Nope it just unexpectedly ends. There is no HTML that seems to be throwing it off. I have even tried outputting the code with just a echo statement and it still gets cut off a the same place.

Very peculiar.

whobutsb

I figured out the problem. In the php.ini file the mssql.textlimit and mssql.textsize default settings are set to 4096 characters. I changed the default settings and the text is no longer being truncated. Just a quick FYI if anyone else experiences the same problem.