oscarotero/folk

Universal CMS

Monday, June 4, 2018
by oscarotero
Repository
3 Watchers
6 Stars
1,020 Installations

PHP
1 Dependents
0 Suggesters
1 Forks
1 Open issues
71 Versions
10 % Grown

The README.md

FOLK

The universal CMS, _(*1)

, _(*2)

This is a framework-agnostic CMS that you can use to edit the content of your site. It works with any kind of websites, no matter if the content is stored in a database, yml files, json, etc., _(*3)

Demo: https://oscarotero.com/folk/demo/, _(*4)

List view Edit view , _(*5)

Requirements

PHP >= 7
Composer

Installation

This package is installable and autoloadable via Composer as oscarotero/folk., _(*6)

composer require oscarotero/folk

Entities

The entities are classes to manage "things". It can be a database table, a file, a directory with files, etc. They must implement Folk\Entities\EntityInterface (or extend Folk\Entities\AbstractEntity). Let's see an example of an entity using a database table., _(*7)

namespace MyEntities;

use Folk\SearchQuery;
use Folk\Formats\FormatFactory;
use Folk\Formats\Group;
use Folk\Entities\AbstractEntity;

/**
 * Entity to manage the posts
 */
class Posts extends AbstractEntity
{
    public $title = 'Posts';
    public $description = 'These are the posts of the blog';

    /**
     * List the posts
     *
     * @return array [id => data, ...]
     */
    public function search(SearchQuery $search): array
    {
        $query = 'SELECT * FROM posts';

        if ($search->getPage() !== null) {
            $limit = $search->getLimit();
            $offset = ($search->getPage() * $limit) - $limit;
            $query .= " LIMIT {$offset}, {$limit}";
        }

        $pdo = $this->admin->get('pdo');
        $result = $pdo->query($query);

        $data = [];

        while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
            $data[$row['id']] = $row;
        }

        return $data;
    }

    /**
     * Create a new post
     *
     * @return mixed The post id
     */
    public function create(array $data)
    {
        $pdo = $this->admin->get('pdo');

        $statement = $pdo->prepare('INSERT INTO posts (title, text) VALUES (:title, :text)');
        $statement->execute([
            ':title' => $data['title'],
            ':text' => $data['text'],
        ]);

        return $pdo->lastInsertId();
    }

    /**
     * Read a post
     *
     * @return array
     */
    public function read($id): array
    {
        $pdo = $this->admin->get('pdo');

        $statement = $pdo->prepare('SELECT * FROM posts WHERE id = ? LIMIT 1');
        $statement->execute([$id]);

        return $statement->fetch(PDO::FETCH_ASSOC);
    }

    /**
     * Update a post
     */
    public function update($id, array $data)
    {
        $pdo = $this->admin->get('pdo');

        $statement = $pdo->prepare('UPDATE posts SET title = :title, text = :text WHERE id = :id LIMIT 1');
        $statement->execute([
            ':title' => $data['title'],
            ':text' => $data['text'],
            ':id' => $data['id'],
        ]);
    }

    /**
     * Delete a post
     */
    public function delete($id)
    {
        $pdo = $this->admin->get('pdo');

        $statement = $pdo->prepare('DELETE FROM posts WHERE id = ? LIMIT 1');
        $statement->execute([$id]);
    }

    /**
     * Returns the data scheme used by the posts.
     */
    public function getScheme(FormatFactory $factory): Group
    {
        return $factory->group([
            'title' => $factory->text()
                ->maxlength(200)
                ->label('The post title'),

            'text' => $factory->html()
                ->label('The body'),
        ]);
    }

    /**
     * Returns the label of a row.
     * (used in autocomplete searches, select, etc)
     */
    public function getLabel($id, array $data): string
    {
        return sprintf('%s (%d)', $data['title'], $id);
    }
}

Getting started

There's some predefined entities that you can extend and configure, for example to use with simplecrud, or to save the content in yaml or json files, etc., _(*8)

Once your entities are created, let's make them to run:, _(*9)

use Folk\Admin;

use Entities\Posts;

//Create a Admin instance passing the root path and the http uri:
$uri = new Zend\Diactoros\Uri('http://my-site.com/admin');
$admin = new Admin(__DIR__, $uri);

//Set the pdo instance:
$admin['pdo'] = new PDO('mysql:dbname=database;charset=UTF8');

//Add set your entities classes
$admin->setEntities([
    Posts::class
]);

//Run the web (using PSR-7 request/responses)
$request = Zend\Diactoros\ServerRequestFactory::fromGlobals();
$emitter = new Zend\Diactoros\Response\SapiEmitter();

$response = $admin($request);
$emitter->emit($response);

As you can see, this is a simple example with a simple mysql table. But the interface is flexible enought to work with any kind of data., _(*10)

To know how to work with the scheme, visit form-manager project., _(*11)

The Versions

04/06 2018

dev-master

9999999-dev https://github.com/fol-project/fol

Universal CMS

library folk

Universal CMS

oscarotero/folk

The README.md

FOLK

Requirements

Installation

Entities

Getting started

The Versions

dev-master

The Requires

The Development Requires

by Oscar Otero

v3.7.1

The Requires

The Development Requires

by Oscar Otero

v3.7.0

The Requires

The Development Requires

by Oscar Otero

v3.6.3

The Requires

The Development Requires

by Oscar Otero

v3.6.2

The Requires

The Development Requires

by Oscar Otero

v3.6.1

The Requires

The Development Requires

by Oscar Otero

v3.6.0

The Requires

The Development Requires

by Oscar Otero

v3.5.1

The Requires

The Development Requires

by Oscar Otero

v3.5.0

The Requires

The Development Requires

by Oscar Otero

v3.4.1

The Requires

The Development Requires

by Oscar Otero

v3.4.0

The Requires

The Development Requires

by Oscar Otero

dev-redesign

The Requires

The Development Requires

by Oscar Otero

v3.3.0

The Requires

The Development Requires

by Oscar Otero

v3.2.1

The Requires

The Development Requires

by Oscar Otero

v3.2.0

The Requires

The Development Requires

by Oscar Otero

v3.1.0

The Requires

The Development Requires

by Oscar Otero

v3.0.4

The Requires

The Development Requires

by Oscar Otero

v3.0.3

The Requires