add_favorites.php

通达OA部分源代码

<?php 
//	include_once('logincheck.php');
	include_once('myconnect.php');

if( !isset($_REQUEST["sb_id"]) || !is_numeric($_REQUEST["sb_id"]) || ($_REQUEST["sb_id"] <= 0) || !isset($_REQUEST["sb_type"]) || !is_numeric($_REQUEST["sb_type"]) || ($_REQUEST["sb_type"] <= 0) )
{
	header("Location: gen_confirm.php?errmsg=".urlencode("Invalid access, denied"));
	die();
}
$sb_id=$_REQUEST["sb_id"];
$sb_type=$_REQUEST["sb_type"];
include_once "logincheck.php";
/*include "session.php";  
if (!isset($_SESSION["sbbleads_userid"]) && !isset($_REQUEST["tmp"]) )
{
 header("Location: ". "signin.php?id=$sb_id&sb_type=$sb_type&errmsg=" .urlencode("You must be logged to access this page!") );
 die();
}*/

	$sb_uid=$_SESSION["sbbleads_userid"];
	switch($sb_type)
	{
		case 1:
			$sb_type_text='sell';
			
			break;
		case 2:
			$sb_type_text='buy';
			$sbreturn_page='view_offer_buy.php';
			break;
		case 3:
			$sb_type_text='product';
			$sbreturn_page='view_product.php';
			break;
		case 4:
			$sb_type_text='profile';
			$sbreturn_page='view_profile.php';
			break;
		default:
			header("Location: gen_confirm.php?errmsg=".urlencode("Invalid access, denied"));
			die();
			break;
	}
	$sbreturn_page='gen_confirm.php?sb_type='.$sb_type;
	$query_chk="select * from sbbleads_favorites where sb_uid=$sb_uid and sb_offer_id=$sb_id and sb_type='$sb_type_text'";
	$rs_chk=mysql_query($query_chk);
	if(mysql_num_rows($rs_chk) > 0)
	{
		header("Location: $sbreturn_page&id=$sb_id&errmsg=".urlencode("Already in your favorites list"));
		die();
	}
	$query_fav="insert into sbbleads_favorites (sb_offer_id, sb_uid, sb_type) values($sb_id, $sb_uid, '$sb_type_text')";
	$rs_fav=mysql_query($query_fav);
	if(mysql_affected_rows() == 1)
	{
		header("Location: $sbreturn_page&id=$sb_id&errmsg=".urlencode("Added to your favorites list"));
		die();
	}
	else
	{
		header("Location: $sbreturn_page&id=$sb_id&errmsg=".urlencode("Unable to add to favorites"));
		die();
	} 
?>