README

Languages

العربية - English

Document

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

Install Library composer require i74ifa/dbsystem

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

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

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

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

This Option is Beta I use it

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

i74ifa / dbsystem

Maintainers

Details