MySQL插入和更新查询在插入大数据时出错

Question

table structure:

id int(11)

bcontent longtext

when i run insert query through php if the data which is going to store in bcontent is small (2-3 lines paragraph) then that query runs successfully but when the size of that data is increases (10-11 lines paragraph) that query gives an error. is there problem with longtext data type? i also tried longblob but no change.

php code:

include("conn.php");
$bcontent = $_POST['bcontent'];
$query = mysql_query("insert into blocks (bcontent) values ('$bcontent')");
if($query)
{
//Success message 
}
else
{
//Error message
}

when the size of bcontent is large php throws //Error message.

i also increase the size of post_max_size to 200M in php.ini but no change.

Error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

actually it gives me an output which i coded in else condition

is there any error is my query or in table structure? please help me.

Answer 1

Your content probably contains quote characters, which you need to escape.

$bcontent = mysql_real_escape_string($_POST['bcontent']);