PHP

In-place Editing using PHP and Script.aculo.us

by Sridhar Rao | April 2009 | AJAX MySQL PHP Web Development

In this article by Sridhar Rao, we will learn about editing the content in the page without moving, dragging, or dropping it. This feature is called in-place editing. The key topics that we are going to explore in this article are:

  • Introduction to in-place editing
  • In-place editing: Definition and attributes
  • Code usage in examples
  • Tips and tricks involving in-place editing
  • Hands-on example: Handling at the server-side
  • Hands-on with InPlaceCollectionEditor
Read In-place Editing using PHP and Script.aculo.us in full

Creating and Managing User Groups in Joomla! and VirtueMart

by Suhreed Sarkar | April 2009 | Joomla! MySQL Content Management e-Commerce Open Source PHP

In the previous article you have seen how to allow customer registrations to your VirtueMart shop, how to manage the registered users, how to define extra fields for customer registration and account maintenance forms. In this article by Suhreed Sarkar, we learn how to create and manage user groups and assign permissions to user groups. You will also see how to create permission modules and functions that are used for implementing a permission system for special groups.

Read Creating and Managing User Groups in Joomla! and VirtueMart in full

RSS Web Widget

by Roshan Bhattarai | April 2009 | AJAX MySQL PHP Web Development

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

Installation and basic features of EnterpriseDB

by Jayaram Krishnaswamy | January 2009 | MySQL PHP

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

Dynamic Theming in Drupal 6 - Part 2

by Ric Shreves | December 2008 | MySQL Content Management Drupal Open Source PHP

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

Dynamic Theming in Drupal 6 - Part 1

by Ric Shreves | December 2008 | MySQL Content Management Drupal Open Source PHP

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

Making the World Wide Web an Easier Place to Talk About

by Tim Walton | May 2008 | Beginner's Guides MySQL Content Management Open Source PHP

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

Working with Simple Associations using CakePHP

by Ahsanul Bari Anupom Syam | December 2008 | MySQL Open Source PHP

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
Read Working with Simple Associations using CakePHP in full

Building Queries Visually in MySQL Query Browser

by Djoni Darmawikarta | April 2008 | MySQL PHP

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

Planning Extensions in TYPO3

by Dmitry Dulepov | November 2008 | MySQL Content Management Open Source PHP

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
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software