If you're visiting a web page like a blog or news portal which frequently updates its content then you're most likely to see a link for subscribing RSS feed or articles or news. The main purpose of an RSS feed is to provide the latest updates of articles, posts, news headlines, or audio and video, in a standard format—without the need to visit that website. These RSS feeds are stored in specified URLs and can be read using software which are commonly called RSS Readers, Feed Readers or Feed Aggregators. These can be web based applications or desktop based.
In this article by Roshan Bhattarai, we'll see how to create a web widget which displays the links from the RSS feed of a specific URL. By the end of this article, you'll see how we can use Iframe to build a web widget.Read RSS Web Widget in full
Postgres is the well known and most used Open Source OLTP database available today. EnterpriseDB sits atop Postgres and leverages it to provide enterprise capabilities to Postgres users. EnterpriseDB is available for Windows platform as well. It has most of the necessary features of an enterprise class such as advanced development, monitoring, migration and administrative tools with a stable environment. It also has plug-in capabilities for Oracle. In the present form EnterpriseDB claims cost effectiveness versus Oracle and better scalability than MySQL. It can easily integrate with most applications such as Java, Ajax, Ruby, Drupal etc. This article by Dr. Jayaram Krishnaswamy mainly describes the installation of EnterpriseDB and the basic features to get started on this important database product.Read Installation and basic features of EnterpriseDB in full
In Part 1 we had a look at running multiple templates, and at creating dynamic elements and styles. In this article by Ric Shreves, we will discuss about Creating Dynamic CSS Styling and Working with Template Variables.Read Dynamic Theming in Drupal 6 - Part 2 in full
The Drupal system, when combined with the PHPTemplate engine, gives you the ability to create logic that will automatically display templates or specific elements in response to the existence of certain conditions. In this two part article by Ric Shreves, we will look at running multiple templates, and at creating dynamic elements and styles. Among the techniques covered in these articles ( Part 1 and Part 2 ) are: using suggestions—naming conventions—to control template display, the use of $body_classes to create dynamic styling, and the implementation of the preprocessor function.Read Dynamic Theming in Drupal 6 - Part 1 in full
If you were tasked with finding the letter that when spoken out loud repeatedly was more awkward than any other, you would come up with the W. Every other letter in the English alphabet is pronounced with a single syllable, yet the W is unique in requiring an impressive three syllables to utter.
This campaign is to encourage people to forget that WWW ever existed. Don’t type it, don’t speak it, and complain to every website that still requires it.Read Making the World Wide Web an Easier Place to Talk About in full
Database relationship is hard to maintain even for a mid-sized PHP/MySQL application, particularly, when multiple levels of relationships are involved because complicated SQL queries are needed. CakePHP offers a simple yet powerful feature called 'object relational mapping' or ORM to handle database relationships with ease.In CakePHP, relations between the database tables are defined through association—a way to represent the database table relationship inside CakePHP. Once the associations are defined in models according to the table relationships, we are ready to use its wonderful functionalities. Using CakePHP's ORM, we can save, retrieve, and delete related data into and from different database tables with simplicity, in a better way—no need to write complex SQL queries with multiple JOINs anymore!
In this article by Ahsanul Bari and Anupom Syam, we will have a deep look at various types of associations and their uses. In particular, the purpose of this article is to learn:
- How to figure out association types from database table relations
- How to define different types of associations in CakePHP models
- How to utilize the association for fetching related model data
- How to relate associated data while saving
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!
MySQL Query Browser has plenty of visual query building functions and features. This article Djoni Darmawikarta shows two examples, building Join and Master-detail queries. These examples will demonstrate some of these functions and features.Read Building Queries Visually in MySQL Query Browser in full
In this article by Dmitry Dulepov, we will discuss why planning an extension is important and how to plan an extension. Planning issues related to web development are covered in depth in many specialized books. Here, we will cover planning only with regard to TYPO3 extensions.Read Planning Extensions in TYPO3 in full
In this article by Marc Delisle, we will learn how to perform some operations that influence tables or databases as a whole. We will cover table attributes and how to modify them, and also discuss multi-table operations.Read Table and Database Operations in PHP in full
XHTML Mobile Profile (XHTML MP) is the standard language for mobile web development. XHTML MP is an XHTML variant. It offers richer presentation and is very similar to HTML. XHTML MP is built on top of XHTML Basic. In this article by Nirav Mehta, we will have a look at the fundamentals of XHTML MP and the grammar which must be followed for development in it.Read Fundamentals of XHTML MP in Mobile Web Development in full