Ejemplo n.º 1
0
 function pullVisits($date = null)
 {
     $date or $date = static::today();
     $query = $this->adapter->getDataQuery()->addMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_VISITORS)->addMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->addMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_PAGEVIEWS)->addMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_UNIQUE_PAGEVIEWS)->addDimension(\Zend_Gdata_Analytics_DataQuery::DIMENSION_DATE)->addSort(\Zend_Gdata_Analytics_DataQuery::DIMENSION_DATE)->setStartDate($date)->setEndDate($date);
     $result = $this->adapter->getDataFeed($query);
     $found = $result->count();
     $updated = 0;
     foreach ($result as $r) {
         try {
             \DB::pdo()->executeQuery(static::QUERY, array('created' => $date, 'name' => 'visit', 'countTotal' => @$r->getMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_VISITS)->getValue(), 'countUnique' => @$r->getMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_VISITORS)->getValue()));
             $updated++;
         } catch (\Exception $unimportant) {
             if ($unimportant->getCode() != 23000) {
                 \Zend_Registry::get('log')->err($unimportant->getMessage());
             }
         }
         try {
             \DB::pdo()->executeQuery(static::QUERY, array('created' => $date, 'name' => 'pageview', 'countTotal' => @$r->getMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_PAGEVIEWS)->getValue(), 'countUnique' => @$r->getMetric(\Zend_Gdata_Analytics_DataQuery::METRIC_UNIQUE_PAGEVIEWS)->getValue()));
             $updated++;
         } catch (\Exception $unimportant) {
             if ($unimportant->getCode() != 23000) {
                 \Zend_Registry::get('log')->err($unimportant->getMessage());
             }
         }
     }
     return array('itemsFound' => $found, 'itemsUpdated' => $updated);
 }
Ejemplo n.º 2
0
 public static function singleton()
 {
     if (!is_object(self::$pdo)) {
         self::$pdo = new PDO('mysql:dbname=' . self::DATABASE . ';host=' . self::HOST, self::USERNAME, self::PASSWORD);
     }
     return self::$pdo;
 }
Ejemplo n.º 3
0
 public static function getInstance()
 {
     if (is_null(self::$pdo)) {
         self::$pdo = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_BASE, DB_USER, DB_PASS, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
     }
     return self::$pdo;
 }
Ejemplo n.º 4
0
Archivo: DB.php Proyecto: alexelev/bmf
 /**
  * open connect to database
  * @param string $host dbhost
  * @param string $login database user's login
  * @param string $pass database user's password
  * @param string $name database's name
  * @param string $charset database's charset
  * @throws DatabaseException if it has connection error
  */
 public static function connect($host, $login, $pass, $name, $charset)
 {
     $dsn = "mysql:host={$host};dbname={$name}";
     try {
         self::$pdo = new PDO($dsn, $login, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES {$charset}"));
     } catch (PDOException $e) {
         throw new DatabaseException("Connection error");
     }
 }
Ejemplo n.º 5
0
 public static function init()
 {
     self::$pdo = new PDO('mysql:host=' . SERVER . ';dbname=' . DBNAME, USER, PASS);
     self::$pdo->exec("SET NAMES 'UTF8'");
     self::$pdo->exec("SET character_set_connection = 'UTF8'");
     self::$pdo->exec("SET character_set_client = 'UTF8'");
     self::$pdo->exec("SET character_set_results = 'UTF8'");
     self::$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_OBJ);
     return self::$pdo;
 }
Ejemplo n.º 6
0
 public static function get()
 {
     if (self::$pdo == null) {
         $host = DB_HOST;
         $dbname = DB_NAME;
         $dbuser = DB_USER;
         $dbpass = DB_PASSWORD;
         self::$pdo = new PDO("mysql:host={$host};dbname={$dbname}", $dbuser, $dbpass);
         self::$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     }
     return self::$pdo;
 }
Ejemplo n.º 7
0
 public static function getPDO()
 {
     if (is_null(self::$pdo)) {
         //            $dsn = 'mysql:dbname=papangping_nai;host=localhost';
         //            $user = '******';
         //            $password = '******';
         $dsn = 'mysql:dbname=nai;host=localhost';
         $user = '******';
         $password = '******';
         self::$pdo = new PDO($dsn, $user, $password);
         self::$pdo->exec("set names utf8");
     }
     return self::$pdo;
 }
