Low code , Zero Configuration ORM that creates models, config, database and tables on the fly.
Complete documentation can be found here
You can install Arca ORM via Composer. If you don't have composer installed , you can download composer from here
composer require scrawler/arca
<?php
include './vendor/autoload.php'
$connectionParams = array(
'dbname' => 'YOUR_DB_NAME',
'user' => 'YOUR_DB_USER',
'password' => 'YOUR_DB_PASSWORD',
'host' => 'YOUR_DB_HOST',
'driver' => 'pdo_mysql', //You can use other supported driver this is the most basic mysql driver
);
// For Arca ORM 1.x
// $db = new \Scrawler\Arca\Database($connectionParams);
// For Arca 2.x and later
$db = \Scrawler\Arca\Facade\Database::connect($connectionParams);
For complete list of driver check here
// Create new record
// The below code will automatically create user table and store the record
$user = $db->create('user');
$user->name = "Pranja Pandey";
$user->age = 24
$user->gender = "male"
$user->save()
// Get record with id 1
$user = $db->get('user',1);
//Get all records
$users = $db->get('user');
// Update a record
$user = $db->get('user',1);
$user->name = "Mr Pranjal";
$user->save();
// Delete a record
$user = $db->get('user',1);
$user->delete();
For complete CRUD documentaion visit here
// Using where clause
$users = $db->find('user')
->where('name = "Pranjal Pandey"')
->get();
foreach ($users as $user){
// Some logic here
}
// Get only single record
$users = $db->find('user')
->where('name = "Pranjal Pandey"')
->first();
// Using limit in query
$users = $db->find('user')
->setFirstResult(10)
->setMaxResults(20);
->get()
For complete Query documentaion visit here
If you have reached here consider giving a star to help this project โค๏ธ
Here is list of few things that i would like to add in upcoming release
Arca ORM is created by Pranjal Pandey and released under the Apache 2.0 License.