Problem in retrieving Data from Database

suren

Whenever i am retreiving any information from database which contains huge info along with html tags..i am facing the problem to retrieve the entire data(from some point it is not retrieved) from the database.
i tried all the options still i am not able to retrieve.is there any restriction in php
wherein any variable can hold only small amount of data..if so what is solution for above problem to retrieve more data and display..

regards
surendra

rdhatt

I'm not aware of any restrictions - but I've never tried stuffing 1GB+ text into a PHP string var =).

Actually the first thing that comes to mind is not PHP, but MySQL. If the field types are not big enough to hold the data it would be truncated - for example if you put several paragraphs of text into a field of type 'tinytext' then only the first 255 chars would be stored. Then when you attempt to retrieve them, you would perience exactly the same thing as you are now. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#String_types for details.

suren

Thanks for reply
Data base used is MS SQL+Apache+PHP on NT, not mySql . and data retrieved is not in even in MB..
the same data is retrieved fully in a record using ASP Page. please help.
Best Regards
Surendra

mithril

Surendra,

You said the data in the db holds html tags and you're getting a truncated return when you try to print the data? Try applying the htmlspecialchars() function to the data you're retrieving from the db. Sounds like you may have a problem with the html tags contained within the db. The other option is that you may have characters stored in the db which are breaking you out of the string when you read them to PHP var. If this is the case, the addslashes() function should sove the problem. HTH,

Cheers,

Geoff A. Virgo

suren

Thanks Geoff,
i tried with both the methods, it is doing same. i observed the data returned is truncated one. see the below sample code.
But already data is there in MS SQL Databse which contains data along with HTML tags.e.g;
<p ALIGN="JUSTIFY"><b>Highlights</b> </p><ul> <li>High Availability – 24x7 </li> <li>Call Logging based on Standard Browsers </li> <li>Problem Categorisation </li> <li>Problem Prioritisation and Escalation </li> <li>Management of Problems based on Ques</li> <li>Call Logging based on some Data </li><li>Call Logging based on some Data2 </li><li>Call Logging based on some Data3 </li></ul>
after query with mssql_query("Query");
mssql_result($result,$i,"col name");
and try to dispaly, it is dispalyed as below,
Highlights
High Availability - 24x7
Call Logging based on Standard Browsers
Problem Categorisation
Problem Prioritisation and E ..
remainig data is truncated.
pls help
Best Regards
Surendra