DB_USER_AMAZE, "PWD" => DB_PASSWORD_AMAZE, "Database"=>DB_NAME_AMAZE);
$conn = sqlsrv_connect( DATABASE, $connectionInfo);
$tsql="EXEC dbo.get_referrer_id '$referrer_back','$referrer_full_url'";
$stmt = sqlsrv_query($conn, $tsql);
if ($stmt === false)
{
echo "Error in query preparation/execution.\n";
die( print_r( sqlsrv_errors(), true));
}
// Prepare the statement.
$stmt = sqlsrv_prepare($conn, $tsql);
// Execute the statement.
sqlsrv_execute( $stmt);
//Retrieve each row as a PHP object and display the results.
$obj = sqlsrv_fetch_object($stmt);
$referrer_back=$obj->result;
//close the connection
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
}
else
{
$referrer_back=$_SESSION['thisReferrer'];
}
if($referrer_back=="")
{
$referrer_back=REFERRER;
$_SESSION['thisReferrer']=$referrer_back;
}
if($_REQUEST['referrer']!="")
{
$referrer_back=$_REQUEST['referrer'];
$_SESSION['thisReferrer']=$referrer_back;
}
session_write_close();
$screenWidth=get_device_id_by_useragent();
if ($screenWidth >= 320)
{
$class = "320";
}
else if ($screenWidth >= 240)
{
$class= "240";
}
else $class = "165";
odbc_close($conn);
?>
Optimus
