调出来看，发现$s语句被截取了，不完整！象超长，怎么办？
我把：php.ini中设置了
mssql.textlimit =2147483000
mssql.textsize =2147483000
也不行，不知怎么解决？
是ini中有什么参数要设置？还是采取其他方法插入记录，用什么方法？？？？？
8 个解决方案
#1
你是用echo $s来看的吗?
如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题.
如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题.
#2
应该是字符串超长，因为我把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作为参数传入执行
$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作为参数传入执行
#3
你用addslashes($url)然后输入看看有没被截取，如果没可能你的语句中有问题。
要不你再用'insert into a values(.....)';试试。
#4
我发现是因为后面的变量不存在！
post是否有限制？？导致从$flhzb_jh_1后面的变量都没有？
post是否有限制？？导致从$flhzb_jh_1后面的变量都没有？
#5
晕，真的很长呀。。。。。。。。。。。。。。。
但应该不是超长的吧。你可以每个字段试试。看看不是字符出错
但应该不是超长的吧。你可以每个字段试试。看看不是字符出错
#6
乖乖，真么长。
不会是超长的。慢慢检查吧，祝你好运
不会是超长的。慢慢检查吧，祝你好运
#7
试试 $sql = "insert into jy_zxqk set fareaid='$fareaid',fssdwid='$fssdwid', ......
#8
不如insert几个少的？然后update
好像是个馊主意
不过为了检查错误，还是可行的哦
好像是个馊主意
不过为了检查错误，还是可行的哦
#1
你是用echo $s来看的吗?
如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题.
如果是这样$s语句被截断那应该是你程序有问题导致$s不完整,而不是SQL超长的问题.
#2
应该是字符串超长，因为我把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作为参数传入执行
$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作为参数传入执行
#3
你用addslashes($url)然后输入看看有没被截取，如果没可能你的语句中有问题。
要不你再用'insert into a values(.....)';试试。
#4
我发现是因为后面的变量不存在！
post是否有限制？？导致从$flhzb_jh_1后面的变量都没有？
post是否有限制？？导致从$flhzb_jh_1后面的变量都没有？
#5
晕，真的很长呀。。。。。。。。。。。。。。。
但应该不是超长的吧。你可以每个字段试试。看看不是字符出错
但应该不是超长的吧。你可以每个字段试试。看看不是字符出错
#6
乖乖，真么长。
不会是超长的。慢慢检查吧，祝你好运
不会是超长的。慢慢检查吧，祝你好运
#7
试试 $sql = "insert into jy_zxqk set fareaid='$fareaid',fssdwid='$fssdwid', ......
#8
不如insert几个少的？然后update
好像是个馊主意
不过为了检查错误，还是可行的哦
好像是个馊主意
不过为了检查错误，还是可行的哦