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 fullAdministrating 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
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
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 fullPerforming 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
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
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 fullError 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
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
Sessions and Users 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 get into the detailed questions involved in providing continuity for people using our websites. Almost any framework to support web content needs to handle this issue robustly, and efficiently. In this article, we will look at the need for sessions, and the PHP mechanism that makes them work. There are security issues to be handled, as sessions are a well known source of vulnerabilities. Search engine bots can take an alarmingly large portion of your site bandwidth, and special techniques can be used to minimize their impact on session handling. Actual mechanisms for handling sessions are provided. Session data has to be stored somewhere, and it is better to take charge of this task rather than leave it to PHP. A simple but fully effective session data handler is developed using database storage.
Read Sessions and Users in PHP 5 CMS in full
