数据库的表中字段太多,用insert into语句插入值,字符串超长,怎么办?? 你是用echo $s来看的吗?如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 应该是字符串超长,因为我把sql字符串注释掉一部分,就可以!我的赋值语句如下:$sql = "insert into jy_zxqk(fareaid,fssdwid,fxmid,ftbrq,ftbr,fczrq,fczr,fxmlb,fssdwmc,fxmmc,ffzr,flxdh,fzxxs,fzzjzg, fzjsy_hj_1,fzjsy_hj_2,fzjsy_hj_3,fzjsy_hj_4,fzjsy_hj_5,fzjsy_hj_6,fzjsy_hj_7,fzjsy_hj_8,fzjsy_hj_9,fzjsy_hj_10,fzjsy_hj_11,fzjsy_hj_12,fzjsy_hj_13,fzjsy_hj_14, fzjsy_zy_1,fzjsy_zy_2,fzjsy_zy_3,fzjsy_zy_4,fzjsy_zy_5,fzjsy_zy_6,fzjsy_zy_7,fzjsy_zy_8,fzjsy_zy_9,fzjsy_zy_10,fzjsy_zy_11,fzjsy_zy_12,fzjsy_zy_13,fzjsy_zy_14, fzjsy_s_1,fzjsy_s_2,fzjsy_s_3,fzjsy_s_4,fzjsy_s_5,fzjsy_s_6,fzjsy_s_7,fzjsy_s_8,fzjsy_s_9,fzjsy_s_10,fzjsy_s_11,fzjsy_s_12,fzjsy_s_13,fzjsy_s_14, fzjsy_d_1,fzjsy_d_2,fzjsy_d_3,fzjsy_d_4,fzjsy_d_5,fzjsy_d_6,fzjsy_d_7,fzjsy_d_8,fzjsy_d_9,fzjsy_d_10,fzjsy_d_11,fzjsy_d_12,fzjsy_d_13,fzjsy_d_14, fzjsy_x_1,fzjsy_x_2,fzjsy_x_3,fzjsy_x_4,fzjsy_x_5,fzjsy_x_6,fzjsy_x_7,fzjsy_x_8,fzjsy_x_9,fzjsy_x_10,fzjsy_x_11,fzjsy_x_12,fzjsy_x_13,fzjsy_x_14, fzjsy_qt_1,fzjsy_qt_2,fzjsy_qt_3,fzjsy_qt_4,fzjsy_qt_5,fzjsy_qt_6,fzjsy_qt_7,fzjsy_qt_8,fzjsy_qt_9,fzjsy_qt_10,fzjsy_qt_11,fzjsy_qt_12,fzjsy_qt_13,fzjsy_qt_14, fkgrq,fwgrq,fysrq,ftyrq,fxmjzqk, flhzb_jh_1,flhzb_jh_2,flhzb_jh_3,flhzb_jh_4,flhzb_jh_5,flhzb_jh_6,flhzb_jh_7,flhzb_jh_8,flhzb_jh_9,flhzb_jh_10,flhzb_jh_11, flhzb_sj_1,flhzb_sj_2,flhzb_sj_3,flhzb_sj_4,flhzb_sj_5,flhzb_sj_6,flhzb_sj_7,flhzb_sj_8,flhzb_sj_9,flhzb_sj_10,flhzb_sj_11,fbz) values('$fareaid','$fssdwid','$fxmid',convert(datetime,'$ftbrq',120),'$ftbr',convert(datetime,'$fczrq',120),'$fczr','$fxmlb','$fssdwmc','$fxmmc','$ffzr','$flxdh','$fzxxs','$fzzjzg','$fzjsy_hj_1','$fzjsy_hj_2','$fzjsy_hj_3','$fzjsy_hj_4','$fzjsy_hj_5','$fzjsy_hj_6','$fzjsy_hj_7','$fzjsy_hj_8','$fzjsy_hj_9','$fzjsy_hj_10','$fzjsy_hj_11','$fzjsy_hj_12','$fzjsy_hj_13','$fzjsy_hj_14','$fzjsy_zy_1','$fzjsy_zy_2','$fzjsy_zy_3','$fzjsy_zy_4','$fzjsy_zy_5','$fzjsy_zy_6','$fzjsy_zy_7','$fzjsy_zy_8','$fzjsy_zy_9','$fzjsy_zy_10','$fzjsy_zy_11','$fzjsy_zy_12','$fzjsy_zy_13','$fzjsy_zy_14','$fzjsy_s_1','$fzjsy_s_2','$fzjsy_s_3','$fzjsy_s_4','$fzjsy_s_5','$fzjsy_s_6','$fzjsy_s_7','$fzjsy_s_8','$fzjsy_s_9','$fzjsy_s_10','$fzjsy_s_11','$fzjsy_s_12','$fzjsy_s_13','$fzjsy_s_14','$fzjsy_d_1','$fzjsy_d_2','$fzjsy_d_3','$fzjsy_d_4','$fzjsy_d_5','$fzjsy_d_6','$fzjsy_d_7','$fzjsy_d_8','$fzjsy_d_9','$fzjsy_d_10','$fzjsy_d_11','$fzjsy_d_12','$fzjsy_d_13','$fzjsy_d_14','$fzjsy_x_1','$fzjsy_x_2','$fzjsy_x_3','$fzjsy_x_4','$fzjsy_x_5','$fzjsy_x_6','$fzjsy_x_7','$fzjsy_x_8','$fzjsy_x_9','$fzjsy_x_10','$fzjsy_x_11','$fzjsy_x_12','$fzjsy_x_13','$fzjsy_x_14','$fzjsy_qt_1','$fzjsy_qt_2','$fzjsy_qt_3','$fzjsy_qt_4','$fzjsy_qt_5','$fzjsy_qt_6','$fzjsy_qt_7','$fzjsy_qt_8','$fzjsy_qt_9','$fzjsy_qt_10','$fzjsy_qt_11','$fzjsy_qt_12','$fzjsy_qt_13','$fzjsy_qt_14',";$sql.="convert(datetime,'$fkgrq',120),convert(datetime,'$fwgrq',120),convert(datetime,'$fysrq',120),convert(datetime,'$ftyrq',120)','$fxmjzqk','$flhzb_jh_1','$flhzb_jh_2','$flhzb_jh_3','$flhzb_jh_4','$flhzb_jh_5','$flhzb_jh_6','$flhzb_jh_7','$flhzb_jh_8','$flhzb_jh_9','$flhzb_jh_10','$flhzb_jh_11','$flhzb_sj_1','$flhzb_sj_2','$flhzb_sj_3','$flhzb_sj_4','$flhzb_sj_5','$flhzb_sj_6','$flhzb_sj_7','$flhzb_sj_8','$flhzb_sj_9','$flhzb_sj_10','$flhzb_sj_11,'$fbz')";然后把$sql作为参数传入执行 你用addslashes($url)然后输入看看有没被截取,如果没可能你的语句中有问题。要不你再用'insert into a values(.....)';试试。 我发现是因为后面的变量不存在!post是否有限制??导致从$flhzb_jh_1后面的变量都没有? 试试 $sql = "insert into jy_zxqk set fareaid='$fareaid',fssdwid='$fssdwid', ...... 不如insert几个少的?然后update好像是个馊主意不过为了检查错误,还是可行的哦 【求助】留言板删除后如何自动刷新页面? 如何在php或ASP中生成报表 怎么实现PHP代码和html代码100%分离 dedecms 中的sys_info.php的问题 PHP thinkphp框架中系统内存溢出 关于php的一点点理解,希望得到大虾门帮助,进者有分啊. PHP中怎么用SQL把一些数据资料导出到本地电脑呢 后退到用户登陆的提交页面后总是显示“网页已经过期”这个怎么解决?谢谢 php 数组转换字符串函数, 我用thinkphp ,json_encode保存中文,反斜杠消失了 图片上传到数据度的问题??高手都来。 求解高分简单问题!在线等答案!快快快
$sql = "insert into jy_zxqk(fareaid,fssdwid,fxmid,ftbrq,ftbr,fczrq,fczr,fxmlb,fssdwmc,fxmmc,ffzr,flxdh,fzxxs,fzzjzg,
fzjsy_hj_1,fzjsy_hj_2,fzjsy_hj_3,fzjsy_hj_4,fzjsy_hj_5,fzjsy_hj_6,fzjsy_hj_7,fzjsy_hj_8,fzjsy_hj_9,fzjsy_hj_10,fzjsy_hj_11,fzjsy_hj_12,fzjsy_hj_13,fzjsy_hj_14,
fzjsy_zy_1,fzjsy_zy_2,fzjsy_zy_3,fzjsy_zy_4,fzjsy_zy_5,fzjsy_zy_6,fzjsy_zy_7,fzjsy_zy_8,fzjsy_zy_9,fzjsy_zy_10,fzjsy_zy_11,fzjsy_zy_12,fzjsy_zy_13,fzjsy_zy_14,
fzjsy_s_1,fzjsy_s_2,fzjsy_s_3,fzjsy_s_4,fzjsy_s_5,fzjsy_s_6,fzjsy_s_7,fzjsy_s_8,fzjsy_s_9,fzjsy_s_10,fzjsy_s_11,fzjsy_s_12,fzjsy_s_13,fzjsy_s_14,
fzjsy_d_1,fzjsy_d_2,fzjsy_d_3,fzjsy_d_4,fzjsy_d_5,fzjsy_d_6,fzjsy_d_7,fzjsy_d_8,fzjsy_d_9,fzjsy_d_10,fzjsy_d_11,fzjsy_d_12,fzjsy_d_13,fzjsy_d_14,
fzjsy_x_1,fzjsy_x_2,fzjsy_x_3,fzjsy_x_4,fzjsy_x_5,fzjsy_x_6,fzjsy_x_7,fzjsy_x_8,fzjsy_x_9,fzjsy_x_10,fzjsy_x_11,fzjsy_x_12,fzjsy_x_13,fzjsy_x_14,
fzjsy_qt_1,fzjsy_qt_2,fzjsy_qt_3,fzjsy_qt_4,fzjsy_qt_5,fzjsy_qt_6,fzjsy_qt_7,fzjsy_qt_8,fzjsy_qt_9,fzjsy_qt_10,fzjsy_qt_11,fzjsy_qt_12,fzjsy_qt_13,fzjsy_qt_14,
fkgrq,fwgrq,fysrq,ftyrq,fxmjzqk,
flhzb_jh_1,flhzb_jh_2,flhzb_jh_3,flhzb_jh_4,flhzb_jh_5,flhzb_jh_6,flhzb_jh_7,flhzb_jh_8,flhzb_jh_9,flhzb_jh_10,flhzb_jh_11,
flhzb_sj_1,flhzb_sj_2,flhzb_sj_3,flhzb_sj_4,flhzb_sj_5,flhzb_sj_6,flhzb_sj_7,flhzb_sj_8,flhzb_sj_9,flhzb_sj_10,flhzb_sj_11,fbz)
values('$fareaid','$fssdwid','$fxmid',convert(datetime,'$ftbrq',120),'$ftbr',convert(datetime,'$fczrq',120),'$fczr','$fxmlb','$fssdwmc','$fxmmc','$ffzr','$flxdh','$fzxxs','$fzzjzg',
'$fzjsy_hj_1','$fzjsy_hj_2','$fzjsy_hj_3','$fzjsy_hj_4','$fzjsy_hj_5','$fzjsy_hj_6','$fzjsy_hj_7','$fzjsy_hj_8','$fzjsy_hj_9','$fzjsy_hj_10','$fzjsy_hj_11','$fzjsy_hj_12','$fzjsy_hj_13','$fzjsy_hj_14',
'$fzjsy_zy_1','$fzjsy_zy_2','$fzjsy_zy_3','$fzjsy_zy_4','$fzjsy_zy_5','$fzjsy_zy_6','$fzjsy_zy_7','$fzjsy_zy_8','$fzjsy_zy_9','$fzjsy_zy_10','$fzjsy_zy_11','$fzjsy_zy_12','$fzjsy_zy_13','$fzjsy_zy_14',
'$fzjsy_s_1','$fzjsy_s_2','$fzjsy_s_3','$fzjsy_s_4','$fzjsy_s_5','$fzjsy_s_6','$fzjsy_s_7','$fzjsy_s_8','$fzjsy_s_9','$fzjsy_s_10','$fzjsy_s_11','$fzjsy_s_12','$fzjsy_s_13','$fzjsy_s_14',
'$fzjsy_d_1','$fzjsy_d_2','$fzjsy_d_3','$fzjsy_d_4','$fzjsy_d_5','$fzjsy_d_6','$fzjsy_d_7','$fzjsy_d_8','$fzjsy_d_9','$fzjsy_d_10','$fzjsy_d_11','$fzjsy_d_12','$fzjsy_d_13','$fzjsy_d_14',
'$fzjsy_x_1','$fzjsy_x_2','$fzjsy_x_3','$fzjsy_x_4','$fzjsy_x_5','$fzjsy_x_6','$fzjsy_x_7','$fzjsy_x_8','$fzjsy_x_9','$fzjsy_x_10','$fzjsy_x_11','$fzjsy_x_12','$fzjsy_x_13','$fzjsy_x_14',
'$fzjsy_qt_1','$fzjsy_qt_2','$fzjsy_qt_3','$fzjsy_qt_4','$fzjsy_qt_5','$fzjsy_qt_6','$fzjsy_qt_7','$fzjsy_qt_8','$fzjsy_qt_9','$fzjsy_qt_10','$fzjsy_qt_11','$fzjsy_qt_12','$fzjsy_qt_13','$fzjsy_qt_14',";$sql.="convert(datetime,'$fkgrq',120),convert(datetime,'$fwgrq',120),convert(datetime,'$fysrq',120),convert(datetime,'$ftyrq',120)','$fxmjzqk','$flhzb_jh_1','$flhzb_jh_2','$flhzb_jh_3','$flhzb_jh_4','$flhzb_jh_5','$flhzb_jh_6','$flhzb_jh_7','$flhzb_jh_8','$flhzb_jh_9','$flhzb_jh_10','$flhzb_jh_11','$flhzb_sj_1','$flhzb_sj_2','$flhzb_sj_3','$flhzb_sj_4','$flhzb_sj_5','$flhzb_sj_6','$flhzb_sj_7','$flhzb_sj_8','$flhzb_sj_9','$flhzb_sj_10','$flhzb_sj_11,'$fbz')";然后把$sql作为参数传入执行
你用addslashes($url)然后输入看看有没被截取,如果没可能你的语句中有问题。要不你再用'insert into a values(.....)';试试。
post是否有限制??导致从$flhzb_jh_1后面的变量都没有?
好像是个馊主意
不过为了检查错误,还是可行的哦