O'Reilly logo

PHP 5 Social Networking by Michael Peacock

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

Chapter 8. Statuses—Other Media

With our status stream now supporting simple-text updates from the profile owner, and public messages from other users, it is time for us to integrate other types of media into these statuses.

In this chapter, you will learn how to integrate other types of media in profile posts, including:

  • Images
  • Videos
  • Links

The core information to our current statuses is held within the statuses table. We will keep this the same. However, depending on the type of status update, we may call upon other database tables to extend the information available to us.

Since different status types will use different status tables, we should use a left join to connect the tables, so we can keep just a single query to look up the statuses. It also ...

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