PHP OTS_Base_DB Examples

Example #1

File: OTS_DB_ODBC.php Project: lucasoares/webzohcaserver

 /**
  * 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);
 }

Example #2

File: OTS_DB_PostgreSQL.php Project: lucasoares/webzohcaserver

 /**
  * 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);
 }

Example #3

File: OTS_DB_MySQL.php Project: Tobbebror/POT

 /**
  * 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);
 }

Example #4

File: OTS_DB_SQLite.php Project: Tobbebror/POT

 /**
  * 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'));
 }

Example #5

File: OTS_DB_MySQL.php Project: Codex-NG/poketibia

 /**
  * 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;
     }
 }

Example #6

File: OTS_DB_MySQL.php Project: lucasoares/webzohcaserver

 /**
  * 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;
     }
 }

Example #7

File: OTS_DB_MySQL.php Project: Alexzo20/gesior-aac

 public function query($query)
 {
     $this->queriesCount++;
     return parent::query($query);
 }