Example #1
0
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;
}
Example #2
0
}
?>
                        </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>