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; }