MySQL

Keeping Extensions Secure with Joomla! 1.5: Part 1

by James Kennard | September 2009 | Cookbooks Joomla! MySQL Content Management Open Source PHP

This article demonstrates how we can secure extensions and explains some of the ramifications if we fail to do this.

This two-part article by James Kennard contains the following recipes:

  • Writing SQL safe queries
  • Writing SQL-safe LIKE string comparison queries
  • Using the token
  • Making a filename safe
  • Making a directory path safe
  • Making a path safe
  • Safely retrieving request data
  • Getting a value from an array
Read Keeping Extensions Secure with Joomla! 1.5: Part 1 in full

Create a Quick Application in CakePHP: Part 1

by Ahsanul Bari Anupom Syam | September 2009 | MySQL Open Source PHP

In this article by Ahsanul Bari and Anupom Syam, we will learn some of the important aspects of CakePHP. We will learn how we can create an application that we call the CakeTooDoo. It can manage to-do lists, list all the tasks, add tasks, edit tasks, and delete tasks.

This article will show how we can create a database that follows the Cake convention, and how to configure Cake to use it. It will also discuss how to create models, controllers, views, and the conventions that we need to follow to make them work together.

We will discuss a few important model functions like find(), create(), save(), del() and the use of controller functions like set() and redirect(). The HTML Form and the Time Helper will also be introduced, and we will see how the functions of these helpers can make it easier to display views.

Read Create a Quick Application in CakePHP: Part 1 in full

The Session and the User with Joomla! 1.5: Part 1

by James Kennard | October 2009 | Cookbooks Joomla! MySQL Content Management Open Source PHP

This article by James Kennard shows how we can interact with the current user, logged in or not, and how we can interact with their session.

This article contains the following recipes:

  • Getting the session handler
  • Adding data to the session
  • Getting session data
  • Checking for session data
  • Checking the session token
  • Getting the user
  • Determining if the current user is a guest
  • Getting the user's name and username
  • Getting the user's group ID and type
  • Restricting a user's access using Public, Registered, and Special
  • Getting the user's parameters
  • Setting the user's parameters
  • Extending and editing user parameters
  • Sending an email to the user
Read The Session and the User with Joomla! 1.5: Part 1 in full

Developing an Application in Symfony 1.3 (Part 1)

by Tim Bowler | September 2009 | MySQL Open Source PHP Web Development

Developing an application in Symfony is easy and time-saving, and one of the best ways to demonstrate that is to create a web site. By the end of this article by Tim Bowler, we will have an initial prototype, which will serve as a starting point. Along the way you will be introduced to the MVC flow within Symfony where you will understand about the business and application logic, and designing the database.

In this article you will learn how to:

  • Set up the foundations for a basic database-driven web site using the Symfony framework
  • Use some of the available Symfony tasks to cut out repetition
  • Create a database schema and later understand its relation to the ORM and forms
  • Understand the flow of the request to the controller, action, routing, and template rendering
Read Developing an Application in Symfony 1.3 (Part 1) in full

Keyword Research for Search Engine Optimization in Drupal 6

by Ben Finklea | September 2009 | MySQL Content Management Drupal Open Source PHP

In this article by Ben Finklea, we are going to explore:

  • What is a keyword and why it matters
  • Why keyword research is perhaps the most important thing you will do in an SEO campaign
  • Setting goals for your keywords
  • How to use your site to find great keywords including installing and configuring the Top Searches module
  • Several external keyword research tools to speed up the process of finding the best terms
  • A walk-through of the keyword research process
Read Keyword Research for Search Engine Optimization in Drupal 6 in full

Search Engine Optimization using Sitemaps in Drupal 6

by Ben Finklea | September 2009 | MySQL Content Management Drupal Open Source PHP

In this article by Ben Finklea, we will discuss Sitemaps in detail, right from the origin of sitemaps to how they are used to make sure our entire site is crawled by the search engines. We will cover:

  • What sitemaps are and why you should use them
  • How to install sitemaps on your Drupal site
  • How to submit the XML sitemaps to Google
Read Search Engine Optimization using Sitemaps in Drupal 6 in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
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