📄 modify_news_done.php
字号:
<? include("../inc/check.php");
include('../inc/func.php');
$modifytime=date('YmdHis');
$uploader=$ses_loginname;//操作者
$group_name=$ses_groupid;
if($clas_statue==0){
if ($upname!=''){
$upname=$color1.$size1.$upname;
}
if ($newname!=''){
$newname=$color2.$size2.$newname;
}
if ($downname1!=''){
$downname1=$color3.$size3.$downname1;
}
if ($downname2!=''){
$downname2=$color4.$size4.$downname2;
}
$newdate=$year.$month.$date;
//******************************开始入库*********************************************************
$conn = OCILogon($cla->db_getUser(), $cla->db_getPassword(), $cla->db_getDB());
$clob = OCINewDescriptor($conn, OCI_D_LOB);
$sql="update news set upname='$upname',newsname='$newname',downname1='$downname1',downname2='$downname2',newswriter='$newwriter',newsgiver='$newgiver',newscomper='$newcomper',newstranser='$newtranser',newsdate='$newdate',column1=$column1,column2=$column2,column3=$column3,newstext=EMPTY_CLOB(),newssource='$newsource',newssourcestr='$newsourcestr',newslink='$newlinkid',modle='$modle',modle1='$modle1',modle2='$modle2' where newsid=$newid RETURNING newstext INTO :newtext ";
$stmt = OCIParse($conn,$sql);
OCIBindByName($stmt, ':newtext', &$clob, -1, OCI_B_CLOB);
OCIExecute($stmt, OCI_DEFAULT);
if($clob->save($newtext)){
OCICommit($conn);
}else{
echo "警告: 没有上传新闻内容\n";
}
OCIFreeStatement($stmt);
OCICommit($conn);
for($i=1;$i<=5;$i++){
$pic_cl="pic_class".$i;
$pic_class=$$pic_cl;//文件类型
$filen="file".$i;
$filename=$$filen;//图片名
$picn="pic".$i;
$pic=$$picn;//图片说明
$filena="file".$i."_name";
$filename_old=$$filena;//原图片名临时文件名
if (($filename!="none")||($pic_class!="")){
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);
}else{
$sql1.=",pic".$i."='".$pic_class.$pic."'";
}
}
}//end for
$sql="update news set newsid=$newid".$sql1."where newsid=".$newid;
//echo $sql;
$cla->db_change($sql);
}else{
if ($newname!=''){
$newname=$color2.$size2.$newname;
}
if ($downname1!=''){
$downname1=$downname1;
}
$sql="update news set newsname='$newname',downname1='$downname1',newswriter='$newwriter',newsgiver='$newgiver',newscomper='$newcomper',newstranser='$newtranser',newsdate='$newdate',column1='$column1',newstext='$newtext',modle='$modle' where newsid=$newid";
$cla->db_change($sql);
}
$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','修改新闻','$modifytime')";
$cla->db_change($sql);
//echo $sql;
$cla->db_commit();
if($pub_statue==1){
include("../publish/pub_func.php");
include("modify_news_generate.php");
}
//header("loaction:modify_news_select.php");
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="water.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="form1" method="post" action="modify_news_result.php">
<table width="772" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#111111" class=border>
<tr align="center">
<td height="28" colspan="4"> 请选择要修改的新闻</td>
</tr>
<tr>
<td width="47" align="right">标题:</td>
<td width="310"> <input name="newname" type="text" class="input1" size="50"> </td>
<td width="268">栏目：
<select name="column1">
<option value=''>全选</option>
<?
$sqldo="select class_id,class_name from baseclass where class_layer=1";
$result_array=$cla->db_query($sqldo);
$i=0;
$old=$result_array[$i][0];
while($result_array[$i][0]){
$temp1=$result_array[$i][0];
$temp1_name=strip_tags($result_array[$i]["CLASS_NAME"]);
$sqldo_in="select class_id,class_name from baseclass where class_father='$temp1'";
$result_array_in=$cla->db_query($sqldo_in);
$j=0;
$flg1=0;
if($result_array_in[$j][0]==""){//如果是空，也显示一次，即将第二级专题显示出来
$flg1=1;
}
while($result_array_in[$j][0] or $flg1){
$temp2=$result_array_in[$j][0];
$temp2_name=strip_tags($result_array_in[$j]["CLASS_NAME"]);
$sqldo_in_in="select class_id,class_name from baseclass where class_father='$temp2'";
$result_array_in_in=$cla->db_query($sqldo_in_in);
$k=0;
$flg2=0;
if($result_array_in_in[$k][0]==""){//如果是空，也显示一次，即将第三级专题显示出来
$flg2=1;
}
while(($result_array_in_in[$k][0]<>"") or ($flg2<>0) or ($flg1<>0)){
$temp3=$result_array_in_in[$k]['CLASS_NAME'];
$temp3_name=strip_tags($result_array_in_in[$k]['CLASS_NAME']);
?>
<option value=<? if($temp3){echo $temp3;}elseif($temp2){echo $temp2;}elseif($temp1){echo $temp1;}?>>
<? echo "$temp1_name";if($temp2_name){ echo ".$temp2_name";if($temp3_name) echo".$temp3_name";}
//echo "old:".$old;
// echo "result_array".$result_array[$i][0];
?>
</option>
<?
$flg1=0; $flg2=0; $k++;}//第四级
$j++;}//第三级
?>
<option value="">***************************</option>
<?
$old=$result_array[$i][0];$i++;}//第二级
?>
</select></td>
<td width="113" ><input type="submit" name="Submit" value=" 搜 索 " class="input1"></td>
</tr>
<tr>
<td align="right">日期:</td>
<td width="310"> <input name="newdate" type="text" class="input1">
( 年年年年月月日日)</td>
<td width="268">最近：
<select name="days">
<option value="0" selected>选择天数</option>
<option value="1">1天</option>
<option value="2">2天</option>
<option value="3">3天</option>
<option value="4">4天</option>
<option value="5">5天</option>
<option value="6">6天</option>
<option value="7">一星期</option>
<option value="15">半个月</option>
<option value="30">一个月</option>
<option value="60">两个月</option>
<option value="90">三个月</option>
<option value="180">半年</option>
<option value="365">一年</option>
</select></td>
<td width="113"><input name="Submit2" type="reset" class="input1" value=" 取 消 "></td>
</tr>
</table>
</form><?$cla->db_logoff();?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -