create_news_done.php

本书主要介绍了从基础开始建立Portal的快速应用开发过程（RAD）的方法。通过本书你可以了解到关于Oracle 9iAS Portal产品的主要特性、入口的开发和组织、网络开发和管理、实际的关系型数

<? 
require "../inc/check.php";
require "../inc/func.php";
$uploadertime=date('YmdHis');  
$uploader=$ses_loginname;//操作者
$group_name=$ses_groupid; //操作者所在的组
$newdate=$year.$month.$date;
$newslength=strlen(($newname.$upname.$downname1.$downname2.(strip_tags($newtext))))/2;//计算字数
if ($clas_statue==""){
//*************************************处理检验各种数据***********************************************
	if ($upname!=''){
		$upname=$color1.$size1.$upname;
	}
	if ($newname!=''){	
		$newname=$color2.$size2.$newname;
	}
	if ($downname1!=''){	
		$downname1=$color3.$size3.$downname1;
	}
	if ($downname2!=''){	
		$downname2=$color4.$size4.$downname2;
	}
	if($key!=""){
		$sql="select newsid from news where pub_statue=1 and del_statue!=1 and newsname like '%".$key."%'";
		$array=$cla->db_query($sql);
		$newlinkid='';
		$i=0;
		while ($array[$i][0]&&$i<9){
			$newlinkid.=$array[$i][0].';';
			$i++;
		}
		echo $newlinkid;
	}
	if ($newlinkid==''){
		$newlinkid="0;";
	}
	$newwriter=trim($newwriter);
	$newgiver=trim($newgiver);
	$newcomper=trim($newcomper);
	$newtranser=trim($newtranser);
	$clas_statue=0;
	$newtext=str_replace("'","‘", $newtext);
//******************************开始入库*********************************************************	   
	 
	$conn = OCILogon($cla->db_getUser(), $cla->db_getPassword(), $cla->db_getDB()); 
	$clob = OCINewDescriptor($conn, OCI_D_LOB);
	$sql="insert into news(newsid,upname,newsname,downname1,downname2,newswriter,newsgiver,newscomper,newstranser,newsdate,column1,column2,column3,newssource,newssourcestr,uploadertime,uploader,clas_statue,newslink,modle,modle1,modle2,newslength,newstext)values(newsnewsid.nextval,";
	$sql.="'$upname','$newname','$downname1','$downname2','$newwriter','$newgiver','$newcomper','$newtranser','$newdate',$column1,$column2,$column3,'$newsource','$newsourcestr','$uploadertime','$uploader',$clas_statue,'$newlinkid','$modle','$modle1','$modle2',$newslength,EMPTY_CLOB())RETURNING newstext INTO :newstext";
	$stmt = OCIParse($conn,$sql); 
	OCIBindByName($stmt, ':newstext', &$clob, -1, OCI_B_CLOB);
	OCIExecute($stmt, OCI_DEFAULT); 
	if($clob->save($newtext)){ 
	OCICommit($conn); 
	}else{ 
		echo "警告: 没有上传新闻内容\n"; 
	} 
	OCIFreeStatement($stmt); 
	OCICommit($conn);
//******************************结束入库*********************************************************	  	   
	if ($column2!=0){
		$tempid=$newid;
		$topicsel=$column2;
		$sqldo_in="select topicid from topic where newsid='$tempid' and spec_id='$topicsel'";
		$res_array_in=$cla->db_query($sqldo_in);
		if(!$res_array_in[0][0]){//如果不专题库中 则插入
			$sqldo="insert into topic values(topictopicid.nextval,'$tempid','$topicsel','$uploader','$uploadertime','','') ";
			$cla->db_insert($sqldo);
		}
	}
		if ($column3!=0){
	        $tempid=$newid;
			$topicsel=$column3;
	        $sqldo_in="select topicid from topic where newsid='$tempid' and spec_id='$topicsel'";
            $res_array_in=$cla->db_query($sqldo_in);
			if(!$res_array_in[0][0]){//如果不专题库中 则插入
	              $sqldo="insert into topic values(topictopicid.nextval,'$tempid','$topicsel','$uploader','$uploadertime','','') ";
				  $cla->db_insert($sqldo);
            }
		}
       $sql="select newsid from news where uploadertime='$uploadertime'";
       //echo "<br>".$sql;
       $array=$cla->db_query($sql);
	   $newid=$array[0][NEWSID];
       mkdir('../image_news/'.$newid, 0777);
       for($i=1;$i<=5;$i++){
             $filen="file".$i;
	         $picn="pic".$i;
	         $filename=$$filen;
	         $pic=$$picn;
	         $filena="file".$i."_name";
	         $filename_old=$$filena;
	            if ($filename!="none"){
	                 $filename_tail=substr($filename_old, strrpos($filename_old,'.'));
	                 $file=$i.$filename_tail;
		             if($filename_tail==".jpg"){
	                           $sql1.=",pic".$i."='j".$pic."'"; 
	                  }else{
			                   $sql1.=",pic".$i."='g".$pic."'";
			          }	   
		             copy($filename,'../image_news/'.$newid."/".$file);
		          //   unlink($filename);
		        }
	    }
       $sql="update news set newsid=$newid ".$sql1." where newsid=".$newid;
     //  echo "<br>".$sql;
       $cla->db_change($sql);
	 }else{ 
	     if ($newname!=''){	
           $newname=$color2.$size2.$newname;
	     }
        if ($downname1!=''){	
           $downname1=$downname1; 
	     }
		 $sql="insert into news(newsid,newsname,downname1,newsdate,column1,newstext,uploadertime,uploader,clas_statue,newslink,modle)values(newsnewsid.nextval,";
         $sql.="'$newname','$downname1','$newdate',$column1,'$newtext','$uploadertime','$uploader',$clas_statue,'$newlinkid','$modle')";
         $cla->db_change($sql); 
		 $sql="select newsid from news where uploadertime='$uploadertime'";
         $array=$cla->db_query($sql);
	     $newid=$array[0][NEWSID];
	 }
	 $newname=substr($newname,9);
     $sql="insert into operatelog (log_id,user_name,group_name,news_id,news_title,act_type,act_time)values(operateloglog_id.nextval,'$uploader','$group_name',$newid,'$newname','插入新闻','$uploadertime')";
	 $cla->db_change($sql);
	 $cla->db_commit();
	 $cla->db_logoff();
	 require "../inc/error.php";
	 show_msg("提交成功！");
?>