Reading and Writing Spreadsheets with PHP
by vvaswani |
3 comments | Monday, March 31, 2008
When it comes to playing nice with data in different formats, PHP’s pedigree is hard to beat. Not only does the language make it a breeze to deal with SQL resultsets and XML files, but it comes with extensions to deal with formats as diverse as Ogg/Vorbis audio files, ZIP archives and EXIF headers. So it should come as no surprise that PHP can also read and write Microsoft Excel spreadsheets, albeit with a little help from PEAR. In this article, I’ll introduce you to two packages that make it surprisingly easy to hook your PHP scripts up to a Microsoft Excel spreadsheet and extract the data contained therein. I’ll also show you how to dynamically create a new spreadsheet from scratch, complete with formulae and formatting, and import data from a spreadsheet into a database. So come on it, and let’s get started!
Creating Data Tables With PEAR Structures_DataGrid
by vvaswani |
3 comments | Monday, January 28, 2008
As a developer who builds customized PHP applications for clients on a regular basis, I’m always on the lookout for new and interesting PHP widgets that could reduce the time I spend writing code. And one such widget is PEAR’s Structures_DataGrid package, which provides a handy way to display, sort and edit structured data in a table.
Generating and Validating Web Forms With PEAR HTML_QuickForm (part 2)
by vvaswani |
3 comments | Monday, January 21, 2008
In this second (and concluding) segment, I’ll be giving you a brief glimpse of other aspects of HTML_QuickForm that I think you would find educational, entertaining or both. I’ll be discussing some of the package’s non-standard form elements, teaching you how to combine elements into groups, showing you how to apply templates to control a form’s appearance, and guiding you through the process of writing and registering your own custom validation rules. That’s a lot of ground to cover, so you should stop dawdling over this introduction and flip the page to get started.
WEBINAR: Everything you need to know about the PHP 5 Certification Exam
by Cal Evans (editor) |
1 comment | Monday, January 21, 2008
My good friend and fellow Zender Nili Gafni pinged me yesterday to remind me that we’ve got another free Webinar coming up. This one is “Everything you need to know about the PHP 5 Certification Exam”. I’m assuming that means ”...except for the answers.”
Generating and Validating Web Forms With PEAR HTML_QuickForm
by vvaswani |
0 comments | Tuesday, November 27, 2007
Over the next few pages, I’ll be introducing you to one of PEAR’s most powerful tools for generating Web forms and validating the input that arrives through them: the HTML_QuickForm package. This package provides a flexible, reusable library of methods that can literally save you hours of time when dealing with form-based user input – and best of all, it’s free and extremely easy to use. So what are you waiting for? Jump right in, and let’s get going!
Generating and Validating Web Forms With PEAR HTML_QuickForm
by vvaswani |
5 comments | Monday, November 12, 2007
This article will introduce you to one of PEAR’s most powerful tools for generating Web forms and validating the input that arrives through them: the HTML_QuickForm package. This package provides a flexible, reusable library of methods that can literally save you hours of time when dealing with form-based user input – and best of all, it’s free and extremely easy to use.
the article forgets the intended purpose
by iosicumine |
0 comments | Wednesday, August 22, 2007
If the author reaches the conclusion that the best solution around is using GnuPG Made Easy (read the Alternatives section), then why the heck isn't presenting that?! Merely using a shell command to encrypt/decrypt... anybody knows to do that.
On short, I wasted time to read the article.
On short, I wasted time to read the article.
Paging Data Sets With PEAR Pager
by vvaswani |
7 comments | Monday, August 6, 2007
As a community-supported open-source language, PHP enjoys the support of hundreds of dedicated developers, who are continuously adding to the available store of PHP libraries and knowledge. This support is most visible in projects like PECL, the PHP Extension Community Library and PEAR, the PHP Extension and Application Repository, which offers a robust, feature-rich collection of PHP widgets that can save developers a fair amount of time and effort.
One such widget is PEAR’s Pager class, which offers developers a framework for breaking large data sets into smaller chunks, or pages, for greater readability or easier navigation. Pagination is important, particularly when dealing with result sets containing hundreds or thousands of items, because it allows the user to exert some degree of control over which segment of the data set is visible at any given point, and thus avoid drowning in a never-ending sea of data.
One such widget is PEAR’s Pager class, which offers developers a framework for breaking large data sets into smaller chunks, or pages, for greater readability or easier navigation. Pagination is important, particularly when dealing with result sets containing hundreds or thousands of items, because it allows the user to exert some degree of control over which segment of the data set is visible at any given point, and thus avoid drowning in a never-ending sea of data.
Zend Framework Gets An Unofficial PEAR Channel
by Cal Evans (editor) |
4 comments | Thursday, March 1, 2007
Thanks to the phpmafia, the Zend Framework has a PEAR channel that you can use to install it from. Details can be found on on the authors blog, however, they are in French. Babelfish will translate them for you but it ends up sounding like a passage out of Borat. So I’ll paraphrase for you and give you the details.
Synchronize Live and Development Sites Using the PEAR Installer
by Cal Evans (editor) |
0 comments | Tuesday, February 13, 2007
Greg Beaver recently posted a short tutorial on why and how to use PEAR to migrate code to your production server using PEAR. Click on inside, let’s take a look at this.
