query(iconv('UTF-8', 'UTF-8', $kc_sql));
//单击【更新】按钮
if(@$_POST["a"] == '更新')
{
if(!empty($KCM)and(!empty($XKCM)or!empty($XF)or!empty($XS)))
{
if($result->rowCount() != 0)
{
if(!empty($XS))$update_sql = "update kc set xs='$XS' where kcm ='$KCM'";
if(!empty($XF))$update_sql = "update kc set xf='$XF' where kcm ='$KCM'";
if(!empty($XKCM))$update_sql = "update kc set kcm='$XKCM' where kcm ='$KCM'";
if(!empty($XS)and!empty($XF))$update_sql = "update kc set xs='$XS',xf='$XF' where kcm ='$KCM'";
if(!empty($XS)and!empty($XKCM))$update_sql = "update kc set xs='$XS',kcm='$XKCM' where kcm ='$KCM'";
if(!empty($XKCM)and!empty($XF))$update_sql = "update kc set kcm='$XKCM',xf='$XF' where kcm ='$KCM'";
if(!empty($XKCM)and!empty($XF)and!empty($XS))$update_sql = "update kc set kcm='$XKCM',xs='$XS',xf='$XF' where kcm ='$KCM'";
$update_result = $db->query(iconv('UTF-8', 'UTF-8', $update_sql));
if($update_result->rowCount() != 0)
{
if(!empty($XF)){$s2="call update_xs()";$s3=$db->query(iconv('UTF-8', 'UTF-8', $s2));}
if(!empty($XKCM)){$s2="call update_cj('$KCM','$XKCM')";$s3=$db->query(iconv('UTF-8', 'UTF-8', $s2));}
echo "";
}
else
echo "";
}
else
echo "";//存在才可以更新
}
else
echo"";
}
//单击【录入】按钮
if(@$_POST["a"] == '录入')
{
if(!empty($KCM)and!empty($XS)and!empty($XF)){
if($result->rowCount() != 0)
echo "";
else{
$insert_sql = "insert into kc values('$KCM', '$XS', '$XF')";
$insert_result = $db->query(iconv('UTF-8', 'UTF-8', $insert_sql));
if($insert_result->rowCount() != 0)
echo "";
else
echo "";
}}
else echo"";
}
//单击【删除】按钮
if(@$_POST["a"] == '删除')
{
if(!empty($KCM))
{
if($result->rowCount() != 0)
{
$delete_sql = "delete from kc,xmcj_view where kcm ='$KCM'";
$del_affected = $db->exec(iconv('UTF-8', 'UTF-8', $delete_sql));
$s2="call delete_cj1('$KCM')";
$s3=$db->query(iconv('UTF-8', 'UTF-8', $s2));
$s2="call update_xs()";
$s3=$db->query(iconv('UTF-8', 'UTF-8', $s2));
if($del_affected)
echo "";
else
echo "";
}
else
echo "";
}
else
echo "";
}
?>