我也想贴出来,可是太长了,我想是否和配置的apache和php或IE浏览器有关?
解决方案 »
- PHP怎么读取压缩文件里面的文件啊
- 怎么让程序在循环内执行110秒然后重新执行剩余没有执行完的循环?
- 为什么filesize()无法返回值
- 求助获取百度搜索结果的数目
- SMARTY 表单数据缓存,急!
- 关于资源怎么样转成中文呢?
- 动态改变表格的TD属性
- 求一rewrite正则写法
- 在PHP中调用函数如: fdf_create(void);总是出现Call to undefined function: fdf_create() 哪个库定议了它?
- 这样找代码的思路对吗?
- 如果限制登陆用户???
- 以前从来没有遇到过的问题!什么是运行时间错误?郁闷中。。。。
解决的办法是检查待插入的记录是否存在
只有先判断记录相同的记录是否存在了,如果已存在就不要在写入了
判断记录相同的记录是否存在了还是提示已有记录。那位能否看看?
不够再加分!
<?
include ("dbconnect.inc");
$is_valid=1;
$is_free=1;
$is_new=0;$service_id=array();
$project=substr($project_id,0,3);if ($choiceid !="") {
$num1=explode(",",$choiceid);
//-----项目的开通情况开始;
echo "num1===" . sizeof($num1) . "\n";
for ($j=0;$j<sizeof($num1);$j++)
{
$k=0;
$Tocode=substr($project_id,0,2).$num1[$j];$str=substr($project_id,3,2);$Tocode=$Tocode.$str; $str="SELECT service_id FROM info_type WHERE Tocode='$Tocode'"; $Service_Result=mssql_query($str);//开始查询 while($service=mssql_fetch_array( $Service_Result)) {
$service_id[$j]=$service[service_id];
$k++;
}
if ($k==0) {
echo "<script>alert('对不起,此项目还有开通,请重新选择项目!')</script>"; echo "<script>history.go(-1)</script>";
return ;
} }//end for
echo "<br><center><TABLE WIDTH=97% BGCOLOR=#f4fbff BORDERCOLORdark=#ffffff
BORDERCOLORlight=#cfdbff BORDER=1 CELLSPACING=1 CELLPADDING=0>";
echo "<TR>";
echo "<TD bordercolorlight=#c0c0c0 width=74 height=38 align=center><span style='COLOR: rgb(0,0,255); FONT-SIZE: 10pt'><font face=Wingdings>v</font></span> 手机号</TD>";
echo "<TD bordercolorlight=#c0c0c0 width=100 align=center><span style='COLOR: rgb(0,0,255); FONT-SIZE: 10pt'><font face=Wingdings>v</font></span> 项 目</TD>";
echo "<TD bordercolorlight=#c0c0c0 width=150 align=center><span style='COLOR: rgb(0,0,255); FONT-SIZE: 10pt'><font face=Wingdings>v</font></span> 点 播 格 式</TD>";
echo "<TD bordercolorlight=#c0c0c0 width=150 align=center><span style='COLOR: rgb(0,0,255); FONT-SIZE: 10pt'><font face=Wingdings>v</font></span> 收 费 标 准</TD>";
echo "<TD bordercolorlight=#c0c0c0 width=72 align=center><span style='COLOR: rgb(0,0,255); FONT-SIZE: 10pt'><font face=Wingdings>v</font></span>订阅状况</TD>";
echo "</TR>"; $month_str=substr($project_id,0,2);$str=substr($month_fee,0,1);$project=$month_str.$str;
$length=strlen(trim($month_fee));$str=substr($month_fee,1,$length);$month_fee=$str; $str="SELECT project_id FROM Project_info WHERE Project_id='$project'"; $database->query($str);//开始查询 if ($database->next_record()==1) { $project=$database->Record["project_id"];
}
else {
echo "<script>alert('对不起,此项目还未开通,请重新选择项目!')</script>";
echo "<script>history.go(-1)</script>";
return ;
} //选择的记录有没有重复 for ($j=0;$j<sizeof($num1);$j++)
{
$Tocode=substr($project_id,0,2).$num1[$j];$str=substr($project_id,3,2);$Tocode=$Tocode.$str; $str="SELECT Tocode,Mobile_id,Service_id,Operid ".
"FROM Project_send WHERE Tocode='$Tocode' AND Mobile_id='$mobile_id' ".
" AND Is_valid <>'2'"; $database->query($str);
if ($database->next_record() !=0)
//if ( $database->Row !=0)
{
echo "<script>alert('对不起,此记录已存在')</script>";
echo "<script>window.location='../right4_by.php'</script>";
return ;
} } //检查是否是新用户
$str="SELECT Tocode,Mobile_id,Service_id,Operid ".
"FROM Project_send WHERE Mobile_id='$mobile_id' "; $database->query($str); if ($database->next_record()==1) $is_new=1; if ($Tocode=='0959758000' ) $is_free=0; //insert 用户包月 (新记录)
for ($j=0;$j<sizeof($num1);$j++)
{ $Tocode=substr($project_id,0,2).$num1[$j];$str=substr($project_id,3,2);$Tocode=$Tocode.$str; $str="INSERT INTO Project_send (Tocode,Project_id,Mobile_id,Service_id,Month_fee,Is_valid,".
"Is_free,Operid,is_new) VALUES ('$Tocode','$project','$mobile_id','$service_id[$j]',$month_fee,".
"$is_valid,$is_free,'$operid','$is_new')"; $database->query($str); $str="INSERT INTO Team_user (mobile_id,team_id) VALUES ('$mobile_id','$Tocode')"; $database->query($str); $str="SELECT Team_id FROM Team_user WHERE Team_id='9999999999' and Mobile_id='$mobile_id'" ; $database->query($str);
if ($database->next_record() !=1) {
$str="INSERT INTO Team_user (mobile_id,team_id) VALUES ('$mobile_id','9999999999')";
$database->query($str);
}
$str="SELECT profile FROM Tocode_profile WHERE Tocode='$Tocode'"; $database->query($str); echo "<tr><TD bordercolorlight=#c0c0c0 height=38 align=center>".$mobile_id."</td>";
if ($database->next_record()==1) {
echo "<TD bordercolorlight=#c0c0c0 height=38 align=center>".$database->Record[0]."</td>";
$profile=$database->Record[0];
}
else return ;
$str="SELECT Top 1 profile FROM Info_type WHERE Tocode='$Tocode'";
$database->query($str);
if ($database->next_record()) {
echo "<TD bordercolorlight=#c0c0c0 height=38 align=center>".$database->Record[0]."</td>"; }
else return ; $str="SELECT Profile FROM Project_info WHERE Project_id='$project'";
$database->query($str);
if ($database->next_record()==1) {
echo "<TD bordercolorlight=#c0c0c0 height=38 align=center>".$database->Record[0]."</td>";
$fee=$database->Record[0];
}
else return ;
echo "<TD bordercolorlight=#c0c0c0 height=38 align=center><font color=red>成 功!</font></TD></tr>";
// INSERT Oper_log 表
if ($Tocode=='0959758000' ) {
$str="INSERT INTO Oper_log (Operid,Type,Mobile_id,Project_id) ".
"VALUES ('$operid','1258个性化订阅重要天气预报','$mobile_id','$profile')"; $database->query($str);
$profile="祝贺您订阅个性化重要天气系统预报项目成功,当有热带气旋、冷空气等重要天气系统影响本省时,您会收到最新气象预报资料(每次发送0.3元)" ; $str="exec sms_submit @Service_id='important',@Dest_terminal_id=$mobile_id,".
"@Msg_content='$profile',@Why='Y' ";
$database->query($str);
$str="SELECT Msg_cont FROM Info_data WHERE Tocode='$Tocode' and GETDATE()-uptime >=0 and GETDATE()-uptime <=1 ";
$database->query($str);
if ($database->next_record()==1) {
$content=$database->Record[0];
$str="exec sms_submit @Service_id='important',@Dest_terminal_id=$mobile_id,".
"@Msg_content='$content',@Why='Y' ";
$database->query($str);
}
}
else {
$str="INSERT INTO Oper_log (Operid,Type,Mobile_id,Project_id) ".
"VALUES ('$operid','1258包月订阅','$mobile_id','$profile')";
$database->query($str);
$profile="祝贺您包月订阅".$profile."项目成功".$fee ;
$str="exec sms_submit @Service_id='$service_id[$j]',@Dest_terminal_id=$mobile_id,".
"@Msg_content='$profile',@Why='Y' "; $database->query($str); $str="SELECT Msg_cont FROM Info_data WHERE Tocode='$Tocode' ";
$database->query($str);
if ($database->next_record()==1) {
$content=$database->Record[0];
$str="exec sms_submit @Service_id='$service_id[$j]',@Dest_terminal_id=$mobile_id,".
"@Msg_content='$content',@Why='Y' ";
$database->query($str);
}//发报内容结束
}//end else Tocode='0959758000'
}//end for
echo "</table></center>";
}
else return;
mssql_close();
?>
if($ifsubmit=="1"){
echo "您已经提交过数据,请返回。";}
else{
mysql_query($sql);
$ifsubmit=1;}
这与ie一点关系都没有,ie是死的,程序是人写的。
谢谢各位,结贴。