Author: xuanyan (xuanyan@geek-zoo.com)
Inheritance: extends DatabaseAbstract, implements DatabaseWrapper
 /**
  * Static method for creating PDOWrapper object with MYSQL connection
  *
  * @param   string  $host           Mysql host
  * @param   string  $dbName         Mysql database name
  * @param   string  $username       Mysql user name
  * @param   string  $password       Mysql password
  * @param   string  $charset        Connection charset
  * @return PDOWrapper
  */
 public static function openMysql($host, $dbName, $username, $password, $charset = "")
 {
     $wrapper = new PDOWrapper("mysql:host={$host};dbname={$dbName}", $username, $password);
     if ($charset && !$wrapper->getLastError()) {
         $wrapper->query("SET NAMES ?", array($charset));
     }
     return $wrapper;
 }
Ejemplo n.º 2
0
 /**
  * To initialize the first connection you need at least the PDO parameters in a assoc array
  * It's possible to use more parameters. Here ist the complete array
  *
  *  $config =   [
  *                  EQM::CONVENTION_HANDLER => <object that implements ConventionHandlerInterface>
  *                  EQM::SQL_BUILDER => <object that implements SqlBuilderInterface>
  *              ]
  *
  * @param \PDO $pdo a valid PDO connection object
  * @param array $config allowed keys [result_Set_class (class name)
  *                      convention_handler (object), sql_builder (object)]
  * @param string $connectionName optional for multiple connections 'default' is the standard
  */
 public static function initialize($pdo, $config = [], $connectionName = 'default')
 {
     parent::initialize($pdo, $config, $connectionName);
     static::$metaCache[$connectionName] = [];
     if (array_key_exists(static::CONVENTION_HANDLER, $config) && $config[static::CONVENTION_HANDLER] instanceof ConventionHandlerInterface) {
         static::$conventionHandler[$connectionName] = $config[EQM::CONVENTION_HANDLER];
     } else {
         static::$conventionHandler[$connectionName] = new DefaultConventionHandler();
     }
     if (array_key_exists(static::SQL_BUILDER, $config) && $config[static::SQL_BUILDER] instanceof SqlBuilderInterface) {
         static::$sqlBuilder[$connectionName] = $config[static::SQL_BUILDER];
     } else {
         static::$sqlBuilder[$connectionName] = new MySqlBuilder();
     }
 }
Ejemplo n.º 3
0
Archivo: handler.php Proyecto: Zbee/api
<?php

#Specifying that the return is JSON
header('Content-Type: application/json');
#Include passwords and keys
require '_secret_keys.php';
#Include functions
require 'libs/functions.php';
#Include database abstraction
require 'vendor/mikehenrty/thin-pdo-wrapper/src/PDOWrapper.php';
#Set up database abstraction
$pdo = PDOWrapper::instance();
$pdo->configMaster($db[0], $db[1], $db[2], $db[3]);
#setup in _secret_keys.php
#Require a key (private endpoints)
function requireKey()
{
    global $argumentsU;
    global $arguments;
    global $pdo;
    if (!array_key_exists("key", $arguments)) {
        throw new Exception('Key required to access this private endpoint (arguments: ' . $argumentsU . ')');
    }
    if (strlen($arguments["key"]) != 20) {
        throw new Exception('Key provided is of an incorrect length (' . $arguments["key"] . ' (' . strlen($arguments["key"]) . '))');
    }
}
#Require initial data
function requirePost($fields)
{
    foreach ($fields as $field => $type) {
Ejemplo n.º 4
0
 public function testDBConnect()
 {
     new DBConfig();
     $pdo = PDOWrapper::getInstance(DBConfig::$dsn, DBConfig::$username, DBConfig::$password);
     $this->assertEquals(true, $pdo instanceof PDO);
 }
Ejemplo n.º 5
0
 /**
  * method instance.
  * 	- static, for singleton, for creating a global instance of this object
  *
  * @return - PDOWrapper Object
  */
 public static function instance()
 {
     if (!isset(self::$instance)) {
         self::$instance = new PDOWrapper();
     }
     return self::$instance;
 }
Ejemplo n.º 6
0
 /**
  * Constructor.
  * Note:
  *   This function is set to private in order to prevent others from calling this function. Only this class itself can call this function.
  *   You can find an other example(in Japanese) at http://d.hatena.ne.jp/ja9/20090515/1242374821
  *
  * @param String $dsn      dsn string to connect database
  * @param String $username username to connect
  * @param String $password password to connect
  */
 private function __construct($dsn, $username, $password)
 {
     self::$instance = new PDO($dsn, $username, $password);
 }
Ejemplo n.º 7
0
 /**
  * Checks login/pasword against the DB records and changes to the new one
  * returns result wrapped within HTML
  *
  * @param string $login
  * @param string $old_password
  * @param string $new_password1
  * @param string $new_password2
  * @return bool true on success, false elsewhere
  */
 private function tryChangePassword($login, $old_password, $new_password1, $new_password2, &$result)
 {
     // check if login correct
     if (!preg_match(self::REGEXP_USERNAME, $login)) {
         $result = sprintf(self::HTML_MESSAGE_FAIL, 'Неверное имя пользователя или пароль');
         return false;
     }
     // check if current password ok
     if (!$this->checkPassword($login, $old_password)) {
         $result = sprintf(self::HTML_MESSAGE_FAIL, 'Неверное имя пользователя или пароль');
         return false;
     }
     // check if new passwords are same
     if ($new_password1 != $new_password2) {
         $result = sprintf(self::HTML_MESSAGE_FAIL, 'Пароли не совпадают');
         return false;
     }
     try {
         $DB = new PDOWrapper($this->CONFIG['database']['server_driver'], $this->CONFIG['database']['server_host'], $this->CONFIG['database']['server_login'], $this->CONFIG['database']['server_password'], $this->CONFIG['database']['server_db_name']);
         if (isset($this->CONFIG['secret_field']) && $this->CONFIG['secret_field'] > '') {
             $secret = $DB->querySingle("select `{$this->CONFIG['secret_field']}` from `{$this->CONFIG['table']}` where `{$this->CONFIG['login_field']}` = '{$login}'");
         } else {
             $secret = $this->CONFIG['secret_default'];
         }
         $new_hash = $this->generateHash($new_password1, $secret);
         $DB->exec("update `{$this->CONFIG['table']}` set `{$this->CONFIG['md5_field']}` = '{$new_hash}' where `{$this->CONFIG['login_field']}` = '{$login}'");
     } catch (Exception $e) {
         $result = '[JuliaCMS][AUTH] WARNING: failed changing password: '******'Пароль успешно изменен');
     return true;
 }