public static function get($taskId = false)
{
$input = json_decode(file_get_contents('php://input'));
$sqlite = new sqlite();
if ($taskId) {
$data['tasks'] = $sqlite->query('SELECT * FROM tasks WHERE taskId = :taskId', array(':taskId' => $taskId));
} else {
$data['tasks'] = $sqlite->query('SELECT * FROM tasks');
}
return $data;
}
public function valid_token()
{
// Get input
$input = json_decode(file_get_contents('php://input'));
// Run SQL
$sqlite = new sqlite();
// Validate
$validated = $sqlite->query('SELECT * FROM tokens WHERE username = :username and token = :token', array('username' => $input->username, 'token' => $input->token));
// If validated
if ($validated) {
return true;
} else {
return false;
}
}
public static function get()
{
$input = json_decode(file_get_contents('php://input'));
$sqlite = new sqlite();
$validated = $sqlite->query('SELECT * FROM users WHERE Username = :username and Password = :password ', array(':username' => $input->username, ':password' => $input->password));
// If validated
if ($validated) {
$token['token'] = bin2hex(openssl_random_pseudo_bytes(16));
$statement = 'INSERT INTO tokens (username, token)
values (:username, :token)';
$parameters = array(':username' => $input->username, ':token' => $token['token']);
$sqlite->exec($statement, $parameters);
return array('result' => 'OK', 'username' => $input->username, 'token' => $token['token']);
} else {
return array('result' => 'Username and/or password incorrect, please try again.');
}
}
public static function put()
{
$input = json_decode(file_get_contents('php://input'));
$sqlite = new sqlite();
// Check if username already exists
$user = $sqlite->query('SELECT Username FROM users WHERE Username = :username ', array(':username' => $input->username));
// If it doesn't...
if (!$user) {
$statement = 'INSERT INTO users (Username, Password)
values (:username, :password)';
$parameters = array(':username' => $input->username, ':password' => $input->password);
$sqlite->exec($statement, $parameters);
$return['result'] = 'OK';
return $return;
// If it does..
} else {
$return['result'] = 'Username already exists';
return $return;
}
}
public static function dump_to_screen($table)
{
$sqlite = new sqlite();
$data = $sqlite->query("SELECT * FROM {$table}");
$data = json_decode(json_encode($data), true);
//print_r($data);
return $data;
}
