PHP

Showing your Google calendar on your Joomla! site using GCalendar

by Suhreed Sarkar | October 2010 | Cookbooks Joomla! Content Management Open Source PHP

For Joomla!, there are many popular extensions to show events and calendars. In the previous article we covered adding an event calendar using JEvents. In this article by Suhreed Sarkar, author of Joomla! 1.5 Top Extensions Cookbook, we will discuss a popular extension: GCalendar. JEvents allows you to add events and show them through a calendar. GCalendar allows you to display the Google Calendar on your Joomla! site.

Google Calendar is gaining popularity. If you are a user of Google Calendar, you already know how flexible it is. In this article, you are going to know how to display your Google calendar on your Joomla! site.

Read Showing your Google calendar on your Joomla! site using GCalendar in full

Adding an Event Calendar to your Joomla! Site using JEvents

by Suhreed Sarkar | October 2010 | Cookbooks Joomla! Content Management Open Source PHP Web Development

Event calendars are essential for many websites. For example, your company website may contain one event calendar to display the events. Showing event information through a calendar helps visitors to view your schedule easier. A good calendar application also helps you to schedule your work. This article by Suhreed Sarkar, author of Joomla! 1.5 Top Extensions Cookbook, shows you how to add an event calendar to your Joomla! site using JEvents.

Read Adding an Event Calendar to your Joomla! Site using JEvents in full

Administrating the MySQL Server with phpMyAdmin

by Marc Delisle | October 2010 | MySQL Open Source PHP

This article, Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, discusses how a system administrator can use the phpMyAdmin server management features for day-to-day user account maintenance, server verification, and server protection. The subject of how non-administrators can obtain server information from phpMyAdmin is also covered. Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.

Server administration is mostly done via the Server view, which is accessed via the menu tabs available on phpMyAdmin's home page.

This article specifically covers:

  • Managing users and their privileges
  • Database information
  • Server information
Read Administrating the MySQL Server with phpMyAdmin in full

Installing phpMyAdmin

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will cover:

  • Installing phpMyAdmin
  • Configuring phpMyAdmin
  • Upgrading phpMyAdmin
Read Installing phpMyAdmin in full

Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, we will learn how to import data that we have exported for backup or transfer purposes. Exported data may also come from authors of other applications, and could contain the whole foundation structure of these application along with some sample data.

The current phpMyAdmin version (3.3) can import:

  • Files containing MySQL statements (usually having a .sql suffx, but not necessarily so)
  • CSV files (comma-separated values, although the separator is not necessaria comma); these files can be imported by phpMyAdmin itself or via the MySQL LOAD DATA INFILE statement, which enables the MySQL Server to handle the data directly rather than having phpMyAdmin parse it frst
  • Open Document Spreadsheet files
  • Excel files (from versions 97 to 2007)
  • XML files (generated by phpMyAdmin)

The binary feld upload can be said to belong to the import family. Future versions might be able to import files in more formats.

Importing and uploading are synonyms in this context.

Read Importing Structure and Data in phpMyAdmin 3.3.x for Effective MySQL Management in full

Performing Table and Database Operations in phpMyAdmin 3.3.x for Effective MySQL Management

by Marc Delisle | October 2010 | MySQL Open Source PHP

In this article, by Marc Delisle, author of Mastering phpMyAdmin 3.3.x for Effective MySQL Management, 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 will also discuss multi-table operations.

This article specifically covers:

  • Maintaining a table
  • Changing table attributes
  • Renaming, moving, and copying tables
  • Multi-table operations
  • Database operations
Read Performing Table and Database Operations in phpMyAdmin 3.3.x for Effective MySQL Management in full

Using Templates to Display Channel Content in ExpressionEngine

by Leonard Murphy | September 2010 | MySQL Content Management PHP

In this two-part article series by Leonard Murphy, author of Building Websites with Expression Engine 2.X, you will take an existing website that was written outside of ExpressionEngine and adapt it to ExpressionEngine. In the first part you created your own channel with fields customized to the content that you will be displaying.

In this article you will be:

  • Using templates to display your channel content
  • Creating a 404 page for visitors who get lost on your site
Read Using Templates to Display Channel Content in ExpressionEngine in full

Creating Channel for Moving a Website to ExpressionEngine

by Leonard Murphy | September 2010 | MySQL Content Management PHP

The vast majority of a website is content, and ExpressionEngine makes it easy to create and maintain such content. In this two-part article series we will create an actual website and learn how to use channels and templates to display our content.

In this article by Leonard Murphy, author of Building Websites with Expression Engine 2.X, you will take an existing website that was written outside of ExpressionEngine and adapt it to ExpressionEngine. As part of this transition, you will be creating your own channel with fields customized to the content that you will be displaying.

Read Creating Channel for Moving a Website to ExpressionEngine in full

Error Handling in PHP 5 CMS

by Martin Brampton | August 2010 | Content Management Open Source PHP Web Development

In this article by Martin Brampton author of PHP 5 CMS Framework Development, we will learn various aspects about error handling in PHP 5 Content Management System. Specifically we will cover:

  • PHP error handling
  • Database errors
  • Application errors
  • Exploring PHP—Error handling
  • Framework solution
  • Handling database errors
  • 404 and 403 errors
Read Error Handling in PHP 5 CMS in full

Database Considerations for PHP 5 CMS

by Martin Brampton | August 2010 | Content Management Open Source PHP Web Development

In this article, by Martin Brampton author of PHP 5 CMS Framework Development, we will cover the following topics about databases in PHP 5 Content Management Systems:

  • Database dependency
  • The role of the database
  • Level of database abstraction
  • Ease of development
  • Keeping up with change
  • Database security
  • Pragmatic error handling
Read Database Considerations for PHP 5 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
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