eapps

Pear and Pecl Support

Applicable Plans: All Standard VPS, all Advanced VPS, all Premier VPS, Plesk Gold VPS, Plesk Platinum VPS Plans

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

Requirements

PHP must be installed in your VPS subscription. This can be done by selecting it when you order the eApps VPS hosting service or by installing it using the Control Panel after the service has been provisioned. To see if PHP is already installed login to your Control Panel and click on the All Applications icon. If it is not in the installed list, you may install it by clicking on the Add Application icon from the System tab and selecting PHP then clicking Next.

General Information

Your eApps PHP has all of the features to allow you to develop a site using the latest standards and modules. Below is a list of all the features installed by default.
--------
Your PHP by default has both pear and pecl enabled so you can install any modules directly from the php.net site. To use pear or pecl you will need to login to SSH as root. Please read the SSH user guide for more details -http://support.eapps.com/hsp/ssh.

Execute the below commands for installing modules.

pear install module_name

Or

pecl install module_name


Once your module is installed it needs to be loaded in PHP in order to be available for use. To load it you will need to create a file in /etc/php.d/ called module_name.ini that should contain:

extension = module_name.so

It is preferrable to use a new file for each extension you want to load. This allows for easier management of extensions php is using. Certain modules have their own list of variables that can be defined. You should also define them in the extension file instead of directly using php.ini. The file php.ini should be used only to define php default values, and not to load extensions. Please refer to the section below, called 'Editing the php.ini file' for more details about php.ini file.

After the file was added, you will need to restart Apache web server. You can either restart it from the control panel -> system tab -> apache web server -> restart or by SSH. Please note that you need to be the root user to be able to restart Apache with this command:

service httpd restart

-----------
Why use an eApps Virtual Private Server for your PHP hosting needs?
We understand that the reason you are looking for a VPS hosting service is because you are frustrated by the limitations of shared hosting and standard issue VPS services with an inferior PHP environment. With your needs in mind, we are offering PHP for power users. Our PHP is the latest version available from the php.net site, and it comes with rich features, including the following:

* pear and pecl pre-installed, ready for use
----------------------------------

Reading and Writing Spreadsheets with PHP

Breaking The Language Barrier

downloaded from this link and unzipped , it works, no install of pkg. reqd.
a) just rename oleread.inc to oleread.php
b) require_once 'Excel/oleread.php'; -- change in reader.php file
c) given jvx* xls file is bad, so use your own .xsl
d) with all 3 above it works. ..

http://sourceforge.net/projects/phpexcelreader/files/

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!

I should mention at this point certain changes you might need to make to your development environment in order to get the PHP-ExcelReader package working. As noted above, this package is currently not maintained and so, simply include()-ing the main class file, 'reader.php', in your script, as suggested in the package documentation, is insufficient and generates a 'missing file' error.

To get things working, extract the file 'oleread.inc' from the distribution archive and save it to a location in your PHP include path using the directory structure 'Spreadsheet/Excel/Reader/OLERead.php'.
-----------

Here's an example how to read these files

http://forums.codewalkers.com/pear-packages-47/spreadsheet-excel-reader-852965.html