Book Image

Learning Phalcon PHP

Book Image

Learning Phalcon PHP

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Learning Phalcon PHP
Aug, 2015 | 328 pages
No titles found
Table of Contents (17 chapters)
Learning Phalcon PHP
Learning Phalcon PHP
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
Getting Started with Phalcon
Getting Started with Phalcon
Installing the required software
Installing Phalcon
The Apache and Nginx configuration files
Understanding the framework's internals
Summary
2
Setting Up the MVC Structure and the Environment for Our Project
Setting Up the MVC Structure and the Environment for Our Project
What is MVC?
The MVC structure
Creating the structure for our project
Creating the configuration file and the Bootstrap
Preparing the initial DI interface and the router
Using the router component in a module
Create the base layout
Summary
3
Learning Phalcon's ORM and ODM
Learning Phalcon's ORM and ODM
The main differences between SQL and NoSQL databases
Connecting to the database
ORM/ODM operations (create, update, delete, transactions, and validations)
CRUD operations using ORM
Using PHQL
Using raw SQL
Database transactions
ODM/MongoDB
ORM – drawbacks and caching
Summary
4
Database Architecture, Models, and CLI Applications
Database Architecture, Models, and CLI Applications
The database architecture
Models
Summary
5
The API Module
The API Module
Using APIs – recommended practices
Enabling SSL on our local machine
Creating the module structure
Writing a fully functional REST module with Phalcon PHP
Securing an API
Documenting the API
Summary
6
Assets, Authentication, and ACL
Assets, Authentication, and ACL
Assets management
Developing an authentication system
Securing the application using the ACL component
Summary
7
The Backoffice Module (Part 1)
The Backoffice Module (Part 1)
Editing the main layout
Cleaning the Core module
Hashtag CRUD
Category CRUD
Summary
8
The Backoffice Module (Part 2)
The Backoffice Module (Part 2)
User CRUD
User templates
Article CRUD
Summary
9
The Frontend Module
The Frontend Module
The Frontend layout and basic functionality
Modifying BaseController.php
Implementing ElasticSearch
Implementing MongoDB
Summary
10
Going Further
Going Further
Uploading files with Phalcon
Using the Annotation router
Summary
Index
Index

The database architecture

The main goal of this book is to learn by example and we are achieving this by developing an online news/magazine website. We will assume the following tables as mandatory:

  • User

  • UserGroup

  • UserProfile

  • Article

  • ArticleCategory

  • ArticleTranslation

  • ArticleCategoryArticle

  • Hashtag

  • ArticleHashtagArticle

These are basic tables, and we will add a few more in the later chapters. I like to use singular terms as part of the naming convention, but it's a matter of choice. To work faster, I recommend tools such as PhpMyAdmin or MySQL Workbench. Let's start with the first table.

The User table

The User table will hold basic information about a user:

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_first_name` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `user_last_name` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `user_email` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `user_password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `user_group_id...
Previous Section
End of Section 2
Next Section