dbQuery($delete_sql,"otcxjcom");
$delete=n;
}
if ($update==y && $id){ //修改记录操作
if(is_uploaded_file($upfile) && strtolower(substr($upfile_name,strrpos($upfile_name,'.'),4))==".jpg"){ #判断上传文件的合法性
$ImageName=time();
@copy($upfile,"images/".$ImageName.".jpg"); //将文件实际的存放在服务器上
chmod("images/".$ImageName.".jpg", 0755);
$update_sql="update onlinechina set Name='$Name', Telephone='$Telephone', Email='$Email', Address='$Address', Hotel='$Hotel', Number='$Number', Route='$Route', Temp='$Temp', TbnCounter='$TbnCounter', TbnUpdUser='$s_username', TbnUpdTime='$now_time' where TbnId=$id";
}else{
$update_sql="update onlinechina set Name='$Name', Telephone='$Telephone', Email='$Email', Address='$Address', Hotel='$Hotel', Number='$Number', Route='$Route', Temp='$Temp', TbnCounter='$TbnCounter', TbnUpdUser='$s_username', TbnUpdTime='$now_time' where TbnId=$id";
}
$update_rt=$db->dbQuery($update_sql,"otcxjcom");
$update=n;
}
if(isset($submit1)&& $Name!=""){ // 判断是否是再次调入
if(is_uploaded_file($upfile) && strtolower(substr($upfile_name,strrpos($upfile_name,'.'),4))==".jpg"){ #判断上传文件的合法性
$ImageName=time();
@copy($upfile,"images/".$ImageName.".jpg"); //将文件实际的存放在服务器上
chmod("images/".$ImageName.".jpg", 0755);
}
$sql="INSERT INTO onlinechina (Name, Telephone, Email, Address, Hotel, Number, Route, Temp, TbnCounter, TbnInsUser, TbnInsTime) VALUES ('$Name', '$Telephone', '$Email', '$Address', '$Hotel', '$Number', '$Route', '$Temp', '$TbnCounter', '$s_username', '$now_time')";
if($rt=$db->dbIo($sql,"otcxjcom")){
?>
dbQuery($sql,"otcxjcom");
$totalrecords=count($rt);
if (!isset($pagesize)){
global $pagesize;
$pagesize=3;
}
?>