Jinsi ya Kuzuia Delete, Force Delete na Hard Delete Kwenye Database (PHP + MySQL Full Course)

By Faulink Systems
Website: https://faulink.com

Utangulizi

Katika mifumo ya kisasa kama:

School Management System
Accounting System
Sales System
Loan System
Employee System
Blog System
Inventory System

moja ya mambo muhimu sana ni usalama wa data.

Watumiaji wengi hujiuliza:

Kwa nini mfumo umekataa kufuta taarifa?
Kwa nini inatokea error ya Foreign Key?
Kuna tofauti gani kati ya Disable, Soft Delete na Hard Delete?
Ni wakati gani nitumie Hard Delete?

Makala hii itakufundisha concepts hizi kwa lugha rahisi na kwa vitendo.

1. Delete ya Kawaida ni Nini?

Delete ya kawaida ni kufuta taarifa moja kwa moja kutoka database.

Mfano:

DELETE FROM users WHERE id = 5;

Baada ya command hii:

Data huondoka database kabisa
Haiwezi kurudi kirahisi
Inahitaji backup ili kuirejesha

Ndiyo maana delete ya kawaida inaweza kuwa hatari.

2. Foreign Key ni Nini?

Foreign Key ni sheria ya database inayounganisha tables.

Mfano:

Table ya schools:

schools
id
school_name

Table ya users:

users
id
full_name
school_id

Hapa:

users.school_id

inaunganishwa na:

schools.id

Kwa hiyo user anakuwa sehemu ya school.

3. Kwa Nini Mfumo Hukataa Delete?

Mfano:

Unajaribu kufuta school:

DELETE FROM schools WHERE id=26;

lakini users bado wanaitumia.

MySQL italeta:

Cannot delete or update a parent row

Kwa nini?

Kwa sababu:

School ni Parent
Users ni Child

Database inalinda data isipotee.

Mfano:

Ukifuta school bila tahadhari:

users wanabaki bila school
reports zinaharibika
mfumo unaweza ku-crash

Ndiyo maana foreign key ni muhimu.

4. Soft Delete (Disable System)

Soft delete maana yake:

data haifutwi — inafichwa au kuzimwa.

Mfano:

users table:

is_active = 1

Active.

Ukidisable:

is_active = 0

User hawezi login lakini taarifa zipo.

Mfano PHP:

UPDATE users
SET is_active=0
WHERE id=5;

Faida:

Hakuna kupoteza data
Salama
Unaweza kurudisha data

Ndiyo maana mifumo mikubwa hutumia Soft Delete.

5. Hard Delete ni Nini?

Hard delete ni:

kufuta data kabisa database.

Mfano:

DELETE FROM users WHERE id=5;

Baada ya hapo:

record haipo
haionekani
haiwezi kurudishwa bila backup

Hard delete hutumika kwa tahadhari kubwa.

6. Force Delete ni Nini?

Force delete au hard delete yenye nguvu ni:

kufuta parent pamoja na child records zinazomtegemea.

Mfano:

School:

schools

Users:

users

Assignments:

teacher_subject_assignments

Order sahihi:

teacher_subject_assignments
→ users
→ schools

Mfano PHP:

$pdo->beginTransaction();

DELETE assignments;
DELETE users;
DELETE school;

$pdo->commit();

Hii ndiyo hard delete ya kitaalamu.

7. ON DELETE CASCADE ni Nini?

Cascade ni automation ya database.

Mfano:

FOREIGN KEY (school_id)
REFERENCES schools(id)
ON DELETE CASCADE

Ukifuta school:

users wote wanafutwa automatic

Faida:

code ndogo
delete rahisi

Hasara:

unaweza kufuta data nyingi bila kujua

Tumia kwa tahadhari.

8. Soft Delete vs Hard Delete
Soft Delete
Data ipo
Salama
Recover possible
Recommended
Hard Delete
Data inafutwa kabisa
Haraka
Risk kubwa
Tumia kwa admin wenye ruhusa
9. Mfumo Mkubwa Hutumia Nini?

Mifumo mingi hutumia:

Disable / Soft Delete kwa kawaida
Hard Delete kwa Super Admin pekee
Backup kabla ya delete

Mfano:

Banking systems
ERP
School systems
Accounting systems
10. Best Practice Kwa Developers

Usifanye:

DELETE FROM parent

moja kwa moja.

Badala yake:

Hatua 1

Angalia dependencies.

Hatua 2

Futa child tables kwanza.

Hatua 3

Tumia transaction.

Mfano:

beginTransaction();
commit();
rollback();

Hii inalinda mfumo.

Hitimisho

Delete si kufuta tu.

Developer mzuri anatakiwa kuelewa:

Foreign Key
Parent vs Child Tables
Soft Delete
Hard Delete
Cascade Delete
Transaction Safety

Ukielewa concepts hizi, utaweza kutengeneza mifumo salama na ya kitaalamu zaidi.

Jifunze Coding, PHP, MySQL na Mifumo Zaidi Kupitia Faulink Systems

Website: https://faulink.com

Faulink inatoa mafunzo, blog posts na mifumo ya shule, biashara, uhasibu na database kwa Kiswahili.