PHPackages                             pleonovich/fultone - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. pleonovich/fultone

ActiveLibrary[Database & ORM](/categories/database)

pleonovich/fultone
==================

Fultone is simple object-relational queries helper for SafeMySQL

1.0.1(6y ago)1201Apache-2.0PHPPHP >=5.0.0

Since Jul 28Pushed 6y ago1 watchersCompare

[ Source](https://github.com/pleonovich/fultone)[ Packagist](https://packagist.org/packages/pleonovich/fultone)[ Docs](https://github.com/pleonovich/fultone)[ RSS](/packages/pleonovich-fultone/feed)WikiDiscussions master Synced today

READMEChangelog (1)Dependencies (2)Versions (3)Used By (1)

Fultone
=======

[](#fultone)

simple object-relational queries helper for SafeMySQL

### Requirements:

[](#requirements)

### DB connection configuration

[](#db-connection-configuration)

```
Fultone\Config::$db_user = 'root';
Fultone\Config::$db_pass = '1234';
Fultone\Config::$db_name = 'simdb';
Fultone\Config::$db_charset = 'utf8';
```

Using Models
============

[](#using-models)

### Create model for users table

[](#create-model-for-users-table)

```
use Fultone\DBmodel as DBmodel;
use Fultone\DBtable as DBtable;
use Fultone\DBfield as DBfield;

class Users extends DBmodel {

    public $name = 'user_list';

    protected function schema(DBtable $table) {
        $table
        ->field('id', DBfield::TYPE_INT, 10, false)
        ->field('user_name', DBfield::TYPE_VARCHAR, 255, false)
        ->field('user_login', DBfield::TYPE_VARCHAR, 255, false)
        ->field('email', DBfield::TYPE_VARCHAR, 255, false)
        ->field('secret', DBfield::TYPE_TEXT, null, false);
    }

    // Set some data for admin
    protected function setData(){
        return [
            'user_name'=>'Admin',
            'user_login'=>'admin',
            'email'=>'admin@admin.net',
            'secret'=>'12345'
        ];
    }
}

$users = new Users();

// Migrate table to connected db
$users->migrate();

// Migrate data form model class
$users->insertData();
```

### Insert into table

[](#insert-into-table)

```
$users->create([
    "name" => "john smith",
    "phone" => "+375441212121",
    "description" => "some text about john smith"
]);
```

### Select from table

[](#select-from-table)

```
// get all rows
$result = $users->findAll();

// get one row by value
$result = $users->findOne([ "id"=> 1 ]);

// set operator
// one of '=','!=','','>','=','