Book Image

Phalcon Cookbook

By : Serghei Iakovlev, David Schissler
1 (2)
Book Image

Phalcon Cookbook

1 (2)
By: Serghei Iakovlev, David Schissler

Overview of this book

Phalcon is a high-performance PHP framework delivered as a PHP extension. This provides new opportunities for speed and application design, which until recently have been unrealized in the PHP ecosystem. Packed with simple learning exercises, technology prototypes, and real-world usable code, this book will guide you from the beginner and setup stage all the way to advanced usage. You will learn how to avoid niche pitfalls, how to use the command-line developer tools, how to integrate with new web standards, as well as how to set up and customize the MVC application structure. You will see how Phalcon can be used to quickly set up a single file web application as well as a complex multi-module application suitable for long-term projects. Some of the recipes focus on abstract concepts that are vital to get a deep comprehension of Phalcon and others are designed as a vehicle to deliver real-world usable classes and code snippets to solve advanced problems. You’ll start out with basic setup and application structure and then move onto the Phalcon MVC and routing implementation, the power of the ORM and Phalcon Query Language, and Phalcon’s own Volt templating system. Finally, you will move on to caching, security, and optimization.
Table of Contents (17 chapters)
Phalcon Cookbook
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Fetching models from raw SQL queries


In this recipe, we will learn how to retrieve data using raw SQL for when PHQL doesn't meet our needs. Although PHQL does a lot, and can be extended by using custom database specific dialects, it isn't always enough. It would be terrible if we were simply out of luck and unable to fulfill a niche need and fortunately, Phalcon is able to get out of the way and to provide us raw SQL access to our database service. This means that we can use PHQL based technology for almost everything in our system and then, if we hit a wall, we can switch over to writing the query directly with SQL.

Note: One potential downside to consider when using raw SQL is that if we are doing so to implement database implementation specific vendor features then it could make our system no longer able to work with other databases.

Getting ready

This recipe uses the chapter_04 database that we set up in the chapter introduction and Phalcon Developer Tools, which we will use to set up a...