$columns = array('feedId', 'feedSubject', 'feedAuthor', 'feedText');
$action = 'unread';
$servername = 'localhost';
$username = '******';
$password = '';
//session_start();
//$_SESSION['username'] = $phoneNum;
$log->info("Storing the session variable 'user' ");
//if(isset($_GET['action']) && !empty($_GET['action'])) {
//$action = $_GET['action'];
switch ($action) {
case 'all':
all($user, $typeOfFeed, $columns, $servername, $username, $password, $log);
break;
case 'unread':
unread($user, $columns, $servername, $username, $password, $log);
break;
}
//}
function all($user, $typeOfFeed, $columns, $servername, $username, $password, $log)
{
try {
$dbh = new PDO('mysql:host=localhost;port=3306;dbname=dbproject', $username, $password);
$log->info("Connection is established with the database.");
$log->info("Get the feeds of the current block/neighbourhood based on the feed type " + $typeOfFeed);
$stmt = $dbh->prepare('Select * from receipient natural join feed where receiverName = ? and category = ? ;');
$stmt->execute(array($user, $typeOfFeed));
$isNotEmpty = $stmt->rowCount() > 0;
if ($isNotEmpty) {
$results = $stmt->fetchAll();
foreach ($results as $row) {
<p><a href="<?= Link::content("upload") ?>">upload</a></p>
<p><a href="<?= Link::content("subscriptions") ?>">subscribed threads</a></p>
<p><a href="<?= Link::content("settings") ?>">settings</a></p>
<p><a href="logout.php">log out</a></p>
</div>
<div class="blackbar"></div>
</div>
<?
if(function_exists('sidebar')) {
sidebar();
}
unread();
?>
<div class="contentbox">
<div class="blackbar"></div>
<div class="heading">community:</div>
<div class="bluebox">
<p><a href="http://chat.efnet.org:9090/?channels=themaxx&nick=<?= urlencode(me()->username()); ?>" target="_blank">chat</a></p>
<p><a href="<?= Link::content("map") ?>">maxxer world map</a></p>
<p><a href="<?= Link::content("referral") ?>">invite a friend</a></p>
<p><a href="<?= Link::content("faq") ?>">FAQ, rules, etc.</a></p>
<!-- <p><a href="<?= Link::content("stats") ?>">stats</a></p> -->
</div>
<div class="blackbar"></div>
</div>
<? } // log in --> get info restricted block ?>
//$block = $_GET["block"];
$block = 'bayridge';
//$userName = $_GET["hood"];
$hood = 'brooklyn';
//$type = $_GET["type"];
$type = 'Hood';
$columns = array('userName', 'block', 'hood', 'address', 'location');
//session_start();
//$_SESSION['username'] = $phoneNum;
//$log->info("Storing the session variable 'phoneNum' ");
switch ($type) {
case 'Hood':
hood($block, $hood, $columns, $servername, $username, $password, $log);
break;
case 'Block':
unread($block, $hood, $columns, $servername, $username, $password, $log);
break;
}
function hood($block, $hood, $columns, $servername, $username, $password, $log)
{
try {
$dbh = new PDO('mysql:host=localhost;port=3306;dbname=dbproject', $username, $password);
$log->info("Connection is established with the database.");
$stmt = $dbh->prepare("CALL hood_users(?)");
if ($stmt->execute(array($hood))) {
$users = array();
$results = $stmt->fetchAll();
foreach ($results as $row) {
$tmp = array();
foreach ($columns as $column) {
$tmp[$column] = $row[$column];
