fj-onathan / q-file

Filter a flat file

📝 Q-File!

Query File is basicaly a lightweight PHP class for queries (retrieve/select/where/order) custom data from a flat file. File is pretty to learn, not like JSON, or ARRAY, or SQL, all level of developers can learn easy that type of files.

Installation

Composer

Install with a command:

composer require fjonathan/q-file

Configuration

Buil the 'table' for using data to output and filter. Create a file like table.ay and build your own custom data

That's a example:

new "groups"

    (Google)
        [id: 1]

    (Whatsapp)
        [id: 2]

new "contact_list"

    (Jean Doe)
        [group: 2]
        [email: [email protected]]
        [avatar: user1.png]
        [address: 2722 Retreat Avenue]
        [city: Los Angeles]
        [phone: [phone]]

    (Michel Doe)
        [group: 1]
        [email: [email protected]]
        [avatar: user2.png]
        [address: 577 Carolina Avenue]
        [city: Fort Collins]
        [phone: [phone]]

Usage

Init package to starting using it

use File\Q;
$f = new Q;
$table = 'table.ay';

Return all data organized by keys

$data = $f
        ->table($table)
        ->record();

Options

These light class has many options to filter data, like:

• searchAll - search by primary table content - ->searchAll('groups')
• searchby - search by key group - ->searchBy('contact_list', 'group', 1)
• orderBy - order by asc/desc the results data -> orderBy('id', 'ASC')

Notes

This tool has been retrieved from an old project, and may not be constant updates, so use with care.