Skip to content
/ Wings Public

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.

License

Notifications You must be signed in to change notification settings

queued/Wings

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Wings

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.

Note

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...

Requirements

  • PDO Extension for PHP
  • At least one PDO driver
  • PHP 5.3 or higher (5.3.11+ is recommended)

Code

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!

Simple usage:

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();

The Class Constants

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.

License

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.

Changelog

Date formating: (DD/MM/YY)

0.5.4 - (22/12/12)

  • Added the setPdoReturn() method to change the return value on the select() 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 the insert() 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.

About

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.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages