PHP Classes

PDO Wrapper Sky's flavor: Access MySQL databases using PDO

Recommend this page to a friend!
  Info   Documentation   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 307 All time: 7,351 This week: 206Up
Version License PHP version Categories
pdo-wrapper 1.0Freely Distributable5.0PHP 5, Databases
Description 

Author

This class can access MySQL databases using PDO.

It can connect to a MySQL server host with a given user name and password and selects a specified database to access.

The class can execute arbitrary SQL queries, retrieve query result records into arrays, execute INSERT queries from parameters, retrieve the last inserted record identifier, etc..

Picture of Legend Foxy
Name: Legend Foxy <contact>
Classes: 1 package by
Country: Australia Australia

Documentation

Note: Anything within square brackets ([*]) is not required by default Note: encode and decode functions are pretty much useless in any kind of production environment. Connection initiation: $mysql = new Database('127.0.0.1', 'pdoUser', 'userPass' [, 'dbName']); Set the database if not provided earlier: $mysql->setDB('dbName'); Insert info into a table: $mysql->insert('table_name', array('column_1' => 'info_1' [, 'col2' => 'info2'])); Execute a query: $mysql->query('update `lolcats` set `name`=:new where `name`=:old', array('new' => 'sweety', 'old' => 'cuteie')); Execute a query, returning the rows selected: $v = $mysql->fetch_array('select * from `users` where `username`=:user;', array('user' => 'Frankie\'s Dog')); Hashing: $hash = Database::hash('password'); if(Database::validate('password', $hash)) { // Yippee you logged in ^.^ }

  Files folder image Files (2)  
File Role Description
Accessible without login Plain text file readme Doc. examples
Plain text file PDO.php Class ...

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:307
This week:0
All time:7,351
This week:206Up