Book Image

Yii2 By Example

By : Fabrizio Caldarelli
Book Image

Yii2 By Example

By: Fabrizio Caldarelli

Overview of this book

Yii is a high-performance PHP framework best for developing Web 2.0 applications. It provides fast, secure, and professional features to create robust projects, however, this rapid development requires the ability to organize common tasks together to build a complete application. It's all too easy to get confused; this is where this book comes in. This book contains a series of practical project examples for developers starting from scratch. Each section contains the most relevant theories for every topic as you walk through developing each project, focusing on key aspects that commonly confuse users. The book starts with all the framework’s basic concepts, such as controllers and views, to introduce you to Yii and creating your first application, a simple news reader. You will be learn to configure URL rules to make a pretty URL, essential for search engine optimization. Next, you will walk through Model and ActiveRecord, key concepts in database interaction. The second application you will develop is a reservation system that allows you to manage rooms, customers, and reservations. For this, you will use database connection through SQL and ActiveRecord. More complex than the first one, this application will introduce you to the advanced template of Yii 2, splitting the app into two parts: a frontend for all visitors and a backend for the admin. Finally, you will move on to the last two applications: one that allows connections from remote clients, through RESTful components of Yii 2, and another that creates and organizes automatic tasks using the console application structure of Yii 2.

Related Content you might be interested in

Current Title:

Small book image
Yii2 By Example
Fabrizio Caldarelli
Sep, 2015 | 344 pages
No titles found
Table of Contents (20 chapters)
Yii2 By Example
Yii2 By Example
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Starting with Yii2
Starting with Yii2
Requirements and tools
Installing Yii2 with Composer
Application structure
Application properties
Naming convention
Summary
2
Creating a Simple News Reader
Creating a Simple News Reader
Creating Controller and Action
Creating a view to display a news list
How the controller sends data to view
Splitting the common view content into reusable views
Creating static pages
Sharing data between views and layout
Layout with dynamic block
Using multiple layouts
Summary
3
Making Pretty URLs
Making Pretty URLs
Using pretty URLs
Custom URL rules
Default parameters in rules
The complete URL rule parameters
The URL pattern to support the multilanguage view
Creating the rule class
Summary
4
Creating a Room through Forms
Creating a Room through Forms
Creating a Model
Using ActiveForm
Format date, time, and numbers
Uploading files
Summary
5
Developing a Reservation System
Developing a Reservation System
Configuring a DB connection
Using Gii to create room, customer, and reservation models
Using ActiveRecord to manipulate data
Working with relationships
How to save a model from a form
Setting up the GMT time zone
Using multiple database connections
Summary
6
Using a Grid for Data and Relations
Using a Grid for Data and Relations
Introduction
DataProvider for grids
Using a grid
Custom columns in a grid
Filters in GridView
Displaying and filtering ActiveRecord relational data in a grid's column
A summarized footer row in a grid
Multiple grids on one page
Summary
7
Working on the User Interface
Working on the User Interface
Using Gii to generate CRUD
Customize JavaScript and CSS
Using AJAX
Using the Bootstrap widget
Multiple models in the same view
Saving linked models in the same view
Summary
8
Log in to the App
Log in to the App
Creating a user login
Configuring user authorization
Mixing ACF and RBAC
Summary
9
Frontend to Display Rooms to Everyone
Frontend to Display Rooms to Everyone
Using an advanced template to split frontend and backend
Configuring an application using init
Sharing ActiveRecord models among applications
Customizing a URL in the advanced template
How to use the advanced template in the shared hosting
Summary
10
Localize the App
Localize the App
Setting the default language
File-based translations
Placeholders formatting
DB-based translations
Summary
11
Creating an API for Use in a Mobile App
Creating an API for Use in a Mobile App
Configuring a REST app in the advanced template
Creating a controller
Authentication
New controller action
Customizing authentication and response
Other forms of export – RSS
Summary
12
Create a Console Application to Automate the Periodic Task
Create a Console Application to Automate the Periodic Task
Interacting with console applications
Creating a console controller
Formatting the output from the console
Implementing and executing cron jobs
Summary
13
Final Refactoring
Final Refactoring
Creating widgets
Creating components
Creating modules
Generating an API documentation
Summary
Index
Index

Configuring a DB connection

Yii2 offers a high-level layer to access databases, built on top of PHP Data Objects (PDO).

This framework allows us to manipulate a database table's content through the use of ActiveRecord objects. This encapsulates methods to access single or multiple records, as well as filtering, joining, and ordering data in an intuitive way.

Again, we can work with databases using plain SQL, but this means that we must handle dissimilarities in SQL languages passing through different databases (MySQL, SQL Server, Postgres, Oracle, and so on), which means losing Yii2 facilities.

A database object connection is an instance of yii\db\Connection:

$db = new yii\db\Connection([
    'dsn' => 'mysql:host=localhost;dbname=my_database',
    'username' => 'my_username',
    'password' => 'my_password',
    'charset' => 'utf8',
]);

In this example, we have a connection to a MySQL Server with a mysql connection string to the database my_databases, setting my_username as username...

Previous Section
End of Section 2
Next Section