Table and Database Operations in PHP

by Marc Delisle | April 2008 | MySQL PHP

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

Fundamentals of XHTML MP in Mobile Web Development

by Nirav Mehta | April 2008 | MySQL Open Source PHP

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

Business Blogging On The Up - Technorati State of the Blogosphere 2008

by Paul Thewlis | October 2008 | MySQL Content Management Open Source PHP WordPress

"Technorati recently published its annual report, State of the Blogosphere 2008. As usual, it makes interesting reading, especially for those of us interested in business blogging.

The report shows that Technorati has indexed 133 million blogs since 2002. 1.5 million blogs have been updated in the last 7 days and 7.4 million in the last 120 days. These figures support my argument in the first chapter of my book, WordPress For Business Bloggers, that business bloggers should not be put off by the total number of blogs out there because, in fact, only a small proportion are active."

Read Business Blogging On The Up - Technorati State of the Blogosphere 2008 in full

Users, Profiles, and Connections in Elgg

by Mayank Sharma | April 2008 | MySQL Open Source PHP

Ever been to a night club on a Monday morning? There's you, there are chairs, and the potential to host a party on the weekend. There are lots of buttons, lots of potential, but no one there except you. Unlike a night club, you don't have to wait for the weekend to host your friends on Elgg. Invite them as soon as you're done setting up the software. Elgg is designed to make it easier for you to invite people. If you've ever setup a blog or rolled out your own website, how long did it take before you could invite your friends over? You had to put up all sorts of content to indulge them, and also fiddle around decorating the portal so that it doesn't look dull.

That's where a social network is different from a regular website. Websites follow a two-way, one-to-many style of interaction, where the owner of the website, or blog, talks to all his visitors who respond with their comments, either on the website, or via e-mail. In this article by Mayank Sharma, we discuss about social networking software that follows a many-to-many style of interaction. Members interact with each other, and create their own content, which is then shared with all. This is then discussed and commented on by everyone. The owner of the site is like the perfect host. They mingle, discuss with everyone, but don't stamp their authority, unless you're naughty. They're like every other member, except for the fact that they own the place. Sounds familiar? So, you don't have to worry about content before inviting your friends. Your friends bring their own content.

Read Users, Profiles, and Connections in Elgg in full

Interacting with Databases through the Java Persistence API

by Suhreed Sarkar | November 2008 | Joomla! MySQL Content Management Open Source PHP

The Java Persistence API (JPA) is an object relational mapping API. Object relational mapping tools help us automate mapping Java objects to relational database tables. Earlier versions of J2EE used Entity Beans as the standard approach for object relational mapping. Entity Beans attempted to keep the data in memory always synchronized with database data, a good idea in theory, however, in practice this feature resulted in poorly performing applications.

Several object relational mapping APIs were developed to overcome the limitations of Entity Beans, such as Hibernate, iBatis, Cayenne, and Toplink among others.

With Java EE 5, Entity Beans were deprecated in favor of JPA. JPA took ideas from several object relational mapping tools and incorporated them into the standard. As we will see in this article by David Heffelfinger, NetBeans has several features that make development with JPA a breeze.

Read Interacting with Databases through the Java Persistence API in full

Comparing Cursor and Set Approaches in Processing Relational Data

by Djoni Darmawikarta | October 2008 | MySQL PHP

MySQL introduced cursor in its release 5. You create a cursor to define a set of rows from one or more table that you want to access row-by-row sequentially. If your need is really to access the rows one at a time then use cursor. But a lot of data processing is actually set processing, and set processing is what relational database is best for.

This article by Djoni Darmawikarta compares cursor approach and set approach using various examples.

Read Comparing Cursor and Set Approaches in Processing Relational Data in full

Cooking XML with OOP

by Hasin Hayder | February 2008 | MySQL Open Source PHP

XML (Extensible Markup Language) is a very important format for storing multi‑purpose data. It is also known as universal data format, as you can represent anything and visualize the data properly with the help of a renderer. One of the biggest advantages of XML is that it can be converted from one form of data into another easily with the help of XSLT. Also, XML data is highly readable.

One of the great blessings of PHP5 is its excellent support to manipulate XML. PHP5 comes bundled with new XML extensions for processing XML easily. You have a whole new SimpleXML API to read XML documents in a pure object-oriented way. Also, you have the DOMDocument object to parse and create XML documents. In this article by Hasin Hayder, we will learn these APIs and learn how to successfully process XML with PHP.

Read Cooking XML with OOP in full

ExpressionEngine: Creating a Photo Gallery

by Leonard Murphy | September 2008 | MySQL Content Management PHP

ExpressionEngine comes with a built-in photo gallery module included as part of the purchase fee. With the prevalence of digital cameras, having a place to upload and share photos on your website is a great feature of ExpressionEngine. In this article by Leonard Murphy we will:

  • Install the photo gallery module
  • Design our photo gallery to fit in with the design of the rest of our site
  • Make it easy to upload new photos, add comments and descriptions, and otherwise create a very functional gallery

On our website, we can have multiple photo galleries independent of each other (the photos are in a different folder; the gallery has a different URL) or we can have one gallery for all our photos, using categories to distinguish groups of related photos.
For the purposes of this article we are going to create only one photo gallery, but if desired the same principles can be followed again to create multiple galleries.
To keep our photo gallery visually interesting, we will be straying just slightly from our toast website theme, and will not be using our photo gallery to display slices of toast.
Let's get started!

Read ExpressionEngine: Creating a Photo Gallery in full

PostgreSQL's Transaction Model

by Jonathan Gardner | September 2008 | MySQL PHP

A database must always be ACID (Atomicity, Consistency, Isolation, and Durability) compliant. Databases comply with ACID requirements through the concept of transactions. In this article by Jonathan Gardner, we will see the differences in the transaction model of PostgreSQL and Oracle. We will look into the details of how PostgreSQL handles transactions and how it can be advantageous over Oracle's Transaction Model.

Read PostgreSQL's Transaction Model in full


by Nirav Mehta | April 2009 | Beginner's Guides MySQL Content Management Open Source PHP

After we understand our requirements and learn the basics of using CMSs, we are will be ready to look at Web Content Management Systems (commonly known as WCMS, Web CMS, or WCM Systems). Web CMSs allow you to manage your web content easily. They are generic in nature and perform a variety of operations. If you ask someone about a CMS, they will most probably recommend you one of the systems we cover in this article. It's important to learn the features of the top web CMSs to make the right choice for your project.

In this article by Nirav Mehta, we will take a look at the top general-purpose Web CMSs. In the process, we will:

  • Cover a variety of top Web CMSs
  • Perform customizations and content management operations
  • Discover interesting features in CMSs
  • Examine which CMS could be right for you
Read Web CMS 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
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