Joomla! is currently designed to use the MySQL database. However, the architecture does allow for the implementation of other database drivers. There is some uncertainty surrounding the issue of supporting other databases, because of the usage of functions and syntax, in queries, which is specific to MySQL.
This article by James Kennard takes a look at the role of the database in Joomla!. It defines some standard rules we need to abide by.Read Joomla! and Database in full
The aim of this Photoshop Foundation series is to give both beginners, and more experienced users, all the information they need to use Photoshop as efficiently as possible. This series aims to both, guide you through the more confusing aspects of Photoshop, and show you the very best ways to use this application.
In this first article, we are going to look at the difference between vector and bitmap graphics, which is one of the most important principles to understand when working with graphics on a computer, inside or outside of Photoshop.Read Photoshop Foundation - The Difference between Vector and Bitmap Graphics in full
Twitter helps to keep in touch with friends despite the distance and profession. For some friends you might require instant mobile updates while for others, you can just check your email. YouTube is a service providing website wherein we can upload, view and share various video clips. In this article by Richard Carter, we will learn to integrate Twitter and YouTube with MediaWiki.Read Integrating Twitter and YouTube with MediaWiki in full
In this article by Nirav Mehta,we will learn about Adapting and progressively enhancing POTR application using Wireless Abstraction Library and Evaluating tools that aid in adaption.Read Adapting to User Devices Using Mobile Web Technology in full
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
In the previous part of the article, we saw how to Create Categories and Add products to our store. In this part by William Rice, we will learn how to create Attributes and Attribute Sets in Magento.Read Categories and Attributes in Magento: Part 2 in full
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.Read CodeIgniter and Objects in full
The phrase "Content is King" may seem like rather an old cliché now, but it still rings true—content is king. In this article by Paul Thewlis, we will look at issues surrounding content creation, and discuss some techniques and methods to help you produce the best content you can. We will discuss some general writing tips for bloggers. Although you may be familiar with some of these already, it is to re-focus your attention on them and ensure that you are applying them as a part of your blogging routine.Read Writing Tips for Bloggers in full
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.Read Resource-Oriented Clients with REST Principles in full
Tables got a bad review in accessibility circles, because they used to create complex visual layouts. This was due to the limitations in the support for presentational specifications like CSS and using tables for layout was a hack—that worked in the real world—when you wanted to position something in a precise part of the web page.
Tables were designed to present data of all shapes and sizes, and that is really what they should be used for.
This article by Joshue O Connor, shows how to build a simple table using Joomla! and the features contained within the WYSIWYG editors that can make the table more accessible.Read Creating Accessible Tables in Joomla! in full