Php Object Generator Tutorials
  1. Introduction to POG
  2. Setting up PHP, MySQL etc.
  3. Designing your objects
  4. Generating your code
  5. Description of the generated code
  6. Edit configuration file
  7. The Setup Process
  8. Using the code: Save()
  9. Using the code: Get()
  10. Using the code: SaveNew()
  11. Using the code: GetList()
  12. Using the code: Delete()
  13. Using the code: DeleteList()
  14. Advanced: object relations
  15. Advanced: Set{Parent}()
  16. Advanced: Get{Parent}()
  17. Advanced: Add{Child}()
  18. Advanced: Get{Child}List()
  19. Advanced: Save(deep)
  20. Advanced: Delete(deep)
  21. Advanced: Add{Sibling}()
  22. Advanced: Set{Child}List()
  23. Advanced: Set{Sibling}List()
  24. Advanced: Get{Sibling}List()
  25. Advanced: DeleteList(deep)
  26. Customizing POG-generated code
  27. Customizing: Extending POG Objects
  28. Customizing: Plugins
  29. Examples
  30. Examples: User registration system
  31. Examples: User authentication
  32. Examples: Survey form
  33. Examples: Using POG with AJAX
  34. PDO: Introduction
  35. PDO: SQLite example
  36. PDO: Firebird example
  37. PDO: PostgreSQL example
  38. PDO: MySQL example
  39. PDO: ODBC example
  40. Troubleshooting
  41. Troubleshooting: Data appears encoded
  42. Troubleshooting: Can't regenerate object
  43. Troubleshooting: Can't seem to Save()
  44. Troubleshooting: Can't get object / object attributes from database
  45. Troubleshooting: Can't open zip file on Mac
  46. Troubleshooting: Setup screen is blank
  47. Videos
  48. Appendix: Creating table(s) manually
  49. Appendix: Regenerating objects
  50. Appendix: Generating objects using SOAP
  51. Case Study: Gravity GTD
  52. Case Study: Web Form Factory


Want more Php Object Generator?
Back to the Code Generator
The POG Weblog and RSS feed.
The POG Google group


Using the code: DeleteList()


The DeleteList() CRUD method allows you to delete all objects from your database that meet certain conditions.

DeleteList($conditions)

$conditions is an array of arrays containing the conditions you want to place on the query a should look like this:

$conditions =
array(
array(“attribute1”, “comparator1”, “value1”),
array(“attribute2”, “comparator2”, “value2”),
...
)

Where
“attribute” is the name of the attribute, for e.g.
bookTitle

“comparator” can be any valid SQL comparator. For e.g.
=, >, <, >=, <=, <>, LIKE (only if db encoding is turned off)

“value” is the value of the condition, for e.g.
“Harry Potter”

EXAMPLES
If you want to delete all users whose age > 10, you'd write something like this:
PHP:
$user = new User();
$user->DeleteList(array(array("age", ">", "10")));


To delete all users whose age >10 and who logged in more than 20 times, you'd write something like this:
PHP:
$user = new User();
$user->DeleteList(array(array("age", ">", "10"), array("logInCount", ">", 20)));


To delete all books from your database, simply do the following:
PHP:
$book = new Book(); //create a book object
$book->DeleteList(array(array("bookid", ">", 0)));


To delete the 10 most recent news objects from your database:
PHP:
$news= new News(); //create a news object
$news->DeleteList(array(array("newsid", ">", 0)), "date", false); // returns a list of news objects ordered by date in descending order




POG documentation summary: