PHP Classes

Connect to MySQL, PosgreSQL, Oracle, ODBC: Connect and execute queries in different databases

Recommend this page to a friend!
  Info   View files Example   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (3)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 64%Total: 441 This week: 1All time: 6,242 This week: 560Up
Version License PHP version Categories
class_cdb 4GNU General Publi...5PHP 5, Databases
Description 

Author

This class can connect and execute queries in different databases.

It can establish connections to databases of types MySQL, PostgreSQL, Oracle or ODBC based databases.

The class can also execute INSERT, UPDATE and DELETE queries from parameters that define tables, fields, field values and conditions.

In this class you can connect to various database engines for select, inserts, update, delete.

Picture of Andres Ferreira
  Performance   Level  
Name: Andres Ferreira <contact>
Classes: 2 packages by
Country: Colombia Colombia
Age: 32
All time rank: 314117 in Colombia Colombia
Week rank: 411 Up2 in Colombia Colombia Up

Recommendations

Sql database advanced search
I need to search in Sql database by more than two option

Example


<?php
 
/* Examples: */
 
  
include_once 'Class/DB/Class.DB.min.php'; /* Incluimos la Clase */
  
  /************************************************************
  ** MYSQL **
  ************************************************************/
  /* Datos de Conexión */
 
$DB_TYPE_MYSQL = 'mysql'; /* Tipo de Conexión */
 
$DB_HOST_MYSQL = 'localhost'; /* Host */
 
$DB_PORT_MYSQL = '3306'; /* Puerto */
 
$DB_NAME_MYSQL = 'Base_Datos'; /* Nombre de Base de Datos */
 
$DB_USER_MYSQL = 'WookPlay_User'; /* Nombre de Usuario de Base de Datos */
 
$DB_PASS_MYSQL = 'Password2016'; /* Contraseña de Usuario de Base de Datos */

  /* Crear la conexión */
 
$MYSQL = New DataBase($DB_TYPE_MYSQL,$DB_HOST_MYSQL,$DB_NAME_MYSQL,$DB_USER_MYSQL,$DB_PASS_MYSQL,$DB_PORT_MYSQL); /*Iniciar Clase*/

  /*Example Select */
 
$result = $MYSQL->select('SELECT * FROM tabla');
 
 
/* Example Select usando una base de datos diferente sin inicializar una nueva conexión |Select using a different database without initializing a new connection*/
 
$result = $MYSQL->select_sql('new_dbname','SELECT * FROM tabla');

 
/* Example Insert */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$result = $MYSQL->insert("Table_name",$data);

 
/* Example Update */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $MYSQL->update("Table_name",$data,$where);

 
/* Example Delete */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $MYSQL->delete("Table_name",$where);
 
 
/************************************************************
  ** POSTGRESQL **
  ************************************************************/
 
  /* Datos de Conexión */
 
$DB_TYPE_PGSQL = 'pgsql'; /* Tipo de Conexión */
 
$DB_HOST_PGSQL = 'localhost'; /* Host */
 
$DB_PORT_PGSQL = '5432'; /* Puerto */
 
$DB_NAME_PGSQL = 'Base_Datos'; /* Nombre de Base de Datos */
 
$DB_USER_PGSQL = 'WookPlay_User'; /* Nombre de Usuario de Base de Datos */
 
$DB_PASS_PGSQL = 'Password2016'; /* Contraseña de Usuario de Base de Datos */
 
  /* Crear la conexión */
 
$PGSQL = New DataBase($DB_TYPE_PGSQL,$DB_HOST_PGSQL,$DB_NAME_PGSQL,$DB_USER_PGSQL,$DB_PASS_PGSQL,$DB_PORT_PGSQL); /*Iniciar Clase*/
 
  /*Example Select */
 
$result = $PGSQL->select('SELECT * FROM "public"."Tabla"');
 
 
/* Example Select usando una base de datos diferente sin inicializar una nueva conexión |Select using a different database without initializing a new connection*/
 
$result = $PGSQL->select_sql('_new_dbname','SELECT * FROM "public"."Tabla"');
 
 
/* Example Insert */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$result = $PGSQL->insert("Table_name",$data);
 
 
/* Example Update */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $PGSQL->update("Table_name",$data,$where);
 
 
/* Example Delete */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $PGSQL->delete("Table_name",$where);
 
/************************************************************
  ** ORACLE **
  ************************************************************/
  /* Datos de Conexión */
 
