function createPDO()
{
$pdo = new \PDO('mysql:host=' . BOT_DB_HOST . ';dbname=' . BOT_DB_NAME . ';charset=utf8', BOT_DB_USER, BOT_DB_PASSWORD);
$pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
return $pdo;
}
/**
* 根据读写性要求设置一个适合的pdo对象
*
* @param $rw 服务器的读写性
* @return object
*/
public function getConnection($rw = 'rw')
{
$params = $this->_params;
//如果是只读查询，从所有服务器中随机挑选一台
if ($rw == 'r') {
$rw = 'all';
}
if (isset($this->_pdos[$rw]) && $this->_pdos[$rw] instanceof PDO) {
$this->_pdo = $this->_pdos[$rw];
return $this->_pdo;
}
//随机从满足读写性要求的服务器中挑选出一台服务器
$index = rand(0, sizeof($params[$rw]) - 1);
$params = $params[$rw][$index];
if (!isset($params['port'])) {
$params['port'] = '3306';
}
$dsn = "mysql:host={$params['host']};port={$params['port']};dbname={$params['dbname']}";
$pdo = new PDO($dsn, $params['username'], $params['password']);
if ($params['persistent']) {
$pdo->setAttribute(PDO::ATTR_PERSISTENT, true);
}
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec("SET NAMES {$params['charset']}");
$this->_pdo = $pdo;
$this->_pdos[$rw] = $pdo;
return $this->_pdo;
}
/**
* @throws DBException
* @return Resource
*/
public function connect()
{
if ($this->link != null) {
return true;
}
$_config = $this->config;
$_dsn = "{$_config['db_type']}:host={$_config['db_host']};port={$_config['db_port']};dbname={$_config['db_name']}";
try {
$this->link = new PDO($_dsn, $_config['db_user'], $_config['db_pass'], array(PDO::ATTR_PERSISTENT => false));
$this->link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//设置数据库编码，默认使用UTF8编码
$_charset = $_config['db_charset'];
if (!$_charset) {
$_charset = 'UTF8';
}
$this->link->query("SET names {$_charset}");
$this->link->query("SET character_set_client = {$_charset}");
$this->link->query("SET character_set_results = {$_charset}");
} catch (PDOException $e) {
if (APP_DEBUG) {
E("数据库连接失败" . $e->getMessage());
}
}
return $this->link;
}
/**
* Setting default values on the PDO instance like errormode, encoding and
* so on.
*/
public function setDefaultAttributes()
{
$this->_pdo->setAttribute(\PDO::ATTR_CASE, \PDO::CASE_NATURAL);
$this->_pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->_pdo->setAttribute(\PDO::ATTR_ORACLE_NULLS, \PDO::NULL_TO_STRING);
$this->_pdo->query("SET NAMES utf8");
}
function getConnection()
{
switch ($_SERVER['SERVER_NAME']) {
case DEVELOPMENT:
// development server
// header('Access-Control-Allow-Origin: http://localhost:9000');
$dbhost = "localhost";
$dbuser = "******";
$dbpass = "";
$dbname = "test";
break;
default:
// live server
// header('Access-Control-Allow-Origin: http://beatle.par-ken.com');
$dbhost = "sql.ayyayo.com";
$dbuser = "******";
$dbpass = "******";
$dbname = "parken_healthylife";
break;
}
$dbh = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
return $dbh;
}
/**
* @param \PDO $conn
* @return bool if connection if actually connected
*/
public function set_connection(\PDO $conn)
{
$this->_connection = $conn;
//Throw exeption when INSERT fail (Logs should made the whole app fail. Lol.)
$this->_connection->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
return $this->_is_connected();
}
function dbconnect()
{
$db = new PDO('mysql:host=localhost;dbname=makfood;charset=utf8', 'root', '');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
return $db;
}
protected function init()
{
if (!$this->is_initialised) {
$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->is_initialised = TRUE;
}
}
/**
* @param String $prefix the prefix of the table names.
*/
public function __construct(\PDO $pdo, $prefix = "bav_")
{
$this->pdo = $pdo;
$this->prefix = $prefix;
$this->statementContainer = new StatementContainer($pdo);
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
}
public function __construct($path)
{
if ($path !== ':memory:' && !is_file($path)) {
touch($path);
// ensures ordinary file permissions
}
$this->pdo = new \PDO('sqlite:' . $path);
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->pdo->exec('
PRAGMA foreign_keys = ON;
CREATE TABLE IF NOT EXISTS cache (
key BLOB NOT NULL PRIMARY KEY,
data BLOB NOT NULL,
expire INTEGER,
slide INTEGER
);
CREATE TABLE IF NOT EXISTS tags (
key BLOB NOT NULL REFERENCES cache ON DELETE CASCADE,
tag BLOB NOT NULL
);
CREATE INDEX IF NOT EXISTS cache_expire ON cache(expire);
CREATE INDEX IF NOT EXISTS tags_key ON tags(key);
CREATE INDEX IF NOT EXISTS tags_tag ON tags(tag);
PRAGMA synchronous = OFF;
');
}
function login()
{
$db = new PDO('mysql:host=localhost;dbname=test;charset=utf8', 'root', 'root');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
if (!empty($_POST['contact_submitted'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$stmt = $db->prepare("SELECT * FROM users WHERE username=?");
$stmt->execute(array($username));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!$rows) {
echo "<script>alert('wrong username/password');</script>";
}
/*
Than we validate the password, if the validation is true than we set the sessions
For more detailed information on password validation check please look into the
Password storage(salting/stretching/hashing) in the knowledgebase for more information.
*/
foreach ($rows as $loginUser) {
if ($loginUser['password'] == $password) {
session_start();
$_SESSION['userID'] = $loginUser['userID'];
$_SESSION['access'] = "active";
//The CSRF token is set here by an aproved random number generator
$_SESSION['csrf'] = base64_encode(openssl_random_pseudo_bytes(128));
header("location:loggedin.php?userID=" . $loginUser['userID'] . "");
return $loginUser;
} else {
echo "<script>alert('wrong password!');</script>";
}
}
}
}
/**
* Connect to a database via FS_PDO
*
* @param mixed $dsn data source for database connection (array or string)
* @param $login
* @param $password
*/
public function connect_db($dsn, $login, $password)
{
try {
$this->db = new PDO($dsn, $login, $password);
} catch (PDOException $e) {
$this->debug($e->getMessage());
$this->file_not_found();
//program terminates in function file_not_found()
}
$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$driver = $this->db->getAttribute(PDO::ATTR_DRIVER_NAME);
$this->debug("our driver is {$driver}");
switch ($driver) {
case 'mysql':
$quoter = '`';
break;
case 'pgsql':
if (DEFAULT_DSN_SCHEMA) {
$this->db->exec('SET SEARCH_PATH=' . DEFAULT_DSN_SCHEMA);
}
$quoter = '"';
break;
default:
$quoter = '';
break;
}
define('DB_FIELD_QUOTE', $quoter);
}
function db_mysql_init(PDO $pdo)
{
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute(PDO::ATTR_ORACLE_NULLS, PDO::NULL_EMPTY_STRING);
$pdo->setAttribute(PDO::ATTR_AUTOCOMMIT, false);
$pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
}
protected function setUp()
{
$this->PDO = DB::getInstance();
$this->PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->PDO->exec('INSERT INTO `runalyze_training` (`accountid`) VALUES (0)');
$this->ActivityID = $this->PDO->lastInsertId();
}
protected function setUp()
{
$this->PDO = new PDO('sqlite::memory:');
$this->PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->PDO->exec('CREATE TEMP TABLE `' . PREFIX . 'withoutid` ( `foo` VARCHAR(10), `arr` VARCHAR(100) )');
$this->PDO->exec('CREATE TEMP TABLE `' . PREFIX . 'withid` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT, `foo` VARCHAR(10) )');
}
public static function connect($database)
{
$db = new PDO('mysql:host=' . constant('Y_003') . ';dbname=' . $database . ';charset=utf8', constant('Y_001'), constant('Y_002'));
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
return $db;
}
public function __construct($_uid)
{
try {
// Connect to the data base and select it.
$db = new PDO("mysql:host=localhost;dbname=Grad_Prog_V5;charset=utf8", "root", "200337226");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$query = "SELECT * from Grad_Prog_V5.users where uid = " . $_uid;
$statement = $db->prepare($query);
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
$this->firstname = htmlspecialchars($row['first_name']);
$this->lastname = htmlspecialchars($row['last_name']);
$this->email = htmlspecialchars($row['email']);
$this->phone = htmlspecialchars($row['phone_number']);
$this->uid = $_uid;
}
} catch (PDOException $ex) {
$studentslist .= "<p>oops</p>";
$studentslist .= "<p> Code: {$ex->getCode()} </p>";
$studentslist .= " <p> See: dev.mysql.com/doc/refman/5.0/en/error-messages-server.html#error_er_dup_key";
$studentslist .= "<pre>{$ex}</pre>";
}
}
protected function configure()
{
$this->pdo = new \PDO($this->getOption('dsn'), $this->getOption('username'), $this->getOption('password'));
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->driverName = $this->pdo->getAttribute(\PDO::ATTR_DRIVER_NAME);
$this->configureDriver();
}
function dbConnection()
{
$dbHost = "";
$dbPort = "";
$dbUser = "";
$dbPassword = "";
$openShiftVar = getenv('OPENSHIFT_MYSQL_DB_HOST');
if ($openShiftVar === null || $openShiftVar == "") {
$dbHost = 'localhost';
$dbUser = '******';
$dbPassword = '******';
$dbName = 'signup';
} else {
// In the openshift environment
//echo "Using openshift credentials: ";
$dbHost = getenv('OPENSHIFT_MYSQL_DB_HOST');
$dbPort = getenv('OPENSHIFT_MYSQL_DB_PORT');
$dbUser = getenv('OPENSHIFT_MYSQL_DB_USERNAME');
$dbPassword = getenv('OPENSHIFT_MYSQL_DB_PASSWORD');
}
echo "host:{$dbHost}:{$dbPort} dbName:{$dbName} user:{$dbUser} password:{$dbPassword}<br >\n";
try {
$db = new PDO("mysql:host={$dbHost};dbname={$dbName}", $dbUser, $dbPassword);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
} catch (Exception $ex) {
echo 'Sorry the connection is not working properly right now';
}
if (is_object($db)) {
return $db;
} else {
return FALSE;
}
}
function getConnection()
{
// Variables defined in /config/config.php
$hostname = MYSQL_HOSTNAME;
$database = MYSQL_DATABASE;
$username = MYSQL_USERNAME;
$password = MYSQL_PASSWORD;
try {
// Create handle to database
$dbh = new PDO("mysql:host={$hostname};dbname={$database}", $username, $password);
// Throw PDOExceptions to catch
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Buffered queries, MySQL specific
$dbh->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
return $dbh;
} catch (PDOException $e) {
error_log("Cannot connect to database : " . $e->getMessage());
$request = new Lvc_Request();
$request->setControllerName('error');
$request->setActionName('view');
$request->setActionParams(array('error' => '500'));
// Get a new front controller without any routers,
// and have it process our handmade request.
$fc = new Lvc_FrontController();
$fc->processRequest($request);
exit;
}
}
/**
* Connect to local sqlite db
*
* @param string $locking_mode
* @return \PDO
*/
private function cache_local_connect($locking_mode = 'NORMAL')
{
try {
$table = <<<EOD
CREATE TABLE "cachedb" (
"itemid" INTEGER PRIMARY KEY AUTOINCREMENT,
"title" TEXT,
"link" TEXT,
"stemmed" TEXT,
"metaphone" TEXT,
"ts" DATETIME DEFAULT (datetime( 'now', 'utc'))
);
EOD;
$cachelocal = new \PDO('sqlite::memory:');
$cachelocal->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$cachelocal->setAttribute(\PDO::ATTR_TIMEOUT, 20);
$cachelocal->exec("PRAGMA locking_mode = {$locking_mode}");
$cachelocal->exec($table);
// Create custom function for similar titles
$cachelocal->sqliteCreateFunction('similarity', array('Rss\\Util\\Cache\\FeedCache\\FeedCache', 'SIMILARITY'), 2);
// Create custom function for all terms in a title included in a published one.
$cachelocal->sqliteCreateFunction('allterms', array('Rss\\Util\\Cache\\FeedCache\\FeedCache', 'ALLTERMS'), 2);
return $cachelocal;
} catch (\Exception $e) {
$m = 'Error connecting to sqlite ' . $e->getCode() . ' ' . $e->getMessage();
$this->fail($m);
}
}
/**
* Created by PhpStorm.
* User: Florian Moser
* Date: 09.01.2016
* Time: 14:46
*/
function GetDatabaseConnection()
{
$db = new PDO("sqlite:database.sqlite");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
return $db;
}
function sqllink()
{
global $DB_HOST, $DB_NAME, $DB_USER, $DB_PASSWORD;
$dbhost = $DB_HOST;
$dbname = $DB_NAME;
$dbusr = $DB_USER;
$dbpwd = $DB_PASSWORD;
$dbhdl = NULL;
if (defined('PDO::MYSQL_ATTR_MAX_BUFFER_SIZE')) {
$opt = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8', PDO::MYSQL_ATTR_MAX_BUFFER_SIZE => 1024 * 1024 * 19);
} else {
$opt = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8');
}
$dsn = 'mysql:host=' . $dbhost . ';dbname=' . $dbname . ';charset=utf8';
try {
$dbhdl = new PDO($dsn, $dbusr, $dbpwd, $opt);
$dbhdl->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbhdl->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//Display exception
} catch (PDOExceptsddttrtion $e) {
//return PDOException
return NULL;
}
return $dbhdl;
}
/**
* Try to connect to database
*
* @return \PDO
* @throws Exception
*/
public function connect()
{
if (!$this->isConnected()) {
$dsn = 'mysql:host=' . $this->connOpts['db_host'] . ';dbname=' . $this->connOpts['db_name'];
$options = array(\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES "' . $this->connOpts['charset'] . '";');
// @todo 1. валидация 2. setAttributes
if (!empty($this->connOpts['attr'])) {
$options = $options + $this->connOpts['attr'];
}
$profilerEnabled = $this->isProfilerEnabled();
try {
if ($profilerEnabled) {
$this->profiler->start('CONNECT');
}
$this->pdo = new \PDO($dsn, $this->connOpts['username'], $this->connOpts['password'], $options);
$this->pdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$this->pdo->setAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_ASSOC);
if ($profilerEnabled) {
$this->profiler->stop();
}
} catch (\PDOException $e) {
throw new Exception('DB CONNECT ERROR: ' . $e->getMessage());
}
}
return $this->pdo;
}
/**
* Creates, when necessary, and returns a PDO instance
* @return PDO
*/
public static function getInstance($usesTransaction = false) {
try {
if (!self::$instance) {
self::$instance = new \PDO(
\core\Config::DATABASE_ADDRESS,
\core\Config::DATABASE_USERNAME,
\core\Config::DATABASE_PASSWORD,
array(
\PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
\PDO::ATTR_PERSISTENT => true
)
);
self::$instance->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
}
if ($usesTransaction && !self::$openTransaction) {
self::$instance->beginTransaction();
self::$openTransaction = true;
}
return self::$instance;
} catch (\Exception $e) {
$ex = new RepositoryException($e);
$ex->setFatal(true);
throw $ex;
}
}
protected function setUp()
{
$this->PDO = DB::getInstance();
$this->PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$this->PDO->exec('INSERT INTO `' . PREFIX . 'equipment_type` (`name`, `accountid`) VALUES ("Test", 1)');
$this->Typeid = $this->PDO->lastInsertId();
}
public function init()
{
if (Yaf_Session::getInstance()->has('username')) {
$this->getView()->assign('username', Yaf_Session::getInstance()->offsetGet('username'));
} else {
return $this->redirect('/Login');
}
$dsn = 'mysql:host=127.0.0.1;dbname=yafdemo;charset=utf8';
$username = '******';
$password = '******';
$dbo = new PDO($dsn, $username, $password);
$dbo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$dbo->exec('SET NAMES UTF8');
$this->dbo = $dbo;
$request = $this->getRequest();
$module = strtolower($request->getModuleName());
$controller = strtolower($request->getControllerName());
$action = strtolower($request->getActionName());
if (!$this->_checkPerm($module, $controller, $action) && $action != 'logout') {
$this->getView()->setScriptPath(APPLICATION_PATH . "/application/views");
$this->getView()->display('common/403.phtml');
Yaf_Dispatcher::getInstance()->autoRender(FALSE);
exit;
}
}
function dbconnect()
{
$db = new PDO(MYSQL_SERVER . ";" . MYSQL_DB, MYSQL_USER, MYSQL_PASS);
$db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $db;
}
function pdoConnect($dbs = null)
{
if ($dbs) {
$dbname = $this->_strDBSName;
$dbuser = $this->_strDBSUser;
$dbpass = $this->_strDBSPassword;
} else {
$dbname = $this->_strDBName;
$dbuser = $this->_strDBUser;
$dbpass = $this->_strDBPassword;
}
try {
ini_set('max_execution_time', 300);
$dsn = "mysql:host=" . $this->_strDBHost . ";dbname=" . $dbname;
$db = new PDO($dsn, "{$dbuser}", "{$dbpass}");
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$db->exec("SET names utf8");
$db->exec("SET time_zone = 'your timezone'");
} catch (PDOException $e) {
print "Error!: " . $e->getMessage() . "<br/>";
die;
}
return $db;
}
function connectMysql($db = 'sta')
{
global $DB, $DBsta, $DBdyn;
require 'local/mysql-data.inc.php';
// Connexion bdd PDO
try {
$dbname = $DBsta;
if ($db == 'dyn') {
$dbname = $DBdyn;
}
// Connexion à la base de données
$DB = new PDO('mysql:host=' . $DBserver . ';dbname=' . $dbname, $DBuser, $DBpass, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
// Configuration du pilote : nous voulons des exceptions
$DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Obligatoire pour la suite
$DB->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
// Uniquement associatif
} catch (Exception $e) {
echo "Echec : " . $e->getMessage();
// afficher les erreurs(sans mot de passe ...)
}
$DBserver = '';
$DBuser = '';
$DBpass = '';
}
