PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2011-08-11 (5 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 395 All time: 6,258 This week: 1,153Up
Version License PHP version Categories
spmd 0.3Free For Educatio...5.0PHP 5, Databases
Description Author

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)
- MySQL
- 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

  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  
 0%
Total:395
This week:0
All time:6,258
This week:1,153Up