approve_product.php

来自「通达OA部分源代码」· PHP 代码 · 共 42 行

<?php 
include_once"logincheck.php";
include_once"myconnect.php";

if( isset($_REQUEST["sb_id"]) && ($_REQUEST["sb_id"] != 0) )//&& isset($_REQUEST["sbapp"]) )
{		
	$sb_id=$_REQUEST["sb_id"];
	
		$sbq_res="select * from sbbleads_products where sb_id=$sb_id";
		$sbrow_res=mysql_fetch_array(mysql_query($sbq_res));

		if($sbrow_res["sb_approved"] == 'no')
		{
			$sbmsg_part="approved";
			$sb_approved='yes';
			$sbfail_msg='approve';
		}
		else
		{
			$sbmsg_part="disapproved";
			$sb_approved='no';
			$sbfail_msg='disapprove';
		}
		$query_ope="update sbbleads_products set sb_approved='$sb_approved' where sb_id=$sb_id";
		//die($query_ope);
		$rs_ope=mysql_query($query_ope);
		if(mysql_affected_rows() == 1)
		{
			header("Location: products.php?msg=".urlencode("Product catalog has been $sbmsg_part"));
			die();	
		}	
		else	
		{		
			header("Location: products.php?msg=".urlencode("Unable to $sbfail_msg, please try again"));
			die();
		}
}		//end if top most
	//if nothing came
	header("Location: adminhome.php?msg=".urlencode("Invalid operation, denied"));
	die();

?>