Posting lots of text to MySQL?

jonnyboy

I have a forum on my site, where there now appears to be a limit on how much text I can post from a textarea to a MySQL field. The field is set as LONGTEXT. I have experimented with changing it to BLOB and LONGBLOB, but it still doesn't seem to work.

Should it work and is it safe to do on an existing table?

Thanks

Jon

bad76

Hi,
i think you must verify the max lenght for post operation on your server...

Mine is post_max_size = 8M

Norman_Graham

How are you inserting the text, and how long is your longest example?

Norm

bad76

Sorry,
i haven't a forum or other. Just post simple form.
The 8M is default setting by easyphp.

P.S:I've forgotten to say that param is in php.ini

jonnyboy

Thanks for your help...

This is how I am curently posting the text:-

<br>
Message Subject:
<br>
<input type="text" name="message_title" size="60" maxlength="60" />
<br>
Message Body:
<br>
<textarea name="message_text" rows="15" cols="69" wrap="physical"></textarea>
<br>
<input type="hidden" name="message_ip" value="<?php echo $REMOTE_ADDR; ?>" />
<input type="hidden" name="dept_key" value="RE">
<br>

<font color="red"<b><center> All fields must be completed for the message to post </center></b></p>

<?php
}
else
{
if (!($connection = @ mysql_connect($hostname,
$username,
$password)))
die("Could not connect to database");

if (!mysql_select_db("intranet", $connection))
showerror();

$insertQuery = "INSERT INTO stop_press VALUES
(NULL, " .
"\"" . $dept_key ."\", " .
"\"" . $message_creator ."\", " .
"\"" . $message_title ."\", " .
"\"" . $message_text ."\", " .
"\"" . $message_ip ."\", " .
"NOW())";

if ((@ ($insertQuery,
$connection))
&& @ mysql_affected_rows() == 1)

echo '<h5>Message posted successfully - Thank you</h5>';
else
showerror();
}//if else empty()
?>

Norman_Graham

Originally posted by jonnyboy

$insertQuery = "INSERT INTO stop_press VALUES
               (NULL, " .
			    "\"" . $dept_key ."\", " .
			   "\"" . $message_creator ."\", " .
			   "\"" . $message_title ."\", " .
			   "\"" . $message_text ."\", " .
			   "\"" . $message_ip ."\", " .
			   "NOW())";

What is this??? Try:

$insertQuery = ("INSERT INTO stop_press VALUES (NULL, '$dept_key', '$message_creator', ...)");

Best o luck

Norm

jonnyboy

I have changed the field to BLOB...Doesn't seem to make a difference. I have found that I can paste 1863 characters. The form will just not post any more than that.

I have changes the UPDATE code as advised.

Thanks for your help so far...

Norman_Graham

Don't know the answer to this one. I certainly have no such problems.

CAN ANYONE HELP HERE?

Norm