public static function get_from_email($email) { global $g_pdo; $request = <<<EOF SELECT id FROM `guest` WHERE `email`= :email EOF; debug($request); $pst = $g_pdo->prepare($request); $pst->execute(array(":email" => $email)); $record = $pst->fetch(PDO::FETCH_ASSOC); if (!isset($record['id'])) { return NULL; } $guest = Record::get_from_id("guest", $record['id']); return $guest; }
public static function pop() { global $g_pdo; $request = <<<EOF SELECT id FROM task WHERE start_t < :now AND status = :status LIMIT 1 EOF; debug($request); $pst = $g_pdo->prepare($request); $pst->execute(array(":now" => time(), ":status" => TASK_STATUS_PENDING)); $record = $pst->fetch(PDO::FETCH_ASSOC); if (!isset($record['id'])) { return null; } return Record::get_from_id("task", $record['id']); }
public function execute_action($action) { $record = null; if (isset($_GET["id"])) { $record = Record::get_from_id($this->name, $_GET["id"]); } else { $record = new $this->classname(); } $record->{$action}(); }
public static function multi_action($action) { //$id_array = explode("_", $_GET["ids"]); $id_array = $_GET["ids"]; foreach ($id_array as $id) { $record = Record::get_from_id($_GET["type"], $id); if ($record != null) { $record->{$action}(); } } }