$DB_TYPE_ORACLE = 'oracle'; /* Tipo de Conexión */
 
$DB_HOST_ORACLE = 'localhost/XE'; /* Host */
 
$DB_NAME_ORACLE = 'Base_Datos'; /* Nombre de Base de Datos */
 
$DB_USER_ORACLE = 'WookPlay_User'; /* Nombre de Usuario de Base de Datos */
 
$DB_PASS_ORACLE = 'Password2016'; /* Contraseña de Usuario de Base de Datos */

  /* Crear la conexión */
 
$ORACLE = New DataBase($DB_TYPE_ORACLE,$DB_HOST_ORACLE,$DB_NAME_ORACLE,$DB_USER_ORACLE,$DB_PASS_ORACLE,$DB_PORT_ORACLE); /*Iniciar Clase*/

  /*Example Select */
 
$result = $ORACLE->select('SELECT * FROM tabla');

 
/* Example Select usando una base de datos diferente sin inicializar una nueva conexión |Select using a different database without initializing a new connection*/
 
$result = $ORACLE->select_sql('new_dbname','SELECT * FROM tabla');

 
/* Example Insert */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$result = $ORACLE->insert("Table_name",$data);

 
/* Example Update */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $ORACLE->update("Table_name",$data,$where);

 
/* Example Delete */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $ORACLE->delete("Table_name",$where);


 
/************************************************************
  ** ODBC **
  ************************************************************/
  /* Datos de Conexión */
 
$DB_TIPE_ODBC = 'odbc'; /* Tipo de Conexión */
 
$DB_HOST_ODBC = 'nombre_del_ODBC'; /* Host */
 
$DB_NAME_ODBC = ''; /* Nombre de Base de Datos */
 
$DB_USER_ODBC = ''; /* Nombre de Usuario de Base de Datos */
 
$DB_PASS_ODBC = ''; /* Contraseña de Usuario de Base de Datos */

  /* Crear la conexión */
 
$ODBC = New DataBase($DB_TYPE_ODBC,$DB_HOST_ODBC,$DB_NAME_ODBC,$DB_USER_ODBC,$DB_PASS_ODBC,$DB_PORT_ODBC); /*Iniciar Clase*/

  /*Example Select */
 
$result = $ODBC->select('SELECT * FROM tabla');

 
/* Example Insert */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$result = $ODBC->insert("Table_name",$data);

 
/* Example Update */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $ODBC->update("Table_name",$data,$where);

 
/* Example Delete */
 
$data = [ "Campo" => "Valor", "Campo2" => $valor2 ];
 
$where = [ "Campo" => "Valor", "Campo2" => $valor2 ]; OR $where = "Campo ='Valor' AND Campo2 = '".$valor2."' "
 
$result = $ODBC->delete("Table_name",$where);
  
?>


Details

PHP Class-DB-PDD

Clase PHP para Conexión PDD Mysql, Posgresql, Oracle, ODBC

This class can connect and execute queries in different databases.

It can establish connections to databases of types MySQL, PostgreSQL, Oracle or ODBC based databases.

The class can also execute INSERT, UPDATE and DELETE queries from parameters that define tables, fields, field values and conditions.

In this class you can connect to various database engines for select, inserts, update, delete.


  Files folder image Files  
File Role Description
Files folder imageClass (1 directory)
Plain text file array.txt Doc. Documentation
Plain text file array3.txt Doc. Documentation
Plain text file example.php Example Example script
Plain text file README.md Data Auxiliary data

  Files folder image Files  /  Class  
File Role Description
Files folder imageDB (2 files)

  Files folder image Files  /  Class  /  DB  
File Role Description
  Plain text file Class.DB.min.php Class Class source
  Plain text file Class.DB.php Class Class source

 Version Control Unique User Downloads Download Rankings  
 100%
Total:441
This week:1
All time:6,242
This week:560Up
User Ratings User Comments (2)
 All time
Utility:93%StarStarStarStarStar
Consistency:93%StarStarStarStarStar
Documentation:-
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:64%StarStarStarStar
Rank:712
 
Thats a good class ;-) But why do not use by example DB pack...
7 years ago (José Filipe Lopes Santos)
70%StarStarStarStar
Thats a good class ;-) But why do not use by example DB pack...
7 years ago (José Filipe Lopes Santos)
70%StarStarStarStar