Book Image

Yii2 Application Development Cookbook. - Third Edition

By : Andrew Bogdanov, Dmitry Eliseev
Book Image

Yii2 Application Development Cookbook. - Third Edition

By: Andrew Bogdanov, Dmitry Eliseev

Overview of this book

Yii is a free, open source web application development framework written in PHP5 that promotes clean DRY design and encourages rapid development. It works to streamline your application development time and helps to ensure an extremely efficient, extensible, and maintainable end product. Being extremely performance optimized, Yii is a perfect choice for any size project. However, it has been built with sophisticated, enterprise applications in mind. You have full control over the configuration from head-to-toe (presentation-to-persistence) to conform to your enterprise development guidelines. It comes packaged with tools to help test and debug your application, and has clear and comprehensive documentation. This book is a collection of Yii2 recipes. Each recipe is represented as a full and independent item, which showcases solutions from real web-applications. So you can easily reproduce them in your environment and learn Yii2 fast and without tears. All recipes are explained with step-by-step code examples and clear screenshots. Yii2 is like a suit that looks great off the rack, but is also very easy to tailor to fit your needs. Virtually every component of the framework is extensible. This book will show how to use official extensions, extend any component, or write a new one. This book will help you create modern web applications quickly, and make sure they perform well using examples and business logic from real life. You will deal with the Yii command line, migrations, and assets. You will learn about role-based access, security, and deployment. We’ll show you how to easily get started, configure your environment, and be ready to write web applications efficiently and quickly.
Table of Contents (19 chapters)
Yii2 Application Development Cookbook Third Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Getting data from a database


Most applications use databases today. Be it a small website or a social network, at least some parts are powered by databases.

Yii introduces three ways to allow you to work with databases. They are as follows:

  • Active Record

  • Query Builder

  • SQL via DAO

We will use all these methods to get data from the film, film_actor, and actor tables and show it in a list. Also, we will compare the execution time and memory usage to determine in which cases we should use these methods.

Getting ready

  1. Create a new application using the Composer package manager, as described in the official guide at http://www.yiiframework.com/doc-2.0/guide-start-installation.html.

  2. Download the Sakila database from http://dev.mysql.com/doc/index-other.html.

  3. Execute the downloaded SQLs; first schema, then data.

  4. Configure the DB connection in config/main.php to use the Sakila database.

  5. Use Gii to create models for the actor and film tables.

How to do it…

  1. Create app/controllers/DbController.php as follows:

    &lt...