function getRegListOld() { global $session; $db = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14"); if ($session->haveAccess(1, 1, 1, 1)) { if (!isset($_GET['eventcode'])) { $out['status'] = 'fail'; $out['error'] = 'fill in more details :P'; } else { $ecode = $_GET['eventcode']; $result = $db->query("SELECT e.team_id, e.tat_id, s.name as name, s.phone, s.email, c.name as clg FROM event_reg e INNER JOIN student_reg s ON e.tat_id=s.id INNER JOIN colleges c ON s.clg_id=c.id WHERE e.code='{$ecode}'"); $regDetails = $db->getJSONArray($result); $out['status'] = 'success'; $out['data'] = $regDetails; } } else { $out['status'] = 'fail'; $out['error'] = 'no access'; } return $out; }
} ?> </tbody> </table> </div> </div> <div role="tabpanel" class="tab-pane" id="pre-events"> <?php $db = new Database(DB_SERVER, DB_USER, DB_PASS, "nitcfest_tathva14"); $query = "SELECT * FROM events"; $result = $db->query($query); $events = $db->getJSONArray($result); foreach ($events as $event) { echo '<a href="showpreevent.php?eventcode=' . $event['code'] . '" target="_blank" class="btn btn-default stacked"' . '>' . $event['name'] . '</a>'; } ?> </div> </div> </div> <div class="progress-dialog hide"> <img src="img/loader.gif" /> <p>Processing...</p> </div> <div class="fade-div hide" id="fade-div"></div>