Book Image

Mastering ExtJS - Second Edition - Second Edition

By : Loiane Avancini
Book Image

Mastering ExtJS - Second Edition - Second Edition

By: Loiane Avancini

Overview of this book

If you are a developer who is familiar with Ext JS and want to augment your skills to create even better web applications, this is the book for you. Basic knowledge of JavaScript/HTML/CSS and any server-side language (PHP, Java, C#, Ruby, or Python) is required.
Table of Contents (19 chapters)
Mastering Ext JS Second Edition
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Presenting the tables


If we open and analyze the Entity Relationship (ER) diagram that comes with the Sakila installation, we will notice the following tables:

Note

As a reminder, the Sakila database can be downloaded at http://dev.mysql.com/doc/index-other.html, and its documentation with installation instructions can be found at http://dev.mysql.com/doc/sakila/en/.

These tables can exist independently of the other tables, and we are going to work with them in this chapter.

When we open SQL editor in MySQL Workbench (version 6 ) (http://dev.mysql.com/downloads/workbench/), we can select a table, right-click on it, and select Select Rows – Limit 1000. When we choose this option, a new tab will be opened, and it looks as follows:

The table shown previously is the actor table. The idea is to implement screens that look similar to the preceding screenshot for each of the tables that we selected: Actors, Categories, Languages, Cities, and Countries as displayed in the following screenshot (which...