as247 / wp-eloquent
Eloquent ORM for wordpress.
Installs: 17 712
Dependents: 1
Suggesters: 0
Security: 0
Stars: 40
Watchers: 4
Forks: 19
Open Issues: 0
Requires
- php: ^7.3|^8.0
- ext-json: *
- ext-pdo: *
Suggests
- doctrine/dbal: Required to rename columns and drop SQLite columns (^2.6).
- fzaninotto/faker: Required to use the eloquent factory builder (^1.9.1).
- symfony/finder: Required to use Eloquent model factories (^5.1).
README
This package extract from laravel 8.9
The WpEloquent component is a full database toolkit for PHP, providing an expressive query builder, ActiveRecord style ORM, and schema builder. It currently supports MySQL, Postgres, SQL Server, and SQLite.
Installing
composer require as247/wp-eloquent
Usage Instructions
First, boot Application with a connection.
Use $wpdb connection
use As247\WpEloquent\Application; Application::bootWp();
Use separated connection
use As247\WpEloquent\Application; Application::boot([ 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'database', 'username' => 'root', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ]);
Once the Application booted. You may use it like so:
Using The Query Builder
use As247\WpEloquent\Support\Facades\DB; $users = DB::table('users')->where('votes', '>', 100)->get();
Other core methods may be accessed directly from the Capsule in the same manner as from the DB facade:
use As247\WpEloquent\Support\Facades\DB; $results = DB::select('select * from users where id = ?', [1]);
Using The Schema Builder
use As247\WpEloquent\Support\Facades\Schema; Schema::create('users', function ($table) { $table->increments('id'); $table->string('email')->unique(); $table->timestamps(); });
Using The Eloquent ORM
class User extends As247\WpEloquent\Database\Eloquent\Model {} $users = User::where('votes', '>', 1)->get();
For further documentation on using the various database facilities this library provides, consult the Laravel framework documentation.
Version 1.0
You are looking for v1.x? Check it here https://github.com/as247/wp-eloquent/tree/1.x