I've created a MySQL database to store a large amount of text. Since
the text data type in MySQL is limited to 255 characters, I added a
BLOB column. I created an PHP input screen to enter the large text.
It seems to work. But, I cannot verify the entry, because the
standard select SQL does not display the contents. I want to
retrieve the contents from the database and display on a web page.
The retrieval seems to occur. But, I can't display the results,
because I must not be done the proper conversion from BLOB to ordinary
text.
Can somebody help me resolve this problem?
Here is the insert code I'm using.
$newtext = addslashes($blob);
@ $db = mysql_connect('localhost', '<database>', '<password>');
if (!$db)
{
echo "Error: Could not connect to database. Please try again
later.";
exit;
}
mysql_select_db("<database>");
$query = "insert into blog values ('$newtext')";
$result = mysql_query($query);
if ($result)
{
echo mysql_affected_rows()." text item inserted into
database.";
}
Here is the retrieval code I'm using.
$query = "select blogtext from blog";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$blog = $row['blogtext'];
$wraptext = wordwrap($blog, 80, "\n", 1);
echo $wraptext;
}
It displays nothing on my page.
Thanks in advance.
