A PHP MySQL ORM library with Database First model that lets you create Entities with base properties and complex relationships (One-To-Many, Many-To-One, Many-To-Many, Table Inheritance, Associative tables), supports queries with expressions, JSON encoding/decoding and is simple to use.
Check the BlueDBClient.NET for a .NET client library to use on the .NET client side.
You can read the documentation and tutorials under the Wiki.
Let's assume that we have an entity User.
Loading all entries:
$all = User::loadList();This would load all entries with all fields.
Let's say that we want only the Username fields:
$all = User::loadList([User::UsernameField]);How about loading only those users, whose Username starts with "Ja"?
Simple, we use the Criteria class:
$criteria = new Criteria(User::class);
$criteria->add(Expression::startsWith(User::class, User::UsernameField, "Ja"));
$results = User::loadListByCriteria($criteria);Encoding/decoding entities to/from JSON? No problem!
$json = JSON::encode($entity);
$entity = JSON::decode($json);Creating a new entry:
$gordon = new User();
$gordon->Username = "Gordon";
User::save($gordon);Updating entries:
// let's change Gordons username to 'Freeman'
$gordon->Username = "Freeman";
User::update($gordon);Deleting entries:
// let's delete Gordon
User::delete($gordon);These short examples are just the top of the iceberg, BlueDB has many many more cool features. To find them out and for more complex examples & tutorials, please go to Wiki.
PHP version >= 5.5
Gregor Mohorko (www.mohorko.info)
Copyright (c) 2022 Gregor Mohorko