Ejemplo n.º 8
0
 static function init()
 {
     if (self::$pdo !== null) {
         return;
     }
     global $global;
     if (!isset($global['db'])) {
         exit('classic case of no db definition found');
     }
     extract($global['db']);
     try {
         self::$pdo = new PDO("mysql:host={$host};dbname={$db}", $user, $pass);
     } catch (PDOException $e) {
         throw new Exception('Could not connect to database: ' . $e->getMessage());
     }
     register_shutdown_function(function () {
         // auto close database connection upon script termination so mysql can shove a c**k in its ass
         self::$pdo = null;
     });
     return self::$pdo !== null;
 }
Ejemplo n.º 9
0
/**
* Author: UP687776 
* Web Script Programming
* Rich Boakes && Kit Lester
* 2014 && 2015 
*/
require 'DBConnect/db.php';
class products
{
    public $ProductID;
    public $CategoryID;
    public $ProductName;
    public $ProductDescription;
    public $ProductPrice;
    public $ProductStockLevel;
    public $ProductImage;
}
$search = $_GET["input"];
try {
    $database = new DB();
    $bind = null;
    $sql = "SELECT * FROM Products WHERE ProductName LIKE :searchterm";
    $a = $database->pdo()->prepare($sql);
    $a->execute(array(":searchterm" => "%" . $search . "%"));
    $rows = $a->fetchAll(PDO::FETCH_CLASS, "products");
    foreach ($rows as $row) {
        print "<section class='layout'><p>ProductID: " . $row->ProductID . "</p><h4> " . $row->ProductName . "</h4><p class='writeUp'>" . $row->ProductDescription . "</p><p class='writeUp'>£" . $row->ProductPrice . "</p><p class='writeUp'>Stock Level:" . $row->ProductStockLevel . "</p><img class='productImage' src=../images/productImages/" . $row->ProductImage . "><button id=" . $row->ProductID . "> Add To Cart </button></section>";
    }
} catch (PDOException $e) {
    echo $e;
}
Ejemplo n.º 10
0
 /**
  * Sets up the driver and the PDO connection.
  *
  * @access public
  * @static
  */
 public static function setup()
 {
     // connect to the DB
     self::$pdo = new PDO(strtolower(Reg::get("Database.driver")) . ':host=' . Reg::get('Database.host') . ';dbname=' . Reg::get('Database.database'), Reg::get('Database.username'), Reg::get('Database.password'), array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
     // load the driver
     $specific_driver = Reg::get("Database.driver");
     $driver_name = "DB_{$specific_driver}_Driver";
     self::$driver = new $driver_name();
 }
Ejemplo n.º 11
0
 public function __construct()
 {
     DB::$pdo = new PDO('mysql:host=' . BDHOST . ';dbname=' . BDNAME . '', BDLOGIN, BDPASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\''));
 }
Ejemplo n.º 12
0
 public static function connect(Config $config)
 {
     self::$pdo = new PDO("mysql:host=" . $config->dbHost . ";dbname=" . $config->dbName, $config->dbUser, $config->dbPass);
 }
Ejemplo n.º 13
0
	protected function getConnection()
	{
		 return $this->createDefaultDBConnection(DB::pdo(), 'testdb');
	}
Ejemplo n.º 14
0
/**
* Update Product Function 
* Receive record in JASON Formatted String from client side and decode it and convert the product into an object which can go onto the database
* The "php://input" allows the user to read raw POST data.
* @parameter: ProductID: update the record/product by specifying produc id
* var_dump displays information about one or more expression (productName and productPrice)
* Create new database if it doesn't exists
*/
function updateProducts($ProductID)
{
    $info = json_decode(file_get_contents("php://input"), true);
    $database = new DB();
    var_dump(file_get_contents("php://input"));
    $sql = "UPDATE Products SET ProductName = '" . $info['ProductName'] . "', Price = '" . $info['ProductPrice'] . "' WHERE ProductID = {$ProductID}";
    $a = $database->pdo()->prepare($sql);
    $a->execute();
}