/**
* Extends default connection method. It will be useful in order to
* allow accents and other DB-centric global commands.
*
* @param string $connect_string a PDO connection string
* @param string $db_user the database user name
* @param string $db_pass the database user password
* @return boolean TRUE on success, FALSE on error
*/
public function connect($connect_string, $db_user, $db_pass)
{
// If something went wrong, we don't need to exec the specific commands.
if (!parent::connect($connect_string, $db_user, $db_pass)) {
return false;
}
return true;
}
protected static final function openConnection($driver)
{
$adapter = 'Adapter' . $driver;
include_once dirname(__FILE__) . '/adapter/' . $adapter . '.php';
$connection = new DatabaseConnection(new $adapter());
$cfg = self::getConnectionConf();
$connection->connect($cfg['engine'], $cfg['hostname'], $cfg['database'], $cfg['username'], $cfg['password']);
return $connection;
// end function
}
/**
* Extends default connection method. It will be useful in order to
* allow accents and other DB-centric global commands.
*
* @param string $connect_string a PDO connection string
* @param string $db_user the database user name
* @param string $db_pass the database user password
* @return boolean TRUE on success, FALSE on error
*/
public function connect($connect_string, $db_user, $db_pass)
{
// If something went wrong, we don't need to exec the specific commands.
if (!parent::connect($connect_string, $db_user, $db_pass)) {
return false;
}
$this->pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
// Everything is OK. Let's update the charset!
if (!defined('MYSQL_CHAR_SET')) {
define('MYSQL_CHAR_SET', 'UTF8');
}
$this->exec('SET NAMES ' . MYSQL_CHAR_SET);
return true;
}
/**
* Connect to SQLite
* Overrides the DatabaseConnection to return false if the SQLite file doesn't exist.
*
* @param connection_string string a PDO connection string
* @param db_user string the database user name
* @param db_pass string the database user password
* @return boolean True if connection succeeded, false if not.
*/
public function connect($connect_string, $db_user, $db_pass)
{
list($type, $file) = explode(':', $connect_string, 2);
if ($file == basename($file)) {
if (file_exists(HABARI_PATH . '/' . $file)) {
$file = HABARI_PATH . '/' . $file;
} else {
$file = HABARI_PATH . '/' . Site::get_path('user', TRUE) . $file;
}
$connect_string = implode(':', array($type, $file));
}
$conn = parent::connect($connect_string, $db_user, $db_pass);
$this->exec('PRAGMA synchronous = OFF');
return $conn;
}
/**
* Extends default connection method. It will be useful in order to
* allow accents and other DB-centric global commands.
*
* @param string $connect_string a PDO connection string
* @param string $db_user the database user name
* @param string $db_pass the database user password
* @return boolean true on success, false on error
*/
public function connect($connect_string, $db_user, $db_pass)
{
// If something went wrong, we don't need to exec the specific commands.
if (!parent::connect($connect_string, $db_user, $db_pass)) {
return false;
}
$this->pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
// Everything is OK. Let's update the charset!
if (!defined('MYSQL_CHAR_SET')) {
define('MYSQL_CHAR_SET', 'UTF8');
}
// SET NAMES defines character_set_client, character_set_results, and character_set_connection (which implicitly sets collation_connection) and therefore covers everything SET CHARACTER SET does, but uses the character set we tell it to, ignoring what the database is configured to use
// http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
$this->exec('SET NAMES ' . MYSQL_CHAR_SET);
return true;
}
/**
* Extends default connection method. It will be useful in order to
* allow accents and other DB-centric global commands.
*
* @param string $connect_string a PDO connection string
* @param string $db_user the database user name
* @param string $db_pass the database user password
* @return boolean true on success, false on error
*/
public function connect($connect_string, $db_user, $db_pass)
{
// If something went wrong, we don't need to exec the specific commands.
if (!parent::connect($connect_string, $db_user, $db_pass)) {
return false;
}
$this->pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
// Everything is OK. Let's update the charset!
if (!defined('MYSQL_CHAR_SET')) {
define('MYSQL_CHAR_SET', 'UTF8');
}
// SET CHARACTER SET might get the character_set_connection wrong, thus we also need SET NAMES. See http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
$this->exec('SET CHARACTER SET ' . MYSQL_CHAR_SET);
$this->exec('SET NAMES ' . MYSQL_CHAR_SET);
return true;
}
/**
* Connect to SQLite
* Overrides the DatabaseConnection to return false if the SQLite file doesn't exist.
*
* @param connection_string string a PDO connection string
* @param db_user string the database user name
* @param db_pass string the database user password
* @return boolean True if connection succeeded, false if not.
*/
public function connect($connect_string, $db_user, $db_pass)
{
list($type, $file) = explode(':', $connect_string, 2);
if ($file == basename($file)) {
if (file_exists(HABARI_PATH . '/' . $file)) {
$file = HABARI_PATH . '/' . $file;
} else {
$file = HABARI_PATH . '/' . Site::get_path('user', true) . $file;
}
$connect_string = implode(':', array($type, $file));
}
if (file_exists($file) && !is_writable($file)) {
die(_t('Database file "%s" must be writable.', array($file)));
}
$conn = parent::connect($connect_string, $db_user, $db_pass);
$this->exec('PRAGMA synchronous = OFF');
return $conn;
}
/**
* @param $email
* @return bool
*/
public function isAlreadyRegistered($email)
{
//require_once "classes/DatabaseConnection.php";
/**
* Get user by email and password
*/
try {
$databaseHandle = new DatabaseConnection();
$connection = $databaseHandle->connect();
//establish connection to the database
$statement = $connection->prepare("SELECT * FROM " . TABLE_NAME . " WHERE _email=?");
$statement->bindParam(1, $email);
$statement->execute();
//check if the operation was successful
if ($statement->rowCount() > 0) {
return $statement;
}
} catch (PDOException $exception) {
echo $exception->getMessage();
}
return false;
}
/**
* Attempt to connect to the Movable Type database
*
* @access private
* @param string $db_host The hostname of the MT database
* @param string $db_name The name of the MT database
* @param string $db_user The user of the MT database
* @param string $db_pass The user's password for the MT database
* @param string $db_prefix The table prefix for the MT instance in the database
* @return mixed false on failure, DatabseConnection on success
*/
private function mt_connect($db_host, $db_name, $db_user, $db_pass, $db_prefix)
{
// Connect to the database or return false
try {
$mtdb = new DatabaseConnection();
$mtdb->connect("mysql:host={$db_host};dbname={$db_name}", $db_user, $db_pass, $db_prefix);
return $mtdb;
} catch (Exception $e) {
return false;
}
}
<?php
include $_SERVER['DOCUMENT_ROOT'] . '/cabinet/backend/class/reptilicus.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/cabinet/backend/web/domain_manager.php';
$dm = new DomainManager();
if ($dm->isCustomDomain()) {
include $_SERVER['DOCUMENT_ROOT'] . '/cabinet/backend/tpl/index.php';
return;
}
$db = new DatabaseConnection();
$dbconn = $db->connect();
$reptilucText = new reptilucText();
$text = $reptilucText->getTextEn($dbconn, 1);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Login page</title>
<meta name="viewport" content="width=device-width, maximum-scale=1.0, minimum-scale=1.0 initial-scale=1.0">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"
integrity="sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/alertify.js/0.3.11/alertify.core.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/alertify.js/0.3.11/alertify.default.min.css">
<link rel="stylesheet" href="node_modules/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="css/login.css">
</head>
<body ng-app="login" ng-controller="mainCtrl as main">
<div class="login_container">
<div id="reptilicus-login-form">
/**
* Tests whether a connection can be established.
*
* @param string $host
* @param int $port
* @param string $dbname
* @param string $user
* @param string $password
* @return mixed `true` or {@link \PDOException}
*/
public static function test($host, $port, $dbname, $user, $password)
{
try {
$conn = new DatabaseConnection($host, $port);
$conn->init($dbname);
$conn->connect($user, $password);
return true;
} catch (\PDOException $e) {
return $e;
}
}
/**
* Attempt to connect to the Serendipity database
*
* @param string $db_host The hostname of the WP database
* @param string $db_name The name of the WP database
* @param string $db_user The user of the WP database
* @param string $db_pass The user's password for the WP database
* @param string $db_prefix The table prefix for the WP instance in the database
* @param string $db_port The port number of the WP database
* @return mixed false on failure, DatabseConnection on success
*/
private function s9y_connect($db_host, $db_name, $db_user, $db_pass, $db_prefix, $db_port = null)
{
// Connect to the database or return false
try {
$s9ydb = new DatabaseConnection();
$connect_str = "mysql:host={$db_host};dbname={$db_name}";
if (!is_null($db_port)) {
$connect_str .= ";port={$db_port}";
}
$s9ydb->connect($connect_str, $db_user, $db_pass, $db_prefix);
return $s9ydb;
} catch (PDOException $e) {
return FALSE;
}
}
