PHP Classes

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

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 64%Total: 443 All time: 6,237 This week: 57Up
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

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 (6)  
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 (6)  /  Class  
File Role Description
Files folder imageDB (2 files)

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:443
This week:0
All time:6,237
This week:57Up
User Ratings User Comments (2)
 All time
Utility:93%StarStarStarStarStar
Consistency:93%StarStarStarStarStar
Documentation:-
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:64%StarStarStarStar
Rank:719
 
Thats a good class ;-) But why do not use by example DB pack...
8 years ago (José Filipe Lopes Santos)
70%StarStarStarStar
Thats a good class ;-) But why do not use by example DB pack...
8 years ago (José Filipe Lopes Santos)
70%StarStarStarStar