adecoder/eloquent

PDO Connection and MySQL Queries in PHP

Maintainers

Details

github.com/md-aamroni/eloquent

Source

Issues

Installs: 4

Dependents: 0

Suggesters: 0

Security: 0

Stars: 1

Watchers: 1

Forks: 0

Open Issues: 0

1.0 2022-02-01 17:25 UTC

Requires

  • php: >=8.0

MIT 91f9a8455aae72bc6290453a50cd40a7a49a2007

This package is auto-updated.

Last update: 2025-03-01 00:37:06 UTC

README

PDO Connection and MySQL Queries in PHP

workflow Copyright License Developed Copyright

Installation

composer require adecoder/eloquent

Environment File

DB_APP_HOST=localhost
DB_APP_PORT=3308
DB_APP_NAME=xtra_guideasy_app_rdb
DB_APP_CHAR=utf8mb4
DB_APP_USER=root
DB_APP_PASS=

Select Statement

use Adecoder\Eloquent\Eloquent;

$query = "SELECT * FROM table_name WHERE id = :B_SEARCH;";
$param = array(':B_SEARCH' => 2);

$select = Eloquent::select(query: $query, param: $param, itself: false)->get();
dd($select);

Create Statement

use Adecoder\Eloquent\Eloquent;

$query = "INSERT INTO table_name (username, email_id) VALUE(:B_USER, :B_MAIL)";
$param = array(':B_USER' => 'md.aarmoni', ':B_MAIL' => 'md.aamroni@gmail.com');

$create = Eloquent::create(query: $query, param: $param, array: false)->get();
dd($create);

Delete Statement

use Adecoder\Eloquent\Eloquent;

$query = "DELETE FROM table_name WHERE id = :B_DELETE;";
$param = array(':B_DELETE' => 14);

$delete = Eloquent::delete(query: $query, param: $param, array: false)->get();
dd($delete);

Update Statement

use Adecoder\Eloquent\Eloquent;

$query = "UPDATE table_name SET username = :B_USER, email_id = :B_MAIL WHERE id = :B_UPDATE;";
$param = array(':B_USER' => 'md-aarmoni', ':B_MAIL' => 'aamroni@gmail.com', ':B_UPDATE' => 14);
$update = Eloquent::update(query: $query, param: $param, array: false)->get();
dd($update);