phpBlog-blogScript/unsubscribe.php at main · codeplay-code/phpBlog-blogScript · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
<?php
include "core.php";
head();

if ($settings['sidebar_position'] == 'Left') {
	sidebar();
}
?>
    <div class="col-md-8 mb-3">
        <div class="card">
            <div class="card-header"><i class="fas fa-envelope"></i> Unsubscribe</div>
                <div class="card-body">
<?php
$email = $_GET['email'];
if (!isset($_GET['email'])) {
    echo '<meta http-equiv="refresh" content="0; url=' . $settings['site_url'] . '">';
    exit;
} else {

    $querych = mysqli_query($connect, "SELECT * FROM `newsletter` WHERE email='$email' LIMIT 1");
    if (mysqli_num_rows($querych) == 0) {
        echo '<meta http-equiv="refresh" content="0; url=' . $settings['site_url'] . '">';
        exit;

    } else {
        $query = mysqli_query($connect, "DELETE FROM `newsletter` WHERE email='$email'");
        echo '<div class="alert alert-primary">You were unsubscribed successfully.</div>';
    }
}
?>
                </div>
        </div>
    </div>
<?php
if ($settings['sidebar_position'] == 'Right') {
	sidebar();
}
footer();
?>