PHP Classes

SPMD: Wrapper to access different types of databases

Recommend this page to a friend!
  Info   View files View files (6)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 396 All time: 6,570 This week: 314Up
Version License PHP version Categories
spmd 0.3Free For Educatio...5.0PHP 5, Databases


This package implements a wrapper to access different types of databases.

There several classes that provide a common interface for establishing database connections loading the respective database connections if necessary, execute direct or prepared queries, and retrieve query results into arrays.

Currently it supports MySQL, PostgreSQL, Oracle and Microsoft SQL server.

In Portuguese:

SPMD é uma classe que desenvolvi para gerenciamento de banco de dados em geral, de uso fácil e prático.

Uma coisa interessante sobre o SPMD é que ele não bloqueia caracteres do tipo (" ' ;), apenas checa se no argumento da query tem alguma tentativa de Inject, se tiver substitui por caracteres especiais HTML ASCII ISO 8859-1... Esse procedimento é chamado de prepared statements.

Ela tem suporte aos seguintes drivers de SQL:

- MSSQL (Microsft SQL Server)
- Oracle
- PostgreSQL
- SQLite (em desenvolvimento)

O SPMD na verdade são 2 classes, 1 para conexão com o banco e checagem de extensões() e outra para gerenciamento de querys, que tem o nome de QueryManagement.

Picture of Fernando Costa(14biss)
Name: Fernando Costa(14biss) <contact>
Classes: 2 packages by
Country: Brazil Brazil
Age: ???
All time rank: 3142230 in Brazil Brazil
Week rank: 578 Up44 in Brazil Brazil Up

  Files folder image Files  
File Role Description
Accessible without login Plain text file Exemple1.php Example Exemple to use SPMD
Accessible without login Plain text file Exemple2.php Example Exemple to use SPMD
Accessible without login Plain text file prepared_statements1.php Example Using Prepared Statements
Accessible without login Plain text file prepared_statements2.php Example Using Prepared Statements
Plain text file SPMD.class.php Class SPMD.class.php
Accessible without login Plain text file SQL_drivers.php Example Supported SQL drivers

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,570
This week:314Up