PHP Classes
elePHPant
Icontem

Connection DBMS: Connect to databases using PDO or MySQLi

Recommend this page to a friend!
  Info   View files Documentation   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2018-01-04 (6 months ago) RSS 2.0 feedNot enough user ratingsTotal: 292 All time: 7,240 This week: 412Up
Version License PHP version Categories
connection_dbms 1.1.1MIT/X Consortium ...5PHP 5, Databases, Libraries
Description Author

This package can connect to databases using PDO or MySQLi.

It provides two classes: one to connect to a database using PDO and another to connect to MySQL using MySQLi.

Both classes can execute prepared queries from parameters and return the results in arrays.

  Performance   Level  
Name: Leonardo Mauro Pereira ... <contact>
Classes: 3 packages by
Country: Brazil Brazil
Age: 24
All time rank: 3055227 in Brazil Brazil
Week rank: 748 Up57 in Brazil Brazil Up

Details

Connection Instruction

This package have classes to connection and queries for Database Management System (DBMS [or SGBD, in Portuguese]). Currently it can connect to a database using MySQLi or PDO extension and execute several types of queries from parameters that define tables, fields, values and conditions.

Folder:

  • /php/connection/MysqliInstruction.php MysqliInstruction()
  • /php/connection/PDOInstruction.php PDOInstruction()

Example

MysqliInstruction()

/Autoload Include/
use \Connection\MysqliInstruction;

$mysqli = new MysqliInstruction();
$mysqli->connect();
$resp = $mysqli->select('SELECT * FROM table WHERE id < ?', array('10'));
$resp = $mysqli->generic('DELETE FROM table WHERE id = ?', array('2'));
var_dump($resp);
$mysqli->end();

PDOInstruction()

/Autoload Include/
use \Connection\PDOInstruction;

$pdo = new PDOInstruction();
$pdo->connect();
$resp = $pdo->select('SELECT * FROM table WHERE id < ?', array('10'));
$resp = $pdo->generic('DELETE FROM table WHERE id = ?', array('2'));
var_dump($resp);
$pdo->end();

Also look ~

  Files folder image Files  
File Role Description
Files folder imageclass (2 files)
Files folder imagedist (1 directory)
Files folder imageexample (1 file)
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  class  
File Role Description
  Plain text file class.mysqli.instruction.php Class Class source
  Plain text file class.pdo.instruction.php Class Class source

  Files folder image Files  /  dist  
File Role Description
Files folder imagephp (1 file, 1 directory)

  Files folder image Files  /  dist  /  php  
File Role Description
Files folder imageconnection (2 files)
  Accessible without login Plain text file autoload.php Aux. Auxiliary script

  Files folder image Files  /  dist  /  php  /  connection  
File Role Description
  Plain text file MysqliInstruction.php Class Class source
  Plain text file PDOInstruction.php Class Class source

  Files folder image Files  /  example  
File Role Description
  Accessible without login Plain text file index.php Example Example script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:292
This week:0
All time:7,240
This week:412Up