Wings
is a very lightweight and easy-to-use database wrapper library for PHP to make your database abstraction faster and simple with just one shot.
This project is outdated has been a while. I'll update it 'till the end of Sep. (09/2013) with a BIG change - This project will be launched soon...
- PDO Extension for PHP
- At least one PDO driver
- PHP 5.3 or higher (5.3.11+ is recommended)
Using Wings
is a very easy and simple task. You just need to require/include the Wings files, configure the DSN, make the authentication and fly!
use Wings\ORM;
// If you're NOT using an Autoload script, you must to require/include the Exceptions Cases and the ORM class
// require 'path/to/Wings/Exceptions/ExecutionException.php';
// require 'path/to/Wings/Exceptions/FetchException.php';
// require 'path/to/Wings/Exceptions/FlyingException.php';
// require 'path/to/Wings/ORM.php';
// We need to configure the Wings to make it "flyable" :)
ORM::configure('mysql:host=localhost;dbname=wings');
ORM::authenticate('username', 'password');
// Let's fly! :)
$wings = ORM::fly('table_name');
$wings->select(array('field1', 'field2'), '`id` = 1', 1);
// The above example will return the result for this query:
// SELECT `field1`, `field2` FROM `table_name` WHERE (`id` = '1') LIMIT 0,1
// How many rows has been selected?
echo "Selected rows: " . (int) $wings->count() . "\n<br />\n";
// Executed queries
echo "Executed queries so far: " . (int) $wings->queries() . "\n";
// Prints the selected data
echo "<pre>";
print_r($wings->fetch());
echo "</pre>";
// Close the connection
$wings->close();
There's a few constants in this class, which are:
-
VERSION
=> Current library version -
VERSION_ID
=> Current version ID (like:05000
) -
FETCH_ASSOC
=> Used on the fetch() method. Fetches the data as an associative array. -
FETCH_ARRAY
=> Used on the fetch() method. Fetches the data as an indexed array (0, 1, ...). -
FETCH_BOTH
=> Used on the fetch() method. Fetches the data using the two methods above. -
FETCH_OBJECT
=> Used on the fetch() method. Fetches the data into a stdClass object. -
FETCH_LAZY
=> Used on the fetch() method. Fetches the data into a PDORow object.
If you don't know any of these FETCH constants, read the PHP Documentation.
Wings is licensed under the MIT License, so you can do whatever you want, since you maintain a link to this repository and leave a mention of my name as the original author of the Wings library.
Date formating: (DD/MM/YY)
0.5.4
- (22/12/12)
- Added the
setPdoReturn()
method to change the return value on theselect()
method.
0.5.4.1
- 27/12/12
- Fixed a silly logical error on the
select()
method.
0.5.4.2
- 27/12/12
- The
$append
param has been added on theinsert()
method.
0.5.4.3
- 28/12/12
- Added a new connection attribute (defult fetch method).
0.5.5
- 28/12/12
- Added prefix support for the flying table.