Book Image

Learning FuelPHP for Effective PHP Development

By : Ross Tweedie
Book Image

Learning FuelPHP for Effective PHP Development

By: Ross Tweedie

Overview of this book

<p>PHP frameworks have been around for a number of years. FuelPHP was one of the first frameworks built for PHP 5.3. It makes use of more advanced features of the language to allow you to focus on delivering features and code for your projects. FuelPHP allows you to quickly build prototypes using scaffolding and command-line tools, thus allowing you to concentrate on the fun part of trialling ideas and concepts.</p> <p>This practical guide will show you how to use FuelPHP to quickly create projects more quickly and effectively. You will learn everything you need to know when creating projects with FuelPHP, including how to adapt the project as ideas change and develop.</p> <p>This guide is packed with several tutorials that will help you to build a powerful and engaging application, and in the process you will learn more about FuelPHP. This book explores how to install and build a FuelPHP project in a step- by- step approach.</p> <p>Starting with an exploration of the features of FuelPHP, this book then delves into the creation of a simple application. You will then move on to scaffolding your application using the powerful FuelPHP Oil command-line tool. Next, you will be introduced to packages and modules, and also cover routing, which allows for cleaner URL structures.</p> <p>The book concludes with an introduction to the PHP community.</p>
Table of Contents (14 chapters)

Creating a database table


Before creating the tables in the database, let's first detail what data will be stored and which initial fields will be there in the tables.

For blogging, we will have blog posts or entries and these will have a published date. They will be categorized to enable grouping of similar themes. Each post will be associated with an author (user) and will have content and an excerpt. We can add free-form tagging later.

Entries

The following fields exist in the Entries table:

  • id (int): This will be the primary identifier

  • name (varchar)

  • slug (varchar)

  • excerpt (text)

  • content (text)

  • published_at (int)

  • created_at (timestamp): This will be a timestamp of when the record was created

  • updated_at (timestamp) - This will be a timestamp of when the record was last updated

Categories

The following fields exist in the Categories table:

  • id (int): This will be the primary indentifier

  • name (varchar)

  • slug (varchar)

  • created_at (timestamp): This will be a timestamp of when the record was created

  • updated_at...