Home

Querying the database with db_select()

Drupal: 17m
previous video
next video
Video Series

Module Development for Drupal 7

Title Play button
1. Introduction to Module Development for Drupal 7 FREE 5m
2. Helpful tools for module development 6m
3. An overview of the Devel module 14m
4. Drupal API documentation FREE 10m
5. Anatomy of a Drupal module 7m
6. The event-driven hook system 16m
7. Tips for writing secure code 8m
8. Overview of the Drupal menu system 19m
9. Using URL arguments in page callback functions 20m
10. Adding contextual menu links and using menu autoloaders 15m
11. Using the Drupal Render API 14m
12. Attachments and caching with the Render API 10m
13. Altering the page array 7m
14. Integrating with the theme system 28m
15. An Overview of the Form API 10m
16. Creating, submitting and validating a simple form 17m
17. Organizing collections of form elements 8m
18. Creating dynamic forms with the states system 8m
19. Altering forms with hook_form_alter() 11m
20. Altering specific forms and customizing validation 14m
21. Creating a configuration settings form for your module 24m
22. An overview of the database layer in Drupal 7 18m
23. Querying the database with db_select() 17m
24. Adding a table to the database 11m
25. Querying the database with query methods 25m
26. Altering the database 14m
Information

In this chapter we learn how to get data out of the database and display it. The example walks through writing a module that creates a page that displays how many nodes are published and unpublished for each content type in our site. We use the db_select() function to accomplish this.

Tagged: , and
Discussion

Comments

You need to be an active subscriber to comment. or .
Lullabot logo

Lullabot has trained thousands of Drupal developers & guided the development of some of the largest Drupal websites.