publish_news_preview.php

Oracle源码：Oracle 数据库管理与应用系统开发代码

<? include('../inc/func.php');
   include('pub_func.php');
   $sql="select newid,upname,newname,downname1,downname2,newwriter,newgiver,newcomper,newtranser,newdate,column1,column2,column3,newtext,newsource,newsourcestr,uploadertime,uploader,pic1,pic2,pic3,pic4,pic5,clas_statue,newlink,modle,modle1,modle2 from waternews where newid=".$newid;
   $array1=$cla->db_query($sql);
   $newid=$array1[0][NEWID];
   $upname=change($array1[0][UPNAME]);
   $newname=change($array1[0][NEWNAME]);
   $downname1=change($array1[0][DOWNNAME1]);
   $downname2=change($array1[0][DOWNNAME2]);
   $newwriter=$array1[0][NEWWRITER];
   $newgiver=$array1[0][NEWGIVER];
   $newcomper=$array1[0][NEWCOMPER];
   $newtranser=$array1[0][NEWTRANSER];
   $newdate=formdate($array1[0][NEWDATE]);
   $column1=$array1[0][COLUMN1];
   $column2=$array1[0][COLUMN2];
   $column3=$array1[0][COLUMN3];
   $newtext=replace_html($array1[0][NEWTEXT],$array1[0][PIC1],$array1[0][PIC2],$array1[0][PIC3],$array1[0][PIC4],$array1[0][PIC5],"../create/yjx/".$newid);
   $newsource=$array1[0][NEWSOURCE];
   $newsourcestr=$array1[0][NEWSOURCESTR];
   $uploadertime=$array1[0][UPLOADERRTIME];
   $uploader=$array1[0][UPLOADER];
   $newlink=get_newname($array1[0][NEWLINK],$cla);
   $modle1=$array1[0][MODLE1];
   $modle2=$array1[0][MODLE2];
   $fp=fopen("../template/".$array1[0][MODLE].".php",'r');
   $html = fread($fp, filesize('../template/'.$array1[0][MODLE].".php"));
   fclose( $fp );

   $pub_statue=$array1[0][PUB_STATUE]; 
   $clas_statue=$array1[0][CLAS_STATUE];  
   $html=str_replace('%upname%',$upname,$html);
   $html=str_replace('%标题%',$newname,$html);
   $html=str_replace('%downname1%',$downname1,$html);
   $html=str_replace('%downname2%',$downname2,$html);
   $html=str_replace('%提交人%',$uploader,$html);
   $html=str_replace('%来源%',$newsource,$html);
   $html=str_replace('%日期%',$newdate,$html);
   $html=str_replace('%作者%',$newwriter,$html);
   $html=str_replace('%内容%',$newtext,$html);
   $html=str_replace('%链接%',$newlink,$html);
   echo $html;
  
   $cla->db_logoff;
  ?>