function reRegisterPerson($isParticipant, $key)
{
include 'DBHelperClass.php';
// create database helper
$db = new DBHelperClass();
// unregister
$ret = $db->redoRegistration($isParticipant, $key);
// close database helper
$db->close();
return $ret;
}
<?php
include_once '../signupScripts/DBHelperClass.php';
include_once '../signupScripts/GeneralHelper.php';
$result = array();
$result["result"] = "failure";
$result["data"] = "Error: Unknown";
// check if token exists
if (array_key_exists("token", $_GET)) {
// create database helper
$db = new DBHelperClass();
// test token
if (!$db->loginToken($_GET["token"])) {
$result["data"] = "Error: Token did not match.";
} else {
if (!array_key_exists("id", $_GET)) {
$result["data"] = "Error: No id identifer.";
} else {
if (!array_key_exists("key", $_GET)) {
$result["data"] = "Error: No key identifer.";
} else {
if (!array_key_exists("badge", $_GET)) {
$result["data"] = "Error: No badge identifer.";
} else {
$id = $_GET["id"];
$key = $_GET["key"];
$badge = $_GET["badge"];
$res_checkin = $db->updateRecordIdKey($id, $key, "checked_in", 1);
if (!$res_checkin) {
$result["data"] = "Error: Could not check person in.";
} else {
$participants = $db->getParticipants();
// get mentors
$mentors = $db->getMentors();
// close helper
$db->close();
// no session
} else {
// check if loggin in
if (array_key_exists("login", $_POST) && $_POST["login"] == 1) {
// check if username and login exists
if (array_key_exists("username", $_POST) && array_key_exists("password", $_POST)) {
// get data
$username = $_POST["username"];
$password = $_POST["password"];
// create helper
$db = new DBHelperClass();
// check if correct login
if ($db->login($username, $password)) {
// correct, so set cookie
setcookie("t9hacks_login", "1", time() + 60 * 60 * 24);
// close helper
$db->close();
// relocate to same page without post data
header('Location: view.php');
}
// close helper
$db->close();
}
}
}
//echo '<pre>' . print_r($participants, true) . '</pre>';
<?php
include_once '../signupScripts/DBHelperClass.php';
include_once '../signupScripts/GeneralHelper.php';
$result = array();
$result["result"] = "failure";
$result["data"] = "Error: Unknown";
// check if token exists
if (array_key_exists("token", $_GET)) {
// create database helper
$db = new DBHelperClass();
// test token
if ($db->loginToken($_GET["token"])) {
//if(false) {
// create an array for people
//$people = array("participants" => array(), "mentors" => array());
// fields desired
$fields = array("id", "key", "name", "email", "phone", "shirt", "checked_in");
// get participants
$participants = $db->getParticipants();
foreach ($participants as $id => $participant) {
if ($participant["approved"] == 1 && $participant["unregistered"] == 0) {
$participantData = array("type" => "participant");
foreach ($fields as $field) {
$participantData[$field] = $participant[$field];
//$people["participants"][$participant["id"]][$field] = $participant[$field];
}
$people[] = $participantData;
}
}
// get mentors
<?php
include_once 'DBHelperClass.php';
// create helper
$db = new DBHelperClass();
// get participants
$participants = $db->getParticipants();
//echo '<pre>'.print_r($participants, true).'</pre>'; die();
// get mentors
$mentors = $db->getMentors();
//echo '<pre>'.print_r($mentors, true).'</pre>'; die();
// close helper
$db->close();
// output headers so that the file is downloaded rather than displayed
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=data.csv');
// create a file pointer connected to the output stream
$output = fopen('php://output', 'w');
/*
// output the column headings
fputcsv($output, array('Column 1', 'Column 2', 'Column 3'));
// fetch the data
mysql_connect('localhost', 'username', 'password');
mysql_select_db('database');
$rows = mysql_query('SELECT field1,field2,field3 FROM table');
// loop over the rows, outputting them
while ($row = mysql_fetch_assoc($rows))
fputcsv($output, $row);
*/
