https://www.cloudways.com/blog/eloquent-illuminate-in-php-without-laravel/
Last updated
Updated on June 16, 2021
3 Min Read
Ask Laravel enthusiasts and they will tell you that Laravel Eloquent is one of the best parts of the framework. Have you ever thought of using Eloquent in Best PHP Hosting without installing the entire Laravel framework?
This is what I am going to discuss in this article. I will create a small ACL using Laravel Eloquent. The complete code of this tutorial can be found at this repo.
You might like: How To Host PHP On DigitalOcean
First, create a new folder in the public directory and name it “eloquent”. Now run the following composer command to install Eloquent.
composer require illuminate/database
Wait for composer to finish the installation.
Create a new file and name it bootstrap.php. I will use this file to setup Eloquent. Now paste the following code in it.
<?php
require "vendor/autoload.php";
use Illuminate\Database\Capsule\Manager as Capsule;
$capsule = new Capsule;
$capsule->addConnection([
"driver" => "mysql",
"host" =>"127.0.0.1",
"database" => "acl",
"username" => "root",
"password" => ""
]);
$capsule->setAsGlobal();
$capsule->bootEloquent();
The code starts with requiring the composer autoload class, then the required Eloquent Manager (Capsule), and finally created its instance. Through Capsule, I have set the database connection as global, and then booted Eloquent. After that, I created a new database on the localhost with the name “acl”.
First create a new folder and name it “database”. Now, create a new file for the users table and name it “User.php”. Next, paste the following code in it:
<?php
require "../bootstrap.php";
use Illuminate\Database\Capsule\Manager as Capsule;
Capsule::schema()->create('users', function ($table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password');
$table->string('userimage')->nullable();
$table->string('api_key')->nullable()->unique();
$table->rememberToken();
$table->timestamps();
});
The above code is similar to what I would write in Laravel. The difference is the `schema()` with reference from `Capsule` class. I will now create table for the roles. For that, create a new file and name it “Todo.php”. Paste the following code in it:
<?php
require "../bootstrap.php";
use Illuminate\Database\Capsule\Manager as Capsule;
Capsule::schema()->create('todos', function ($table) {
$table->increments('id');
$table->string('todo');
$table->string('description');
$table->string('category');
$table->integer('user_id')->unsigned();
$table->timestamps();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
});
I will now migrate all the files. For that open your browser and head to eloquent/database/user.php and eloquent/database/todo.php. If you see a blank page, the tables have been migrated successfully.
I will now create model classes using Eloquent.
Create a new folder and name it classes. Now open composer.json file and paste the following lines after require:
"autoload": {
"classmap": [
"classes"
]
}
This will help me add classes folder as autoload. Now create a new file inside the classes folder and name it User.php. Paste the following code:
<?php
use Illuminate\Database\Eloquent\Model as Eloquent;
class User extends Eloquent
{
/**
* The attributes that are mass assignable.
*
* @var array
*/
protected $fillable = [
'name', 'email', 'password','userimage'
];
/**
* The attributes that should be hidden for arrays.
*
* @var array
*/
protected $hidden = [
'password', 'remember_token',
];
/*
* Get Todo of User
*
*/
public function todo()
{
return $this->hasMany('Todo');
}
}
Next, create a new file, name it Todo.php and paste the following code:
<?php
use Illuminate\Database\Eloquent\Model as Eloquent;
class Todo extends Eloquent
{
protected $fillable = ['todo','category','description'];
}
All the classes are now in place and I could go ahead with the testing.
I will now create a new file at the root and name it index.php. Open this file and paste the following code in it:
<?php
require "bootstrap.php";
$user = User::Create([ 'name' => "Ahmed Khan", 'email' => "ahmed.khan@lbs.com", 'password' => password_hash("ahmedkhan",PASSWORD_BCRYPT), ]);
print_r($user->todo()->create([
'todo' => "Working with Eloquent Without PHP",
'category' => "eloquent",
'description' => "Testing the work using eloquent without laravel"
]));
When you execute this file, you will see the following output:
You might also like: Getting Started With PHPUnit For Unit Testing
In this article, I discussed how you could easily use PHP Eloquent Illuminate without installing Laravel. For a more complete reference on Eloquent, check out the official Laravel documentation. If you need any help with the code, so leave a comment below.
