PHPackages                             hellsan631/logosdb - 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. [Framework](/categories/framework)
4. /
5. hellsan631/logosdb

ActiveProject[Framework](/categories/framework)

hellsan631/logosdb
==================

A database micro-framework for creating simple DB interaction without the need for a full framework

v1.5.1(11y ago)139[7 issues](https://github.com/hellsan631/LogosDB/issues)MITPHPPHP >=5.5

Since Nov 1Pushed 11y ago1 watchersCompare

[ Source](https://github.com/hellsan631/LogosDB)[ Packagist](https://packagist.org/packages/hellsan631/logosdb)[ Docs](http://mathew-kleppin.com/blog/)[ RSS](/packages/hellsan631-logosdb/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)DependenciesVersions (23)Used By (0)

LogosDB v 1.5.\*
================

[](#logosdb-v-15)

[![Build Status](https://camo.githubusercontent.com/89322cd9df64a09eebfe705a9bd7b3ff9e003d5f193fe8d82083faadc6baa991/68747470733a2f2f7472617669732d63692e6f72672f68656c6c73616e3633312f4c6f676f7344422e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/hellsan631/LogosDB) [![Code Climate](https://camo.githubusercontent.com/da71010505fee7597f14f38994f824389aff1e8ab2e0449f2fdc239abd55aa1b/68747470733a2f2f636f6465636c696d6174652e636f6d2f6769746875622f68656c6c73616e3633312f4c6f676f7344422f6261646765732f6770612e737667)](https://codeclimate.com/github/hellsan631/LogosDB)

LogosDB is a database micro-framework for creating simple DB interaction without the need for a full MVC structure.

The idea is that for small projects, creating APIs, or when you just don't want or need to implement a fully featured MVC framework (Phalcon, Laravel, CodeIgniter, Zend), LogosDB has your back. LogosDB is a bare-bones Model Interaction Framework for working with objects inside databases.

Version 1.5.\*
--------------

[](#version-15)

1.5.\* Introduces Namespaces into the framework. The namespaces reflect the folder hierarchy, and helps when using multiple frameworks. Names and folder structures might shuffle around a bit while 1.5 gets updates.

Getting Started
---------------

[](#getting-started)

### Requirements

[](#requirements)

```
Requires PHP 5.5+
Requires PDO

```

### Installation (via composer)

[](#installation-via-composer)

Installation via composer is simple. Just add the following to your composer.json file

```
{
    "require": {
        "hellsan631/logosdb": "1.5.*"
    }
}
```

After running a composer update/install command, extend the class with a logos object

```
class User extends Logos\DB\MySQL\Model{
    public $username;
    public $email;
}
```

and make sure to include your autoloader

```
include "./vendor/autoload.php";
```

For those who don't have composer, just download as a zip, and include the autoload file in your php header

### Creating A Model

[](#creating-a-model)

Create an object class for each table in your database you want to use this with.

```
//example object
class User extends Logos\DB\MySQL\Model{

    //public $id; already defined in the Database_Object class.

    public $username;
    public $email;

}
```

### Database Setup

[](#database-setup)

We use the config class, which creates a simpleton, for inputting our DB connection data. Add this somewhere in your header (or you can add this to autoload.php)

```
use Logos\DB\Config;

//Database settings
Config::write('db.host', 'localhost');
Config::write('db.name', 'db_name');
Config::write('db.user', 'db_user');
Config::write('db.password', 'db_pass');
```

### Database Schema

[](#database-schema)

MySQL

```
Each table in your database should have an ID field, which is a incremental primary
index. If you want a table to use a date, use the timestamp format, and include
date in the name of the field.

```

Usage
-----

[](#usage)

For a quick list of classes and what they do, head on over to the database interface

### Creating a new object in the database

[](#creating-a-new-object-in-the-database)

An object can be either declared as a variable, or statically created (which takes less memory and time)

```
//Object as a variable
$user = new User(["username" => "testing", "email" => "email@email.com"]);
$user->createNew();

//Same thing, but done statically (returns the ID of the created object)
User::createSingle(["username" => "testing", "email" => "email@email.com"]);
```

### Creating Many objects to a database

[](#creating-many-objects-to-a-database)

You can create objects multiple ways.

```
//Want to create 100 new identical objects?
User::createMultiple(["username" => "testing", "email" => "email@email.com"], 100);

//want each object to be different?
$users = [];
$count = 0;

while($count < 100){
    array_push($users, ["username" => "testing",
                        "email" => "email@email.com",
                        "other_var" => $count]);

    $count++;
}

User::createMultiple($users);
```

### Saving Changes to an object already in the database

[](#saving-changes-to-an-object-already-in-the-database)

```
//Saving a single object
User::loadSingle(["id" => 10])->save(["email" => "newEmail@gmail.com"]);

//or

User::saveSingle(["email" => "newEmail@gmail.com"], ["id" => 10]);

//saving to multiple objects at the same time
User::saveMultiple(["email" => "newEmail@gmail.com"], ["username" => "testing"]);
```

### Expanded query syntax

[](#expanded-query-syntax)

Want to add a limit, orderBy, or groupBy to your query results?

```
User::query('limit', 10);
User::query(['orderBy', 'limit'], ['id DESC', 10]);
User::query(['orderBy', 'limit'], ['id ASC, username DESC', 10]);
User::query(['orderBy' => 'id ASC', 'limit' => 10]);

//Add getList to the end of your query to get a list of that classes objects
User::query('limit', 100)->getList();

//how to use min/max for limit
//Send them in as array!
User::query('limit', [0, 10])->getList();
User::query('limit', ['min' => 0, 'max' => 10])->getList();

//Or if you want to use an array to add more,
User::query(['limit' => [0, 10], 'orderBy' => 'id ASC'])->getList();
User::query(['limit' => ['min' => 0, 'max' => 10], 'orderBy' => 'id ASC'])->getList();
```

Any added limit/orderby/groupby is only added to the next query executed. If you run any two queries in a row , i.e.

```
User::query('limit', 10);
User::loadMultiple($array1);

//limit 10 no longer applies here
User::CreateMultiple($array2);
```

You need to add the query to each call to the database if you want it to effect that call.

Also, any time you set a query, the previous query of that type is overwritten.

```
User::query('limit', 10);
User::query('orderBy', 'id ASC');
User::query('orderBy', 'id DESC');

//would load 10 users in id DESC order
User::loadMultiple($array1);
```

### Automatically Converts JSON

[](#automatically-converts-json)

You can use JSON or an object anywhere you want.

```
$JSON_STRING = '{"username": "testing", "email": "testing@mail.com"}';

$user = new User($JSON_STRING);//It works!

//Use JSON anywhere!
User::newInstance(["id" => 10])->save($JSON_STRING);
User::createMultiple($JSON_STRING, 100);
```

### Adheres to Model

[](#adheres-to-model)

You don't have to worry about what your sending into an object, or if you've created dynamically declared variables in that object

```
$JSON_STRING = '{"username": "testing", "email": "testing@mail.com", "size": "small"}';

$user = new User($JSON_STRING);//It works!

var_dump($user);
//object(User)[98]
//    public 'username' => string 'testing' (length=7)
//    public 'email' => string 'testing@mail.com' (length=16)

$user->updateObject($JSON_STRING);

var_dump($user);
//object(User)[98]
//    public 'username' => string 'testing' (length=7)
//    public 'email' => string 'testing@mail.com' (length=16)
//    public 'size' => string 'small' (length=5)

//Now that the $user has a dynamic variable, lets try and save it.

$user->save();
//UPDATE user SET username = :username, email = :email WHERE id = :id
```

Security
--------

[](#security)

There are 3 added security classes that help with php development. The goal is to enhance existing PHP 5.5 functionality with industry standard practices, and make them easy to use.

### The Cipher Class

[](#the-cipher-class)

The Cipher class allows you to encrypt/decrypt text and generate safe random numbers. It does this using MCrypt, a built in PHP extension. Currently, keys are one way, but soon that will change.

Use of the Cipher Class is easy. To encrypt something:

```
//Send a secure key to the cipher class.
$cipher = new Cipher("s3cur3k3y");

echo $cipher->encrypt("Hello World!");

//outputs "kRTIR6qDGYNumkoAMfwWMGNVPIUoODr0kvFMCmPDynM="
```

If you want to then decrypt

```
echo $cipher->decrypt("kRTIR6qDGYNumkoAMfwWMGNVPIUoODr0kvFMCmPDynM=");

//outputs "Hello World!"
```

You can also get a random key from Cipher. Its highly recommended that you use cipher in place of any other random key/number generators for security, as Cipher uses "openssl\_random\_pseudo\_bytes()", which is the most secure way in php to get a random string of data.

```
//You can send in a length of key into the getRandomKey method, or just leave it blank for a default length of 22.
$randomKey = Cipher::getRandomKey();
```

### The Password Class

[](#the-password-class)

The password class helps secure user passwords using PHP 5.5 built in BCrypt implementation. Its by far the most secure way of storing passwords, and all passwords should be stored this way.

For an implementation of this, I recommend looking at one of my other projects, and the way it handles user creation.

To Create A New User and save his password correctly:

newUser.php

```
$newUser = new User($_POST);

if($newUser->createNew())
    $_SESSION['result'] = "Successfully added new User";
else
    $_SESSION['result'] = "Unable to add new User";

header("Location: ./index.php");
```

To Login with a user

auth.php

```
$user = User::loadSingle(["username" => $_POST['username']]);

if(!$user && strlen($_POST['username']) > 6)
    $user = User::loadSingle(["email" => $_POST['username']]);

if(!$user){
    $_SESSION['result'] = "Couldn't find a user with that username/email";
}else{
    if($user->doAuth($_POST['password'])){

        $_SESSION['result'] = "Login Successful";
        $_SESSION['user'] = $user->toArray();

    }else{

        $_SESSION['result'] = "Incorrect Password";

    }
}

header("Location: ../login.php");
```

And then the user class that handles it all

class.user.php

```
class User extends Logos\DB\MySQL\Model{

    public $username;
    public $email;
    public $password;
    public $salt;
    public $admin;
    public $auth_key;
    public $company_id;

    public function createNew(){

        $password = new Password($this->password);

        $this->password = $password->getKey();
        $this->salt = $password->getSalt();

        return parent::createNew();

    }

    public function verifyLogin($password){
        $passwordCheck = new Password($this->password, array('salt' => $this->salt, 'hashed' => true));

        return $passwordCheck->checkPassword($password);
    }

    public function verifyAuth(){
        if(!isset($_SESSION['auth_key']))
            return false;

        if($this->auth_key !== $_SESSION['auth_key'])
            return false;

        return true;
    }

    public function verifyAdmin(){
        if($this->admin === 0)
            return false;

        return true;
    }

    public static function deAuth(){
        foreach($_SESSION as $key => $value){
            if($key !== "result" || $key !== "Result" || $key !== "RESULT")
                unset($_SESSION[$key]);
        }

        return true;
    }

    public function doAuth($password, $level = 0){
        if($this->verifyLogin($password) === false)
            return false;

        if((int) $level === 1){
            if($this->verifyAdmin())
                return true;
        }else{
            if($this->verifyAuth())
                return true;
        }

        if($this->admin === 0 && $level === 1)
            return false;

        $_SESSION['auth_key'] = $this->auth_key = Cipher::getRandomKey();

        if($level === 1)
            $_SESSION['admin_key'] = $this->auth_key;

        return ($this->save() !== false) ? true : false;
    }
}
```

### The Iron Class

[](#the-iron-class)

Iron Class helps protect against Cross Site Request Forgery attacks. Doing this can be a bit complicated, but with this class, the implementation is pretty straight forward.

For Post Requests (example login form)

login.php

```

```

auth.php

```
$iron = Iron::getInstance();

if($iron->check_token() !== false){

    //its safe, you can do user authentication in here

}else{

    //warning, auth isn't safe. You should log the IP and lock down the system.

}
```

If you wanted to protect your GET requests as well

Info.php

```
    $iron = Iron::getInstance();

    $requestURL = "www.example.com/user.php?id=100123".$iron->generate_get_token();

    getUserData($requestURL);
```

user.php

```
$iron = Iron::getInstance();

if($iron->check_token() !== false){

    //its safe, you can do user authentication in here

}else{

    //warning, auth isn't safe. You should log the IP and lock down the system.

}
```

Contributing
------------

[](#contributing)

Please feel free to fork, push, pull and all that other good Git stuff!

Thanks
======

[](#thanks)

(Expanding on this readme at a later date)

Visit my blog:

###  Health Score

24

—

LowBetter than 32% of packages

Maintenance0

Infrequent updates — may be unmaintained

Popularity9

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity68

Established project with proven stability

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~3 days

Total

21

Last Release

4154d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/51b809f17cceeb9d01bfca11ea998012cb78a7cce1ad888b0eb3d04d16f9f0f5?d=identicon)[hellsan631](/maintainers/hellsan631)

---

Top Contributors

[![hellsan631](https://avatars.githubusercontent.com/u/1474758?v=4)](https://github.com/hellsan631 "hellsan631 (96 commits)")

---

Tags

framework

### Embed Badge

![Health badge](/badges/hellsan631-logosdb/health.svg)

```
[![Health](https://phpackages.com/badges/hellsan631-logosdb/health.svg)](https://phpackages.com/packages/hellsan631-logosdb)
```

###  Alternatives

[hemp/presenter

Easy Model Presenters in Laravel

247592.6k1](/packages/hemp-presenter)[pestphp/pest-plugin-stressless

Stressless plugin for Pest

67792.6k16](/packages/pestphp-pest-plugin-stressless)[wpstarter/framework

The WpStarter Framework - Laravel Framework for WordPress

1810.1k4](/packages/wpstarter-framework)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)