adm_recommend.php

这个版本只是修正了一些BUG

<?php
/**********************************************
	adm_recommend.php

	Version  : 1.2
	Author   : Tracemouse ([e-mail])
	Copyright: http://www.vitci.com
	Writed   : 2003/08/20
	Modified : 2004/04/18
**********************************************/
require "./common.php";
$file_name='./adm_recommend.php';

if ((!$editsubmit)&&(!$listsubmit)&&(!$addsubmit))
{  //未发送表单
	if ($action == 'edit')
    	{           //修改页面
 		$query = $db->query("select * from $table_recommend where rid=$rid");
 		if($dbq_rec = $db->fetch_array($query))
        	{
    			$productname = $dbq_rec['productname'];
    			$img = $dbq_rec['img'];
    			$words = $dbq_rec['words'];
    			$sid = $dbq_rec['sid'];
 		}
 		$display = 'edit';
	}
	else                                //列表页面
	{
 		$query = $db->query("SELECT COUNT(*) FROM $table_recommend");
		$recnum = $db->result($query, 0);
 		$reclist = array();
 		$query = $db->query("select * from $table_recommend order by sid");
 		while($dbq_result = $db->fetch_array($query))
    		{
    			$reclist[] = $dbq_result;
 		}
 		$display = 'list';
	}
}
elseif ($editsubmit)
{              //发送表单处理
    	$sid=intval($sid);
    	$sqlstr="update $table_recommend set words='$words',img='$img',sid=$sid where rid=$rid";
 	if($query=$db->query($sqlstr,1))
    		gotourl($language['editsuccess'],$file_name);
    	else
    		gotourl($language['db_err'].":<br>".$sqlstr);

}
elseif ($addsubmit)
{         //新增
    	$productid=intval($productid);
    	$query=$db->query("select * from $table_products where productid=$productid");
 	if($rec=$db->fetch_array($query))
 	{
  		$productname=$rec['productname'];
  		$subject=$rec['subject'];
  		$img=$rec['smallimg'];
  		$sqlstr="insert into $table_recommend(productid,productname,words,img,sid) values($productid,'$productname','$subject','$img',1)";
  		if($query=$db->query($sqlstr,1))
    			gotourl($language['editsuccess'],$file_name);
  		else
        		gotourl($language['db_err']);
	}
 	else
    		gotourl($language['alt_pro_notfound']);
}
elseif ($listsubmit)
{             //删除记录
	if(is_array($delete))
    	{
  		$ids = $comma = "";
  		foreach($delete as $id)
        	{
    			$ids .= "$comma'$id'";
			$comma = ", ";
   		}
        	$sqlstr="delete from $table_recommend where rid in ($ids)";
        	if($query=$db->query($sqlstr,1))
    			gotourl($language['delsuccess'],$file_name);
  		else
        		gotourl($language['db_err'].":<br>".$sqlstr);
  	}
  	$query=@$db->query("select * from $table_recommend order by sid");
	while($dbq_rec=$db->fetch_array($query))
	{
	 	$id=$dbq_rec[rid];
	 	$pid=$dbq_rec['productid'];
	 	$sqlstr="select count(*) from $table_products where productid=$pid";
	 	$num=@$db->result($db->query($sqlstr,1),0);
	 	if($num < 1 )
	 	{
	 		@$db->query("delete from $table_recommend where productid = $pid",1);
		}
	 	$upd_sid[$id]=intval($upd_sid[$id]);
	 	$sqlstr="update $table_recommend set productname='$upd_productname[$id]',img='$upd_img[$id]',sid=$upd_sid[$id] where rid=$id";
		@$db->query($sqlstr,1);	
	}
  	gotourl($language['editsuccess'],$file_name);
}

include template('recommend');
?>