modify_news_generate.php

采用PHP+oracle；功能设计：用户管理、栏目管理、新闻管理、专题管理、日志管理

<? $sql="select newsid,upname,newsname,downname1,downname2,newswriter,newsgiver,newscomper,newstranser,newsdate,column1,column2,column3,newstext,newssource,newssourcestr,uploadertime,uploader,pic1,pic2,pic3,pic4,pic5,clas_statue,newslink,modle,modle1,modle2 from news where newsid=$newid";
   // echo $sql;
 
   $array1=$cla->db_query($sql); 
   $i=0;

   while($array1[$i][0]){
     if($array1[$i][CLAS_STATUE]!=1){
      $newid=$array1[$i][NEWID];
      $upname=change($array1[$i][UPNAM]);
      $newname=change($array1[$i][NEWNAME]);
      $downname1=change($array1[$i][DOWNNAME1]);
      $downname2=change($array1[$i][DOWNNAME2]);
	  $newname=$upname.$newname.$downname1.$downname2;
      $newwriter=$array1[$i][NEWWRITER];
      $newgiver=$array1[$i][NEWGIVER];
      $newcomper=$array1[$i][NEWCOMPER];
      $newtranser=$array1[$i][NEWTRANSER];
      $newdate=formnewdate($array1[$i][NEWDATE]);
      $column1=
      $column2=$array1[$i][COLUMN2];
      $column3=$array1[$i][COLUMN3];
      $newtext=replace_html($array1[$i][NEWTEXT],$array1[$i][PIC1],$array1[$i][PIC2],$array1[$i][PIC3],$array1[$i][PIC4],$array1[$i][PIC5],"../../image_news/".$newid);
      $newsource=$array1[$i][NEWSOURCE];
      $newsourcestr=$array1[$i][NEWSOURCESTR];
      $uploadertime=$array1[$i][UPLOADERRTIME];
      $uploader=$array1[$i][UPLOADER];
      $newlink=get_newname($array1[$i][NEWLINK],$cla);
	  $modle=$array1[$i][MODLE];
	  $dirname="../itemfiles/".$array1[$i][COLUMN1];
      $column=get_column($column1,$cla);
      generate_html($newid,$dirname,$modle,$newname,$newdate,$newwriter,$newtext,$newlink,$newsourse,$column,$uploader);
;	  if($column2!=''){

	      $modle1=$array1[$i][MODLE1];

	      $dirname="../topicfiles/".$array1[$i][COLUMN2];
		  $column=get_column($column2,$cla);

          generate_html($newid,$dirname,$modle1,$newname,$newdate,$newwriter,$newtext,$newlink,$newsourse,$column,$uploader);

	  }

	  if($column2!=''){

	      $modle2=$array1[$i][MODLE2];

          $dirname="../topicfiles/".$array1[$i][COLUMN3];
		    $column=get_column($column3,$cla);

          generate_html($newid,$dirname,$modle2,$newname,$newdate,$newwriter,$newtext,$newlink,$newsourse,$column,$uploader);

	  }
	  }
	  $i++;
	  }
	 
	
   ?>