public function getPointsAdded() { try { $db = new DB(); $return = array(); $_hP = new Project(); //helper $_id = $this->id; $items = $db->query("SELECT p.id \n FROM " . $_hP->table . " p, " . $_hP->table_points . " i\n WHERE p.id = i.project AND p.active = 1 AND i.user = '******' ORDER BY p.started DESC"); if ($items) { foreach ($items->fetchAll() as $item) { $obj_p = new Project(); $return[] = $obj_p->getFromId($item['id']); } } } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } return $return; }
<?php /* * Copyright (c) 2014 Alberto González * Distributed under MIT License * (see README for details) */ namespace Quaver\Controller; use Quaver\Model\Project; // Set vars $_id = null; $p = null; $obj_project = null; $_id = $this->url_var[1]; if (isset($_id)) { $obj_project = new Project(); $p = $obj_project->getFromId($_id); header("Location: " . $p->url); exit; } else { header("Location: /"); exit; }
/** * getLastProjects function. * * @access public * @return void */ public function getLastProjects($_date) { $return = NULL; try { $db = new DB(); $return = array(); $items = $db->query("SELECT id \n FROM " . $this->table . " \n WHERE active = 1 AND DATE(started) = '" . $_date . "' ORDER BY started DESC"); if ($items) { foreach ($items->fetchAll() as $item) { $obj_p = new Project(); $return[] = $obj_p->getFromId($item['id']); } } } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "<br/>"; die; } return $return; }