PHPackages                             i74ifa/dbsystem - 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. i74ifa/dbsystem

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

i74ifa/dbsystem
===============

Simple OOP system to query data from database and insert and create tables.

v0.4(5y ago)213MITPHPPHP >=7.1

Since Oct 10Pushed 5y ago1 watchersCompare

[ Source](https://github.com/i74ifa/dbsystem)[ Packagist](https://packagist.org/packages/i74ifa/dbsystem)[ RSS](/packages/i74ifa-dbsystem/feed)WikiDiscussions main Synced today

READMEChangelogDependencies (1)Versions (3)Used By (0)

### Languages

[](#languages)

[العربية](https://github.com/i74ifa/dbsystem/blob/main/Readme-ar.md) - [English](https://github.com/i74ifa/dbsystem/)

Document
========

[](#document)

Features
--------

[](#features)

- SELECT DATA
- INSERT DATA
- File Config `define` - config/app.php
- how to make `Config` app and database
- functions `Query()`
- BluePrint Queries
    - INT
    - TEXT
    - VARCHAR
    - BigIneger
    - Timestamps \[created\_at & updated\_at\]

How to Setup
------------

[](#how-to-setup)

- Install Library composer require i74ifa/dbsystem

how to Use
----------

[](#how-to-use)

- `you need Session because the error storage on $_SESSION['errors']`

    ```
      session_start();
      require "vendor/autoload.php";
      use DBsystem74I\Database\DB;

      $DB = new DB;

    ```

- You have var `$DB`

### SELECT DATA

[](#select-data)

```
  $result = $DB->table('nametable')->Select(['*'])->run();

  foreach ($result as $row) {
    echo $row['nameCol1'] . '';
    echo $row['nameCol2'] . '';
  }

```

### Insert Data

[](#insert-data)

- you have two method to insert INSERT() & INSERTCol()
- `INSERT()`

    - this function to insert all Columns

        - you don't need type name Column

            ```
              //Data in Table users
              |---------------------------------|
              | id | name | username | password |

            ```
        - INSERT to All Columns :

            ```
            $DB->table('users')->INSERT([1, 'anyName', 'username', 'Password'])->run();

            ```
- `INSERTCol()`

    - Use this Method if you don't need insert Columns NULL or id is AUTO\_INCREMENT()

        ```
         $DB->table('users')->INSERTCol(['name', 'username'], ['value name', 'value username'])->run();

        ```

### Migration Data Table

[](#migration-data-table)

- This Option is Beta I use it

- Go in vendor/i74ifa/dbsystem/Migration/Migrate.php

###  Health Score

21

—

LowBetter than 18% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

 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 ~0 days

Total

2

Last Release

2090d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/1703357a40c48453eeb972fd2297ed8b545fa001843f863c43443c137f220150?d=identicon)[74ifa](/maintainers/74ifa)

---

Top Contributors

[![i74ifa](https://avatars.githubusercontent.com/u/69402911?v=4)](https://github.com/i74ifa "i74ifa (17 commits)")

---

Tags

databasemysqlsqlDatabase System74ifa

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/i74ifa-dbsystem/health.svg)

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

###  Alternatives

[doctrine/dbal

Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management.

9.7k605.0M6.8k](/packages/doctrine-dbal)[cycle/database

DBAL, schema introspection, migration and pagination

71777.8k53](/packages/cycle-database)[rah/danpu

Zero-dependency MySQL dump library for easily exporting and importing databases

62414.3k11](/packages/rah-danpu)[opis/database

A database abstraction layer over PDO, that provides a powerful and intuitive query builder, bundled with an easy to use schema builder

10085.4k3](/packages/opis-database)[davmixcool/php-dbcloud

Easily backup PostgreSql or MySql database to the cloud

111.5k](/packages/davmixcool-php-dbcloud)

PHPackages © 2026

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