O'Reilly logo

Learning FuelPHP for Effective PHP Development by Ross Tweedie

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required