DBHelper For PHP

You can do many database operations without writing any SQL code with DBHelper. you need complex SQL queries or you want write sql query? DBHelper allows you to do this too.

Example Usage

PHP

include "DBHelper/DBHelper.php";
use \DBHelper\DBHelper;

$db = new DBHelper();

$db->connect();

$users = $db->get('users');
print_r($users);

$db->disconnect();

SQL Print

SELECT * FROM users

Result

(
    [0] => Array (
        [user_id] => 1
        [user_mail] => [email protected]
        [user_password] => 12345
        [json] => {"user":"Foo Bar","messages":["Foo","Bar"]}
        [created_at] => 2021-05-09 02:57:49
    )
    ...
)

Table of Contents

• Config
• Connect
• Disconnect
• Methods
  • Get All
  • Get First
  • Update
  • Delete
  • Query Builder
• Params
  • whereIn
  • whereOr
  • whereLike
  • whereNotIn
  • whereNotOr
  • whereNotLike
  • fields
  • distinct
  • count
  • orderBy
  • limit
  • offset
  • jsonParser
  • values

Config

You can configuration for database settings from DBHelper/DBHelper.php

private $host = '';
private $user = '';
private $password = '';
private $database = '';

Next, include DBHelper where you want to use it and create DBHelper.

include "DBHelper/DBHelper.php";
use \DBHelper\DBHelper;

$db = new DBHelper();

Connect

If you want access from database, you need connect to database.

$db->connect();

Disconnect

You can disconnect database when your work is done.

$db->disconnect();

Methods

# Get All

PHP

$db->get('users');

SQL

SELECT * from users

# Get First

PHP

$db->first('users');

SQL

SELECT * from users LIMIT 1

# Insert

PHP

$values = array(
    'user_mail' => '[email protected]',
    'user_password' => 'foobar'
);
$db->values($values);
$db->insert('users');

SQL

INSERT INTO users SET user_mail = "[email protected]", user_password = "foobar"

# Update

PHP

$values = array(
    'user_mail' => '[email protected]'
);
$db->values($values);

$db->whereIn(array(
    'user_mail' => '[email protected]'
));
$db->update('users');

SQL

UPDATE users SET user_mail = "[email protected]" WHERE user_mail = "[email protected]"

# Delete

PHP

$db->whereIn(array(
    'user_mail' => '[email protected]'
));
$db->delete('users');

SQL

DELETE FROM users WHERE user_mail = "[email protected]"

# Query Builder

PHP

$db->queryBuilder('SELECT * FROM users');

SQL

SELECT * FROM users

Params

# whereIn

PHP

$db->whereIn(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail = "[email protected]" AND user_password = "foobar"

# whereOr

PHP

$db->whereIn(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail = "[email protected]" OR user_password = "foobar"

# whereLike

PHP

$db->whereLike(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail LIKE "[email protected]" AND user_password LIKE "foobar"

# whereNotIn

PHP

$db->whereNotIn(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail != "[email protected]" AND user_password != "foobar"

# whereNotOr

PHP

$db->whereNotOr(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail != "[email protected]" OR user_password != "foobar"

# whereNotLike

PHP

$db->whereNotLike(array(
    'user_mail' => '[email protected]',
    'user_passowrd' => 'foobar'
));

SQL

WHERE user_mail NOT LIKE "[email protected]" AND user_password NOT LIKE "foobar"

# fields

PHP

$db->fields(array(
    'user_mail',
    'user_passowrd'
));

SQL

SELECT user_mail, user_password

# distinct

PHP

$db->fields(array(
    'user_mail'
));
$db->distinct(true);

SQL

SELECT DISTINCT user_mail

# count

PHP

$db->fields(array(
    'user_mail'
));
$db->count(true);

SQL

SELECT COUNT(user_mail)

# orderBy

PHP

$db->orderBy('created_at', 'ASC');

SQL

ORDER BY created_at ASC

# limit

PHP

$db->limit(1);

SQL

LIMIT 1

# offset

PHP

$db->offset(15);

SQL

OFFSET 15

# jsonParser

If you saving JSON on database, you can parse array to json or json to array with jsonParser. Just say pattern of your json data to jsonParser

PHP

$json = array(
    'foo' => array(
        'bar'
    )
);
$values = array(
    'json' => $json
);

$db->values($values);

$db->whereIn(array(
    'user_mail' => '[email protected]'
));

$db->jsonParser(array(
    'json'
));

$db->update('users');

SQL

UPDATE users SET json = "{\"foo\":[\"bar\"]}" WHERE user_mail = "[email protected]"

# values

PHP

$values = array(
    'user_mail' => '[email protected]',
    'user_password' => 'foobar'
);
$db->values($values);

$db->insert('users');

SQL

INSERT INTO users SET user_mail = "[email protected]", user_password = "foobar"