Somo hili litakwenda kukutajia baadhi ya library za php ambazo hutumika kwa matumizi ya ORM
Kuna library kadhaa za PHP ambazo unaweza kutumia kwa ORM (Object-Relational Mapping) bila kuhitaji kutumia framework kama Laravel au Symfony. Hapa kuna baadhi ya bora zaidi:
composer require illuminate/database
use Illuminate\Database\Capsule\Manager as Capsule;
require 'vendor/autoload.php';
$capsule = new Capsule;
$capsule->addConnection([
'driver' => 'mysql',
'host' => '127.0.0.1',
'database' => 'test_db',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
]);
$capsule->setAsGlobal();
$capsule->bootEloquent();
class User extends Illuminate\Database\Eloquent\Model {}
$users = User::all();
foreach ($users as $user) {
echo $user->name;
}
composer require doctrine/orm
composer require gabordemooij/redbean
require 'vendor/autoload.php';
use RedBeanPHP\R;
R::setup('mysql:host=127.0.0.1;dbname=test_db', 'root', '');
$book = R::dispense('books');
$book->title = "PHP ORM";
R::store($book);
$books = R::findAll('books');
foreach ($books as $book) {
echo $book->title;
}
composer require catfan/medoo
require 'vendor/autoload.php';
use Medoo\Medoo;
$database = new Medoo([
'database_type' => 'mysql',
'database_name' => 'test_db',
'server' => '127.0.0.1',
'username' => 'root',
'password' => ''
]);
$database->insert("users", [
"name" => "John Doe",
"email" => "john@example.com"
]);
$users = $database->select("users", ["name", "email"]);
print_r($users);
composer require j4mie/idiorm j4mie/paris
require 'vendor/autoload.php';
ORM::configure('mysql:host=127.0.0.1;dbname=test_db');
ORM::configure('username', 'root');
ORM::configure('password', '');
class User extends Model {}
$user = Model::factory('User')->create();
$user->name = "Jane Doe";
$user->save();
$users = Model::factory('User')->find_many();
foreach ($users as $user) {
echo $user->name;
}
| Library | Faida | Hasara |
|---|---|---|
| Eloquent (Standalone) | Ina nguvu na ni rahisi kama unajua Laravel | Inaleta dependencies nyingi |
| Doctrine ORM | Ina nguvu sana na inafuata OOP kwa kina | Inahitaji kujifunza configuration |
| RedBeanPHP | Haihitaji configuration, ni rahisi sana | Inaweza kuwa nzito kwenye projects kubwa |
| Medoo | Nyepesi, rahisi kutumia | Haina feature nyingi za ORM halisi |
| Paris + Idiorm | Rahisi kwa matumizi ya SQL-style ORM | Ina community ndogo |
Ikiwa unataka ORM rahisi bila kuingia kwenye configuration nyingi, RedBeanPHP au Medoo ni chaguo zuri.
Ikiwa unataka ORM yenye nguvu zaidi, Eloquent au Doctrine ni bora.
RedBeanPHP ni chaguo bora kwa miradi midogo na ya kati kwa sababu ni rahisi kutumia, haina configuration nyingi, na inaweza kujenga database yenyewe bila migrations.
Kwa mujibu wa mafunzo haya tutatumia library ya ReadBeanPHP ili kuonyesha uhalisia wa jinsi ORM zinavyoweza kufanya kazi katika uhalisia wake.
Kama unatumia Composer, ingiza amri hii kwenye terminal yako:
composer require gabordemooij/redbean
Hata hivyo njia ya composer haipendekezwi kutumiwa. Wenyewe waliotengeneza library hiyo wanapendekeza u download faili moja kw amoja kwenye website yao. Tembelea link hii unaweza kupakua rb.php kutoka 👉 RedBeanPHP Official
Katika faili lako la PHP, ongeza RedBean">...
Umeionaje Makala hii.. ?
Katika somo hili utakwenda kujifunza jinsi ya kutumia PDO kutengeneza database, kuteneneza table na kuingiza data moja na zaidi ya moja.
Soma Zaidi...Katika somo hili utakwenda kujifunza kuhusu aina ya header inayoitwa Content-Disposition
Soma Zaidi...Katika somo il utajifunza kutuma email kwa watu wengi kwa kutumia PHPMailer. Pia utajifunza jinsi ya kuweka Carbon Copy na Blind Carbon Copy
Soma Zaidi...Katika somo hili utajifunza jinsi ya kuandika while loop kwenye PHP
Soma Zaidi...Katika somo hili utakwenda kujifunza jinsi ya ku generate PDF automatik kutoka kwenye php code , html, javascript na css.
Soma Zaidi...Katika somo hii utakwenda kujifunza jinsi ya kufanya CRUDE operation kwa kutumia PDO. crude operation inahusu create, read, update. Delete.
Soma Zaidi...Katika somo hili utajifunza jinsi ya ku connect database, kwa kutumia php
Soma Zaidi...Katika somo hili utakwenda kujifunza jinsi ya kusoma muda kama saa na tarehe kwa kutumia PHP
Soma Zaidi...Katika somo hili utakwenda kujifunza aina za data ambazo hutumika kwenye PHP
Soma Zaidi...Katika soo hili utakwenda kujifunza umuhmu wa kutumia PDO kwenye PHP kwa ajili ya kutumia database.
Soma Zaidi...