PHP Classes

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
2022-10-21 (23 days ago) RSS 2.0 feedNot enough user ratingsTotal: 399 This week: 7All time: 6,530 This week: 106Up
Version License PHP version Categories
connection_dbms 1.1.3MIT/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.

Recommendations

PDO Class
I need a class to connect to my db (mysql). Now my code is a old

Picture of Leonardo Mauro Pereira Moraes
  Performance   Level  
Name: Leonardo Mauro Pereira ... <contact>
Classes: 3 packages by
Country: Brazil Brazil

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:399
This week:7
All time:6,530
This week:106Up
For more information send a message to info at phpclasses dot org.