Summary
This chapter offered insight into some of the most common general tasks you’ll encounter when developing data-driven applications. The chapter started by providing a PostgreSQL data class and offering some basic usage examples involving this class. Next, you learned a convenient and easy method for outputting data results in a tabular format, and then learned how to add actionable options for each output data row. Building upon this material, you saw how to sort output based on a given table field. Finally, you learned how to spread query results across several pages and create linked page listings, enabling the user to navigate the results in a nonlinear fashion.
The next chapter introduces PostgreSQL’s implementation of views and rules, which help you to implement and maintain your full data model.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Rights and permissions
Copyright information
© 2006 W. Jason Gilmore
About this chapter
Cite this chapter
(2006). Practical Database Queries. In: Beginning PHP and PostgreSQL 8. Apress. https://doi.org/10.1007/978-1-4302-0136-6_31
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0136-6_31
Publisher Name: Apress
Print ISBN: 978-1-59059-547-3
Online ISBN: 978-1-4302-0136-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books