PHP somo la 99: Jinsi ya kutumia ORM kwa kutumia library ya RedBeanPHP

Katika somo hili utakwenda kujifunza Jinsi ya kutumia ORM kwa kutumia library ya RedBeanPHP

Hapa sasa ndipo tunakwenda kuitumia database yetu ili kuweza kutengeneza shopmanagement app. Tutatumia table zile zile tulizozitumia awali. Tutafanya kile kile tulichokifanya. Hapa utaona urahisi zaidi wa kutumia ORM.

 

Hii ni setup nzuri kwa mfumo wa "Shop Management" kwa kutumia RedBeanPHP. ✅ Nitakuandikia kila ukurasa (products.php, customers.php, transactions.php) hatua kwa hatua na kuhakikisha kuwa unaweza:

  1. Kuongeza bidhaa (products)
  2. Kuongeza wateja (customers)
  3. Kufanya manunuzi (transactions)
  4. Kuonyesha data zote
  5. Kuhariri (edit) na kufuta (delete) rekodi

🔹 Kwanza: Unda Database shop

Hakikisha umeunda database shop, kisha RedBeanPHP itajenga tables moja kwa moja.

CREATE DATABASE shop;

Kisha hakikisha umeinstall RedBeanPHP kama nilivyoeleza awali.


📌 1. db.php - Kusanidi RedBeanPHP

Faili hili litatumika katika kila ukurasa kuunganisha database. Kutumia composer kunaweza kuleta shida ikawa baadhi ya mafaili hayapatikani hivyo ukiwa na tatizo hilo vyema kutembelea kwenye website yao kisha download faili husika la driver, kisha include kwenye faili la database configuration. rejea somo lililotangualia.

<?php
require 'vendor/autoload.php';

R::setup('mysql:host=127.0.0.1;dbname=shop', 'root', ''); 

if (!R::testConnection()) {
    die('Database haijaunganishwa!');
}
?>

📌 2. products.php - Kusimamia Bidhaa (Products)

<?php
require 'db.php';

// Ongeza Product
if (isset($_POST['add'])) {
    $product = R::dispense('products');
    $product->name = $_POST['name'];
    $product->price = $_POST['price'];
    R::store($product);
    header("Location: products.php");
}

// Futa Product
if (isset($_GET['delete'])) {
    $product = R::load('products', $_GET['delete']);
    R::trash($product);
    header("Location: products.php");
}

// Hariri Product
if (isset($_POST['edit'])) {
    $product = R::load('products', $_POST['id']);
    $product->name = $_POST['name'];
    $product->price = $_POST['price'];
    R::store($product);
    header("Location: products.php");
}

// Pata Products zote
$products = R::findAll('products');
?>

<h2>Manage Products</h2>
<form method="post">
    <input type="text" name="name" placeholder="Product Name" required>
    <input type="number" name="price" placeholder="Price" required>
    <button type="submit" name="add">Add Product</button>
</form>

<table border="1">
    <tr><th>Name</th><th>Price</th><th>Action</th></tr>
    <?php foreach ($products as $product): ?>
    <tr>
        <td><?= $product->name; ?></td>
        <td><?= $product->price; ?></td>
        <td>
            <a href="?delete=<?= $product->id; ?>">Delete</a>
            <form method="post" style="display:inline;">
                <input type="hidden" name="id" value="<?= $product->id; ?>">
                <input type="text" name="name" value="<?= $product->name; ?>">
                <input type="number" name="price" value="<?= $product->price; ?>">
                <button type="submit" name="edit">Edit</button>
            </form>
        </td>
    </tr>
    <?php endforeach; ?>
</table>

📌 3. customers.php - Kusimamia Wateja (Customers)

<">
...

Jiunge nasi WhatsApp kupata update zetu

Zoezi la Maswali

Nyuma Endelea


Umeionaje Makala hii.. ?

Nzuri            Mbaya            Save
Author: Rajabu image Tarehe: 1970-01-01 03:33:45 Topic: PHP Main: ICT File: Download PDF Views 352

Share On:

Facebook WhatsApp
Sponsored links
👉1 Simulizi za Hadithi Audio    👉2 Tafasiri ya Riyadh Swalihina    👉3 Kitabu cha Afya    👉4 web hosting    👉5 Bongolite - Game zone - Play free game    👉6 kitabu cha Simulizi   

Post zinazofanana:

PHP - somo la 20 : Jinsi ya kufuta na ku update data kwenye database kwa kutumia PHP

Katika somo hili utakwenda kujifunza jinsi ya ku update na kufuta data kwenye database kwa kutumia PHP

Soma Zaidi...
PHP somo la 52: Aina za access modifire na zinavyotofautiana.

Katika somo hili utakwenda kujifunza kuhusu access modifier ili kuweza kuthibiti nama ya kuzitumia properties kwenye class.

Soma Zaidi...
PHP somo la 70: jinsi ya kutuma email yenye html, picha na attachment

Katika somo hili utakwenda kujifunza jinsi ya kutuma email ambayo ina HTML, pia utajifunza kutuma email yenye picha na attachment nyinginezo kama pdf

Soma Zaidi...
PHP - somo la 27: aina za variable kwenye PHP

Katika somo hili utakwenda kujifunza aina kuu 3 za variable katika PHP mabzo ni local variable, global variable na static variable.

Soma Zaidi...
PHP -somo la 33: Matumizi ya while loop kwenye PHP

Katika somo hili utajifunza jinsi ya kuandika while loop kwenye PHP

Soma Zaidi...
PHP somo la 73: Maana ya http header

Katika somo hili utakwenda kujifunza kuhusu http header, maana yake na jinsi ya kusoma taarifa zilizopo kwenye http header.

Soma Zaidi...
PHP somola 78: Cookie Headers

Katika somo hili utakwenda kujifunza kuhusu Cookie Headers

Soma Zaidi...
PHP somo la 65: Jinsi ya kusoma data kwenye database kwa kutumia PDO

Katika somo hili utakwenda kujifunza jinsi ya kusoma data kwenye database kwa kutumia PDO.

Soma Zaidi...
PHP -somo la 6: Jinsi ya kusoma saa na tarehe kwenye PHP

Katika somo hili utakwenda kujifunza jinsi ya kusoma muda kama saa na tarehe kwa kutumia PHP

Soma Zaidi...
PHP BLOG - somo la 11: Jinsi ya kutumia prepared statement

Katika somo hili utajifnza jinsi ya kufanya prepared statement kama njia ya kuzuia sql ingection kwenye PHP blog

Soma Zaidi...