The Search pages in the Database or Table view are intended for single-table lookups. This article by Marc Delisle, covers the multi-table Query by example (QBE) feature available in the Database view.
Many phpMyAdmin users work in the Table view, table-by-table, and thus tend to overlook the multi-table query generator, which is a wonderful feature for fine-tuning queries. The query generator is useful not only in multi-table situations but also for a single table. It enables us to specify multiple criteria for a column, a feature that the Search page in the Table view does not possess.Read The Multi-Table Query Generator using phpMyAdmin and MySQL in full
In this article by Marc Delisle, we present mechanisms that can be used to find the data we are looking for instead of just browsing tables page-by-page and sorting them. This article covers single-table and whole database searches.Read Searching Data using phpMyAdmin and MySQL in full
It is likely that at some stage, you will want to upgrade at least some content from plain text to something that looks a little out of the ordinary. In this article by David Mercer, we will have a look at the CCK module provided by Drupal which is used to build custom content types that can be tailored to suit your needs. In effect, it gives you control over which fields are presented to a user whenever they post content using custom content types. The term field refers to a given piece of content within a node. Conversely, a node is a collection of fields.
In addition to the basic field types provided by the CCK module, you should also keep an eye out for contribs that extend CCK functionality to provide a huge range of useful field enhancements. Everything from Brazilian ID numbers to validated email fields, voting widgets and Amazon ASINS have been made available in the past.Read Drupal 6 Content Construction Kit (CCK) in full
In this article by Vladimir Prelovac, we are going to dig deeper into the WordPress engine and discover ways to modify various aspects of the backend to match our specific needs with the help of the Post Types plugin.
Although WordPress is made primarily for the purpose of handling a blog, this basic functionality can be easily expanded to handle almost anything you want. The WordPress backend is very flexible, and can be customized to accommodate a lot of different purposes. For example, you could create a job portal or an e-commerce quite easily with WordPress, and those are just some of the possibilities.
Specifically, you will learn how to:
- Implement localization support for users of other languages
- Customize menus and submenus to change the way the WordPress backend looks
- Handle file and image uploads
- Use custom fields to add custom hidden information to your posts
In this article by David Mercer, we will see how Taxonomy makes Drupal's classification system so powerful. The method of categorizing content in Drupal makes it one of the most sophisticated content management systems around. Take the time to master working with taxonomy in Drupal, because not only will this help you to work out how to manage content better, but it will also really set your site apart from others because of the flexible and intuitive manner in which the content is organized. These attributes allow you to manage a site of pretty much any size imaginable (just in case what you are working on is "the next big thing").Read Taxonomy and Thesauri in Drupal 6 in full