prepare($sql);
$q->execute(array(
'email_id_hash' => $email_id_hash,
'event' => $event
));
while ($data = $q->fetchAll(PDO::FETCH_ASSOC))
{
foreach ($data as $row)
{
if ($data != NULL)
{
switch ($event)
{
case 'scipy 2015':
if ($row['unsubscribe'] == 0 && $row['email_hash'] == $email_id_hash)
{
$sql_up = "UPDATE sent_email SET unsubscribe = 1 WHERE email_hash =:email_id_hash ";
$q_up = $conn->prepare($sql_up);
$q_up->execute(array(
':email_id_hash' => $email_id_hash
));
echo '
Thank You for unsubscription';
echo '
If you are not automatically redirected, click here: SciPy India 2015.';
header('Refresh: 3; URL=http://scipy.in');
}
elseif ($row['unsubscribe'] == 1 && $row['email_hash'] == $email_id_hash)
{
echo '
You are already unsubscribed!';
echo '
If you are not automatically redirected, click here: SciPy India 2015.';
header('Refresh: 3; URL=http://scipy.in');
}
else
{
echo '
You are not a subscriber!';
echo '
If you are not automatically redirected, click here: SciPy India 2015.';
header('Refresh: 3; URL=http://scipy.in');
}
break;
case 'cfd-openfoam-symposium 2016':
if ($row['unsubscribe'] == 0 && $row['email_hash'] == $email_id_hash)
{
$sql_up = "UPDATE sent_email SET unsubscribe = 1 WHERE email_hash =:email_id_hash";
$q_up = $conn->prepare($sql_up);
$q_up->execute(array(
':email_id_hash' => $email_id_hash
));
echo '
Thank You for unsubscription';
echo '
If you are not automatically redirected, click here: OpenFOAM Symposium 2016.';
header('Refresh: 3; URL=http://fossee.in/conference/cfd-symposium/');
}
elseif ($row['unsubscribe'] == 1 && $row['email_hash'] == $email_id_hash)
{
echo '
You are already unsubscribed!';
echo '
If you are not automatically redirected, click here: OpenFOAM Symposium 2016.';
header('Refresh: 3; URL=http://fossee.in/conference/cfd-symposium/');
}
else
{
echo '
You are not a subscriber!';
echo '
If you are not automatically redirected, click here: OpenFOAM Symposium 2016.';
header('Refresh: 3; URL=http://fossee.in/conference/cfd-symposium/');
}
break;
}
}
else
{
echo "Wrong Link please try again";
header('Refresh: 3; URL=http://fossee.in');
}
}
}
}
$conn = null;
?>