$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];