MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
MySQL Workbench has many functions and features; this article by Djoni Darmawikarta shows some of them by way of an example. We’ll build a physical data model for an order system where an order can be a sale order or a purchase order, and then, forward-engineer our model into an MySQL database.Read Visual MySQL Database Design in MySQL Workbench in full
Before you begin with coding, there are a few files and folders that have to be created, as well as a query that has to be run. This will not only allow you to build Joomla! components, but will also help you try different features without extensive configuration. The component in this article will be called restaurants.
After installing your basic Joomla! component and making the website ready, there are a few additional features that you can include. One of them came up with the idea of allowing visitors to send reviews to their friends through email. Another could be adding audio reviews in addition to text. We can also begin to look into ways of expanding the market for the software. Internationalizing the component now will make it easy to translate the user interface later.
In the following article by Joseph L. LeBlanc, we will be taking a look at including the following additional features :
- Sending emails
- Managing languages
- Creating translations
- Handling file uploads
AJAX—it's the buzzword that hit the Web with a bullet in 2005, thanks to Jesse James Garrett, a user-experience expert who founded AdaptivePath.com. If you're totally new to AJAX, I'll just point out that; at its core, AJAX is nothing that scary or horrendous. AJAX isn't even a new technology or language!
In this article by Richard Carter, we will learn social bookmarking.
Social bookmarking allows people to "bookmark", or make a note of, the websites they like or find useful, and share these bookmarks with other social bookmarkers while surfing the Internet.Read Social Bookmarking - MediaWiki in full
Plugins are an essential, but rarely noticed part of a successful Joomla!-based business. Plugins are very flexible and can execute for various purposes at many different times. Part of this article by Daniel Chapman will be to look at these purposes and times, and understand how they can affect our web site by going through the following topics:
- plugin composition and operation
- plugin types
- plugin events
- plugin ordering
- plugin customization
We will also make some changes to an existing plugin so that it better meets our needs.Read Customizing Plugins in Joomla! 1.5x (Part 1) in full
In this article by Dr. Mark Alexander Bain, we will be dealing with building a Facebook application. However, before we jump into building a Facebook application, we need to spend some time looking at the Facebook platform, and by the end of this article you will:
- Understand what the Facebook Platform is, and how it relates to your application
- Know about the elements that make up the Facebook Platform, and how to test them without having to create an application
- Know how to set up the Facebook Platform, ready for your new application
The Philosophy Quotes module that we will create in this article will use Drupal's theme system and a simple database query to theme the content of a custom content type.
Here are some of the items we will cover in this article by Matt Butcher while working on this module:
- Creating a custom content type
- Performing simple database operations
- Registering a module's theme functions with the hook_theme() function
- Adding theme hooks to a module
- Adding CSS stylesheets to a module's default theme
- Using theme CSS and template files to override default module theme functions
You can find both design ideas and complete themes on the Web. You need to decide whether you want to work with an existing theme, or convert a design into a theme, or whether you want to start from scratch, unburdened by any preliminary constraints or alien code.
This article by Ric Shreves assumes you have a working Drupal installation, and that you have access to the files on your server and deals with finding, installing, and then uninstalling an existing and current Drupal theme.Read Installing Drupal Themes in full
Article marketing means that you will write articles about your field of interest and distribute them for publication on other websites, blogs, and ezines with a link back to your site. Each time your article is published on a website you get a one-way link to your site.
By publishing articles in your own online store, you not only get better indexed by search engines, but what's more important provide useful information to your customers who may be seeking for it.
In this article by Vadym Gurevych, we will see how to use the articles for the purpose of marketing and improve the sales.
Read Article Marketing on CMS, Blogs, and Online Magazines to Improve Sales in full