MySQL

Categories and Attributes in Magento: Part 1

by William Rice | April 2009 | Beginner's Guides MySQL e-Commerce Open Source PHP

In this article by William Rice, we will learn about Categories, Products, and Attributes in Magento.

The combination of products, presentation, and service makes our store unique. In this part, we will see how to add products to our store. Before adding products, we need to make some decisions about how we will organize our site. A few minutes of planning now can save us hours of work later.

Read Categories and Attributes in Magento: Part 1 in full

Adding Newsletters to a Web Site Using Drupal 6

by Mark Noble | December 2008 | MySQL PHP Web Development

In this article by Mark Noble, we will introduce our imaginary client, the Good Eatin' Bistro, and discuss their plans to build a newsletter for their web site. We will add some new features which will allow Chef Wanyama, who is the owner of the Good Eatin' Bistro, a popular upscale restaurant, to keep his customers informed of current events at Good Eatin' restaurant. We will provide a new means of communication. The feature which is covered in this article is a quarterly newsletter that customers can subscribe to. The newsletter will contain valuable information from Chef Wanyama including coupons, news, recipes, and more.

Read Adding Newsletters to a Web Site Using Drupal 6 in full

Joomla! Installation on a Virtual Server on the Net

by Hagen Graf | July 2008 | Joomla! MySQL Content Management Open Source PHP

The installation of Joomla! is a matter of five minutes. If you have installed it before, you can do it in two minutes. In order to be able to even start the installation, your development environment must include a web server that supports PHP and a database that is supported by Joomla!. Joomla! is one piece of the puzzle in this so-called Client-Server System. This topic is very complex, since there is an unmanageable number of providers and an even more unmanageable combination of installed Apache, PHP, and MySQL versions and Webspace administration tools such as Visas and Plesk.

In this article by Hagen Graf, we focus on the following points:

  • A PHP safe mode, possibly activated in the php.ini
  • Prohibited conversion of URLs with Apache because of the non-activation of the so called rewrite engine
  • Directory rights in Linux that are set differently than in Windows
Read Joomla! Installation on a Virtual Server on the Net in full

ASP.NET Social Networks—Making Friends (Part 2)

by Andrew Siemer | December 2008 | .NET MySQL PHP

In the first part of this article we concentrated on two aspects Problem and Design. We started with the Problem, that is, defining what we need to implement the Friends concept, finding and inviting friends to join our network and developing an alert system. We then moved to Design wherein we actually finalized the requirements. And finally we began with the Solution, that is, actually implementing the features. In this part of the article by Andrew Siemer, we will continue with the solution part.

Read ASP.NET Social Networks—Making Friends (Part 2) in full

PHP Data Objects: Error Handling

by Dennis Popel | July 2008 | MySQL Open Source PHP

Most web applications have rather simple error handling strategy. When an error occurs, the script terminates and an error page is presented. The error should be logged in the error log, and the developers or maintainers should check the logs periodically. In this article by Dennis Popel, we will look through the most common sources of errors in database-driven web applications.

  • Server software failure or overload such as the famous "too many connections" error
  • Inappropriate configuration of the application, which may happen when we use an incorrect connection string, a rather common mistake when an application is moved from one host to another.
Read PHP Data Objects: Error Handling in full

Backing Up and Restoring TYPO3 Websites

by Michael Peacock | July 2008 | MySQL Content Management Open Source PHP

All web applications and web servers have security vulnerabilities and there is every chance that our website will be compromised. Most web hosts have their own backup procedures in place, but it is not uncommon for a web host to become victim to an attack, and have problems with a small percentage of its customer backups. Because of this it is very important that we keep backups of our website. In this article by Michael Peacock, we will see how to backup our website and restore it back gain from our backup.

Read Backing Up and Restoring TYPO3 Websites in full

Using An Object Oriented Approach for Implementing PHP Classes to Interact with Oracle

by Yuli Vasiliev | November 2007 | AJAX BPEL MySQL SOA Web Services Content Management Open Source Oracle PHP Web Development

This article by Yuli Vasiliev examines the object-oriented approach for developing PHP/Oracle applications, as an efficient means to reduce the development time and complexity, and increase the maintainability and flexibility of your applications.

In the following sections, you will learn how to create a simple PHP class to interact with Oracle and then how that class can be modified and reused in different scripts.

Read Using An Object Oriented Approach for Implementing PHP Classes to Interact with Oracle in full

Themes in e107

by Theodore S Boomer | July 2008 | MySQL Content Management Open Source PHP

The look and feel of any website is a major factor that drives traffic towards the site. A theme is responsible to give a consistent look and feel to a website. In this article by Theodore S Boomer, we will see how to select and delete themes for e107 websites. We will also have a look at the theme layout and build an understanding of it.

Read Themes in e107 in full

Using Lists and Tables with MediaWiki

by Mizanur Rahman | July 2008 | MySQL Open Source PHP

MediaWiki is a special software which is used to design Wikis. For any website, formatting is the key to creative and sophisticated designs. In this article by Mizanur Rahman, we will use advanced formatting components like lists and tables in MediaWiki to add content to a sample website.

Read Using Lists and Tables with MediaWiki in full

Developing the Joomla! Component and Understanding its Structure

by Joseph L. LeBlanc | November 2007 | Joomla! MySQL Content Management Open Source PHP

In this article by Joseph L. LeBlanc, you will learn about the architecture, design, and requirements of a general Joomla! component. You will also see how the component gets executed and is registered with the database. At the end, you will learn to create toolbars.

Read Developing the Joomla! Component and Understanding its Structure 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