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 utajifunza jinsi ya kufanya sanitization kwenye user input ili kuzuia sql injection kwenye database.
Soma Zaidi...Katika somo hili utajifunza jinsi ambavyo utaweza kutengeneza mfumo wa kuisajiki na ku login, kisha kuangalia usalama wa mfumo kwa kuzuia sql injection.
Soma Zaidi...Katika somo hili utakwenda kujifunza kuhusu Maana ya JSON na sheria za kuandika faili la json
Soma Zaidi...Katika somo hili utakwenda kujifunza aina kuu 3 za variable katika PHP mabzo ni local variable, global variable na static variable.
Soma Zaidi...Katika somo hili utakwenda kujifunza kuhusu http redirect header
Soma Zaidi...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 utajifunza jinsi ya kutuma email kwa kutumia email() function ya PHP. Hii ni njia rahisi zaidi ya kutuma email. Ila hufanya kazi kwenye hosting.
Soma Zaidi...Katika somo hili utajifunza jinsi ya kutumia filter_var() function kwa ajili ya kuchuja code zilizo hatari kwenye PHP file
Soma Zaidi...Katika somo hili utakwenda kujifunza jinsi ya kutumia constatnt kwenye class.
Soma Zaidi...Katika ukurasa huu utakwenda kujifunz jinsi ya kuandika code za php kwa ajili ya kutuma post yetu kwenye blog.
Soma Zaidi...