dongyan2267 2014-06-26 10:28
浏览 151
已采纳

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

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.

  • 写回答

1条回答 默认 最新

  • doufenyu7610 2014-06-26 10:31
    关注

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

    $bcontent = mysql_real_escape_string($_POST['bcontent']);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 易语言把MYSQL数据库中的数据添加至组合框
  • ¥20 求数据集和代码#有偿答复
  • ¥15 关于下拉菜单选项关联的问题
  • ¥20 java-OJ-健康体检
  • ¥15 rs485的上拉下拉,不会对a-b<-200mv有影响吗,就是接受时,对判断逻辑0有影响吗
  • ¥15 使用phpstudy在云服务器上搭建个人网站
  • ¥15 应该如何判断含间隙的曲柄摇杆机构,轴与轴承是否发生了碰撞?
  • ¥15 vue3+express部署到nginx
  • ¥20 搭建pt1000三线制高精度测温电路
  • ¥15 使用Jdk8自带的算法,和Jdk11自带的加密结果会一样吗,不一样的话有什么解决方案,Jdk不能升级的情况