fbtest/Events.php at master · opgrsankkar/fbtest · 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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?php
include 'dbconn.php';

if (session_status() == PHP_SESSION_NONE) {
    session_start();
	if($_SESSION['fname']==''){header('Location:login.php');}
}
$user_id = $_SESSION['user_id'];
?>
<!DOCTYPE html>
<html>
	<head>
		<meta charset="utf-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="viewport" content="width=device-width, initial-scale=1.0">
		</echo><link rel="stylesheet" type="text/css" href="simple-grid.css">
        <link rel="stylesheet" type="text/css" href="main.css">
    </head>
	<body>
		<nav class="row">
            <span class="col-1-sm"></span>
            <span class="col-2-sm"><a href="index.php" style="text-decoration:none;">F.R.I.E.N.D.S</a></span>
            <span class="col-6-sm"></span>
            <span id="navbarname" class="col-1-sm"><?php echo $_SESSION['fname']?></span>
            <span class="col-1-sm">
                <a href="mailto:fbtests.reportbug@gmail.com?Subject=Bug%20Report%20on%20FRIENDS">
                    <img src="photos/contribute_bug.png" title="Report Bug" style="max-height:1em;width:auto;">
                </a>
            </span>
            <span id="logoutbtn" class="col-1-sm"><a href="logout.php" tabindex="-1">!</a></span>
        </nav>
		<div id="sidenav" class="sidenav">
            <span class=""><a href="index.php">Feed</a></span>
			<span class=""><a href="posts.php?v_id=<?= $user_id ?>">Posts</a></span>
            <span class=""><a href="photos.php">Photos</a></span>
            <span class=""><a href="events.php">Events</a></span>
            <span class=""><a href="friends.php">Friends
                        <?php
                            connect();
                            $sqlcount = 'SELECT COUNT(USER_ID) AS P_F FROM USERS WHERE
                                USER_ID IN (SELECT USER_ID1 AS U_ID FROM FRIENDS WHERE (USER_ID2='.$user_id.') AND ACCEPT_DATE IS NULL)';
                            $result = $conn->query($sqlcount);
                            if ($result->num_rows > 0) {
                                while($row_cursor = $result->fetch_assoc()) {
                                    $p_f = $row_cursor['P_F'];
                                    if($p_f==0){
                                        echo '';
                                    }
                                    else{
                                        echo '<span class="badge">'.$row_cursor['P_F'].'</span>';
                                    }
                                }
                            }
                            disconnect();
                            ?>
                </a>
            </span>
            <span class="shouts-link"><a href="shouts.php">Shouts</a></span>
            <span class="report-bug"><a href="mailto:fbtests.reportbug@gmail.com?Subject=Bug%20Report%20on%20FRIENDS">Report Bug</a>
		</div>
        <div class="middle-content">
            <div class="row" style="padding-bottom: 40px;">
                <h3 class="col-10">Events</h3>
                <span class="col-2"><a href="addEvents.html">Add Event</a></span>
            </div>
                 <?php
                connect();
                $sqle = 'SELECT FNAME,LNAME,EVENT_NAME,START_DATE,END_DATE,EVENT_DESC FROM EVENTS NATURAL JOIN USERS WHERE
                    UNIX_TIMESTAMP(END_DATE) > UNIX_TIMESTAMP(NOW()) AND(
                    USER_ID IN (SELECT USER_ID2 AS U_ID FROM FRIENDS WHERE(USER_ID1='.$user_id.') AND ACCEPT_DATE IS NOT NULL) OR
                    USER_ID IN (SELECT USER_ID1 AS U_ID FROM FRIENDS WHERE (USER_ID2='.$user_id.') AND ACCEPT_DATE IS NOT NULL) OR
                    USER_ID IN(SELECT USER_ID AS U_IS FROM USERS WHERE USER_ID = '.$user_id.'))
                    ORDER BY ADD_DATE DESC';
                $resulte = $conn->query($sqle);
                if ($resulte->num_rows > 0) {
                    while($row_cursore = $resulte->fetch_assoc()) { ?>
                        <div class="Event-display box" >
                            <?= $row_cursore['FNAME']?> <?= $row_cursore['LNAME']?>
                            <p class="row"><strong class="col-5">Event Name :</strong> <?=$row_cursore['EVENT_NAME'] ?> </p>
                            <p class="row"><strong class="col-5">Start Date-Time :</strong> <?= $row_cursore['START_DATE'] ?> </p>
                            <p class="row"><strong class="col-5">End Date-Time :</strong> <?= $row_cursore['END_DATE'] ?> </p>
                            <p class="row"><strong class="col-5">Event Description :</strong> <?= $row_cursore['EVENT_DESC'] ?> </p>
                        </div>
                    <?php
                    }
                    } disconnect();?>
        </div>
    </body>
</html>