Creating a View with MySQL Query Browser

MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL Query Browser, you build database queries using just your mouse—click, drag and drop!

When you’re creating a query for non-technical users and you don’t want them to see the complexity of the query, you can create a view from the query. Your users can then use the view as a table; for example, they can double-click the view, which will effectively execute its complex query behind the scene.

In MySQL Query Browser, you have two ways to create a view, which Djoni Darmawikarta will demonstrate in this article:

• From an existing query
• Writing from scratch manually

CodeIgniter and Objects

Objects confused me when I started to use CodeIgniter. I came to CodeIgniter via PHP 4, which is a procedural language, not really an Object-Oriented (OO) language. I duly looked up objects and methods, properties and inheritance, and encapsulation, but my early attempts to write CI code were plagued by the error message "Call to a member function on a non-object". I saw it so often that I was thinking of having it printed on a t-shirt: it has a mysteriously libertarian, anarchist tone, and I could see myself wearing it at a modern art exhibition.

This is the geek article. It describes the way CodeIgniter actually works, 'under the hood'. If you are new to CI, you may want to skip it. However, sooner or later, you may want to understand why things happen in certain ways—as opposed to just knowing that they do.

Resource-Oriented Clients with REST Principles

Resource-Oriented clients are client programs that consume services designed in accordance with the REST architectural principles. The key REST principles include:

• The concept of resource (for example, a document is a resource)
• Every resource given a unique ID (for example, document URL)
• Resources can be related (for example, One document linking to another)
• Use of standard (HTTP, HTML, XML)
• Resources can have multiple forms (for example, status of a document, updated, validated, deleted)
• Communicate in a stateless fashion using HTTP (for example, subsequent requests not related to each other)

In this article by Samisa Abeysinghe, we will study how we can implement clients to consume those services. We will use a real-world example, the simplified library system, to learn from scratch how to design clients with REST principles in mind.

Categories and Attributes in Magento: Part 1

In this article by William Rice, we will learn about Categories, Products, and Attributes in Magento.

The combination of products, presentation, and service makes our store unique. In this part, we will see how to add products to our store. Before adding products, we need to make some decisions about how we will organize our site. A few minutes of planning now can save us hours of work later.