Login   Register  
PHP Classes
elePHPant
Icontem

SPMD: Wrapper to access different types of databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (3 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 394 All time: 5,919 This week: 1,478Up
Version License PHP version Categories  
spmd 0.3Free For Educational Use5.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
Age: ???
All time rank: 2829213 in Brazil Brazil
Week rank: 1080 Up84 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  
 0%Total:394All time:5,919
 This week:0This week:1,478Up