CODEWITHSUNDEEP
phpmysql
Revenant
Revenant

Reputation: 2984

PHP, deleting a category from unlimited category table

I would like to know what is the best way to achieve deleting a category (with all sub categories) from unlimited category table.

I was planing to go with;

Edit: My category table's structure

array(8) {
  ["id"]=>
  NULL
  ["parent_id"]=>
  NULL
  ["siteID"]=>
  NULL
  ["memberGroups"]=>
  NULL
  ["name"]=>
  NULL
  ["language"]=>
  NULL
  ["protectDelete"]=>
  NULL
  ["typeID"]=>
  NULL
}

Thank you for your time and concern.

Upvotes: 1

Views: 552

Answers (1)

David
David

Reputation: 219106

If the concern is in deleting a record upon which many other records have a referential constraint, perhaps a strict delete isn't the right approach.

Instead, maybe try a "soft delete" where instead of deleting the record you'd set some flag on the record (such as an IsActive bit/tinyint field being set to false or 0). The logic surrounding the database would then need to know to filter on this field. The filtering is particularly easy if all of the data access is done through stored procedures or through a central data access layer in code, because the filter can then be transparent to the rest of the application.

It's a little more logic/work, but note the added benefits here:

  • Deletes are very fast, regardless of referential constraints on child records
  • Deletes are not permanent and are very easily recoverable
  • Deletes don't necessarily have to cascade (child records can still be active and orphaned, depending on the logic for those particular entities)

Upvotes: 2

Related Questions