Skip to content

Instantly share code, notes, and snippets.

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@asifr
asifr / example_implementation.php
Last active August 29, 2015 14:13
An email-based authentication system
$IsAuth = false;
$User = array();
// connect to database
try { $db = new PDO('sqlite:'.BASEPATH.DBNAME); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); } catch (PDOException $e) { die('Unable to open database. SQLite reported: '.$e->getMessage()); }
// create table if it doesn't already exist
if (count($db->query('SELECT 1 FROM sqlite_master WHERE name = \'users\' AND type=\'table\'')->fetchAll()) == 0) { $db->exec("CREATE TABLE users (id INTEGER NOT NULL,name VARCHAR(255) DEFAULT '',email VARCHAR(255) DEFAULT '',token VARCHAR(255) DEFAULT '',vars TEXT,created INTEGER,status INTEGER NOT NULL DEFAULT 0,PRIMARY KEY (id));"); }
// Set token for user and send email
@asifr
asifr / data.json
Last active September 19, 2015 01:30
Punchcard visualization using D3.js
[{"articles": [[2010, 6], [2011, 10], [2012, 11], [2013, 23], [2006, 1]],
"total": 51, "name": "The Journal of neuroscience"},
{"articles": [[2008, 1], [2010, 3], [2011, 4], [2012, 17], [2013, 10]],
"total": 35, "name": "Nature neuroscience"}]