/** * Creates database connection. * * <p> * Connects to PgSQL (PostgreSQL) database on given arguments. * </p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>host</var> - database server.</li> * <li><var>port</var> - port (optional, also it is possible to use host:port in <var>host</var> parameter).</li> * <li><var>database</var> - database name.</li> * <li><var>user</var> - user login.</li> * <li><var>password</var> - user password.</li> * </ul> * * @version 0.0.6 * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct($params) { $user = null; $password = null; $dns = array(); // host:port support if (strpos(':', $params['host']) !== false) { $host = explode(':', $params['host'], 2); $params['host'] = $host[0]; $params['port'] = $host[1]; } if (isset($params['host'])) { $dns[] = 'host=' . $params['host']; } if (isset($params['port'])) { $dns[] = 'port=' . $params['port']; } if (isset($params['database'])) { $dns[] = 'dbname=' . $params['database']; } if (isset($params['user'])) { $user = $params['user']; } if (isset($params['password'])) { $password = $params['password']; } if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // PDO constructor parent::__construct('pgsql:' . implode(' ', $dns), $user, $password); }
/** * Creates database connection. * * <p> * Connects to ODBC data source on given arguments. * </p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>host</var> - database host.</li> * <li><var>port</var> - ODBC driver.</li> * <li><var>database</var> - database name.</li> * <li><var>user</var> - user login.</li> * <li><var>password</var> - user password.</li> * <li><var>source</var> - ODBC data source.</li> * </ul> * * <p> * Note: Since 0.1.3 version <var>source</var> parameter was added. * </p> * * @version 0.1.3 * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct($params) { $user = null; $password = null; $dns = array(); if (isset($params['host'])) { $dns[] = 'HOSTNAME={' . $params['host'] . '}'; } if (isset($params['port'])) { $dns[] = 'DRIVER={' . $params['port'] . '}'; } if (isset($params['database'])) { $dns[] = 'DATABASE={' . $params['database'] . '}'; } if (isset($params['user'])) { $user = $params['user']; $dns[] = 'UID={' . $user . '}'; } if (isset($params['password'])) { $password = $params['password']; $dns[] = 'PWD={' . $user . '}'; } if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // composes DNS $dns = implode(';', $dns); // source parameter overwrites all other params if (isset($params['source'])) { $dns = $params['source']; } // PDO constructor parent::__construct('odbc:' . $dns, $user, $password); }
/** * Creates database connection. * * <p> * Connects to MySQL database on given arguments. * </p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>host</var> - database server.</li> * <li><var>port</var> - port (optional, also it is possible to use host:port in <var>host</var> parameter).</li> * <li><var>database</var> - database name.</li> * <li><var>user</var> - user login.</li> * <li><var>password</var> - user password.</li> * </ul> * * @version 0.2.0+SVN * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct(array $params) { $user = null; $password = null; $dns = array(); // host:port support if (strpos(':', $params['host']) !== false) { $host = explode(':', $params['host'], 2); $params['host'] = $host[0]; $params['port'] = $host[1]; } if (isset($params['host'])) { $dns[] = 'host=' . $params['host']; } if (isset($params['port'])) { $dns[] = 'port=' . $params['port']; } if (isset($params['database'])) { $dns[] = 'dbname=' . $params['database']; } if (isset($params['user'])) { $user = $params['user']; } if (isset($params['password'])) { $password = $params['password']; } if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // PDO constructor parent::__construct('mysql:' . implode(';', $dns), $user, $password); $this->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true); }
/** * Creates database connection. * * <p> * Connects to SQLite database on given arguments. * <p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>database</var> - database name.</li> * </ul> * * @version 0.0.7 * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct(array $params) { if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // PDO constructor parent::__construct('sqlite:' . $params['database']); // this class will drop quotes from field names $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('OTS_SQLite_Results')); }
/** * Creates database connection. * * <p> * Connects to MySQL database on given arguments. * </p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>host</var> - database server.</li> * <li><var>port</var> - port (optional, also it is possible to use host:port in <var>host</var> parameter).</li> * <li><var>database</var> - database name.</li> * <li><var>user</var> - user login.</li> * <li><var>password</var> - user password.</li> * </ul> * * @version 0.0.6 * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct($params) { $user = null; $password = null; $dns = array(); // host:port support if (strpos(':', $params['host']) !== false) { $host = explode(':', $params['host'], 2); $params['host'] = $host[0]; $params['port'] = $host[1]; } if (isset($params['host'])) { $dns[] = 'host=' . $params['host']; } if (isset($params['port'])) { $dns[] = 'port=' . $params['port']; } if (isset($params['database'])) { $dns[] = 'dbname=' . $params['database']; } if (isset($params['user'])) { $user = $params['user']; } if (isset($params['password'])) { $password = $params['password']; } if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // PDO constructor try { parent::__construct('mysql:' . implode(';', $dns), $user, $password); } catch (PDOException $error) { echo 'Can\'t connect to MySQL database.</font>'; exit; } }
/** * Creates database connection. * * <p> * Connects to MySQL database on given arguments. * </p> * * <p> * List of parameters for this drivers: * </p> * * <ul> * <li><var>host</var> - database server.</li> * <li><var>port</var> - port (optional, also it is possible to use host:port in <var>host</var> parameter).</li> * <li><var>database</var> - database name.</li> * <li><var>user</var> - user login.</li> * <li><var>password</var> - user password.</li> * </ul> * * @version 0.0.6 * @param array $params Connection parameters. * @throws PDOException On PDO operation error. */ public function __construct($params) { $user = null; $password = null; $dns = array(); // host:port support if (strpos(':', $params['host']) !== false) { $host = explode(':', $params['host'], 2); $params['host'] = $host[0]; $params['port'] = $host[1]; } if (isset($params['host'])) { $dns[] = 'host=' . $params['host']; } if (isset($params['port'])) { $dns[] = 'port=' . $params['port']; } if (isset($params['database'])) { $dns[] = 'dbname=' . $params['database']; } if (isset($params['user'])) { $user = $params['user']; } if (isset($params['password'])) { $password = $params['password']; } if (isset($params['prefix'])) { $this->prefix = $params['prefix']; } // PDO constructor try { parent::__construct('mysql:' . implode(';', $dns), $user, $password); } catch (PDOException $error) { echo '<div style="font-weight: bold;font-family: Tahoma, sans-serif;background: red; padding: 5px; width: 100%; max-width: 1000px; margin: 0px auto; border: 1px solid #000;" align="center">ImpossÃvel de conectar-se com o banco de dados, informe para o <a href="mailto:victorfasanoraful@live.com">WebMaster</a> do website. </font></div>'; exit; } }