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: GetList()

The GetList() CRUD method allows you to return a list of objects from your database using specific conditions. The GetList() method supports

  • specifying multiple conditions
  • sorting and
  • limiting the result set.

GetList() does not support partial string matching out-of-the-box if Data Encoding is enabled, although workarounds do exist

GetList($conditions, [, $sortBy] [,$ascending] [,$limit]) returns an array of objects.

GetList takes 1 required parameter and 3 optional ones.
$conditions is an array of arrays containing the conditions you want to place on the query.

For example, $conditions should look like this:
$conditions = array( array(“attribute1”, “comparator1”, “value1”), array(“attribute2”, “comparator2”, “value2”,...)

“attribute” is the name of the attribute, for eg “bookTitle”
“comparator” can be any SQL comparator. For eg: ”=”, ”>”, “<", ">=”, “<=", "<>”
“value” is the value of the condition.
For e.g this is what the generated code for the GetList() function might look like:

If you want to get a list of users whose age > 10, you’d write something like this:

$user = new User();
$userList = $user->GetList(array(array("age", ">", "10")));

To get a list of users whose age >10 and who logged in more than 20 times, you’d write something like this:

$user = new User();
$userList = $user->GetList(array(array("age", ">", "10"), array("logInCount", ">", 20)));

To get a list of all books from your database, simply do the following:

$book = new Book(); //create a book object
$bookList = $book->GeList(array(array("bookid", ">", 0)));
foreach ($bookList as $book)
    echo $book->title;

To get the 10 most recent news objects from your database:

$news= new News(); //create a news object
$newsList= $news->GetNewsList(array(array("newsid", ">", 0)), "date", false); // returns a list of news objects ordered by date in descending order
foreach($newsList as $news)
    echo $news->title;

To get the total number of books whose price is above $100:

$book= new Book(); //create a book object
$bookList= $book->GetBookList(array(array("price", ">", "100"))); // returns a list of book objects whose price > 100
echo count($bookList);counts the number of object in the list

POG documentation summary: