PHP Quaver\Model Project::getFromId Examples

Example #1

File: User.php Project: kingrock/product-hunt-clone

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

Example #2

File: link.php Project: kingrock/product-hunt-clone

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

Example #3

File: Project.php Project: kingrock/product-hunt-clone

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