Skip to content
master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 

SqlXS

SqlXS is a small yet complex library that takes your database models to a higher level.

Features

  • Automatic getters and setters for fields in database objects. + You can restrict read- and writability.
  • Referencing selects: Post::select()->where('author', QueryBuilder::REFS, $user)->find()
  • No more double objects: all created objects are buffered, so when you modify one, all relations to the object are updated as well. (For example: a blog post and it's author, and a reply by that same author. When you change the name of the author of the reply ($reply->getAuthor()->setUsername('Admin')), the name of the author of the blog post ($post->getAuthor()->getUsername()) is updated as well)
  • It contains a query builder that allows you to generate complex queries without much understanding of MySQL. That's why it's called a generator.
  • Much more awesomeness

How to use?

use Xesau\SqlXS;

class MyObject
{
    use SqlXS\XS;
    public static function sqlXS()
    {
        return new SqlXS\XsInfo('table name', 'unique field', ['readable', 'fields'], ['writable', 'fields'], ['field' => '\\Type']);
    }
 }

// Get Object with the unique field's value = 1
$obj = MyObject::byID(1);

// Echo out the weight of the object
echo $obj->getWeight() . ' pounds.';

$obj->setWeight(40);

About

Makes PHP+MySQL simpler than ever

Resources

Releases

No releases published

Packages

No packages published