PHP Zend Framework: November 2012

Thursday, 22 November 2012

How to setup subdomains on localhost (WAMP)

How to setup local subdomains using Wampserver

Developing code locally on your computer has some major benefits over using a web server. For one, it’s usually faster as you don’t have to wait for your file changes to upload to the web.
I’ll be using WampServer, a program that lets you run a local web environment (Apache, PHP & MySQL)
You’ll need to download & install WampServer before continuing with this tutorial.
This tutorial assumes WAMP is installed under C:\wamp. You may change this path to reflect your own installation if it differs.

Step 1: Create the folder which will hold your subdomains

For example. Create the following folder:
C:\wamp\www\subdomains
Each folder contained within the subdomains folder will essentially become a subdomain. For example:
example.localhost.com will point to C:\wamp\www\subdomains\example\

Step 2: Make sure httpd-vhosts.conf file is included.

1) Open C:\wamp\bin\apache\Apache2.2.21\conf\httpd.conf (or choose Wampserver > Apache > httpd.conf)
2) Find the lines:

# Virtual hosts
# Include conf/extra/httpd-vhosts.conf

3) Change to:

# Virtual hosts
Include conf/extra/httpd-vhosts.conf

Step 3: Configuring Apache VirtualHosts

1) Enable the alias_module and vhost_alias_module for apache.

Doing this will enable virtualhost aliasing in apache for your subdomains.
2) Open C:\wamp\bin\apache\Apache2.2.21\conf\extra\httpd-vhosts.conf
3) In the httpd-vhosts.conf file, you’ll most likely see some example data. Replace everything with the following:

NameVirtualHost *:80

<VirtualHost *:80>
    ServerName localhost.com
    ServerAlias www.localhost.com
    DocumentRoot "C:\wamp\www"
    ErrorLog "logs\errors.log"
    <directory "C:\wamp\www">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

<VirtualHost *:80>
    ServerName localhost.com
    ServerAlias *.localhost.com
    VirtualDocumentRoot C:\wamp\www\subdomains\%1
    ErrorLog "logs\errors.log"
    <directory "C:\wamp\www\subdomains\%1">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

So what’s going on with the code above? Each <VirtualHost> tag contains a host definition. The asterisk in <VirtualHost *:80> tells apache that any IP address can be used to access this host definition. If you wanted to restrict it to just your computer, you could do <VirtualHost 127.0.0.1:80>
ServerName
ServerName localhost.com
The domain. I use localhost.com. Just remember that whatever you choose to use will essential replace any real domains (EX: using google.com will not let you access the real google.com later)
ServerAlias
ServerAlias *.localhost.com
An alternate domain alias (usually www.localhost.com)
DocumentRoot
DocumentRoot "C:\wamp\www"
The absolute directory to your domain’s root (accessed by going to localhost.com)
ErrorLog Path to your error log. This is optional.
ErrorLog "logs\errors.log"
VirtualDocumentRoot
VirtualDocumentRoot C:\wamp\www\subdomains\%1
The absolute directory for your subdomain, with a wildcard to define the subdomain’s name. I use a wildcard %1 to get the name of the subdomain. example.localhost.com will point to C:\wamp\www\subdomains\example
<directory ________>
<directory "C:\wamp\www">
<directory "C:\wamp\www\subdomains\%1">
The directory permission definitions. Defined twice for both localhost.com and it’s virtual subdomains.
4) After making the changes to your httpd-vhosts.conf file, you must restart apache for the changes to take effect. Just click the WAMPSERVER icon in your Notification Area and choose “Restart All Services”.

Step 3: Updating Windows Host File

In order for you to access your localhost.com or example.localhost.com, you must first point these domains to your local IP address. Windows unfortunately does not allow you to use a wildcard in the hosts file. You will have to input each new subdomain into your hosts file for it to work in your browser.
1) Open C:\Windows\System32\drivers\etc\hosts using Notepad
2) Add a the following line to the bottom of your hosts file.

127.0.0.1       example.localhost.com

You have to do this for each domain & subdomain you wish to use. For example:

127.0.0.1       localhost.com
127.0.0.1       www.localhost.com
127.0.0.1       example.localhost.com
127.0.0.1       example2.localhost.com
127.0.0.1       mysubdomain.localhost.com

Test! Check if your subdomains work.

Open your browser and go to your local subdomain: example.localhost.com
Apache should now be serving files for that subdomain from C:\wamp\www\subdomains\example

Additionally: Custom Domain Definitions

If you ever wanted to create a custom domain definition that pointed to a folder outside of your “subdomains” folder, you can do that! Just open your httpd-vhosts.conf file (See step 2.2), and paste the following directly after NameVirtualHost *:80 and before the first instance of <VirtualHost *:80>.
This custom definition MUST be before your wildcard VirtualHost definition to work.

<VirtualHost *:80>
    ServerName mycustomlocaldomain.com
    ServerAlias www.mycustomlocaldomain.com
    DocumentRoot "C:\Documents\mycustomlocaldomain.com"
    ErrorLog "logs\errors.log"
    <directory "C:\Documents\mycustomlocaldomain.com">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

And how the httpd-vhosts.conf should finally look with this custom definition:

NameVirtualHost *:80

<VirtualHost *:80>
    ServerName mycustomlocaldomain.com
    ServerAlias www.mycustomlocaldomain.com
    DocumentRoot "C:\Documents\mycustomlocaldomain.com"
    ErrorLog "logs\errors.log"
    <directory "C:\Documents\mycustomlocaldomain.com">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

<VirtualHost *:80>
    ServerName localhost.com
    ServerAlias www.localhost.com
    DocumentRoot "C:\wamp\www"
    ErrorLog "logs\errors.log"
    <directory "C:\wamp\www">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

<VirtualHost *:80>
    ServerName localhost.com
    ServerAlias *.localhost.com
    VirtualDocumentRoot C:\wamp\www\subdomains\%1
    ErrorLog "logs\errors.log"
    <directory "C:\wamp\www\subdomains\%1">
        Options Indexes FollowSymLinks
        AllowOverride all
        Order Deny,Allow
        Deny from all
        Allow from all
    </directory>
</VirtualHost>

Friday, 2 November 2012

Read Excle file ( .xlsx ) Using PHP

<?php
// SimpleXLSX php class v0.4
// MS Excel 2007 workbooks reader
// Example:
   $xlsx = new SimpleXLSX('pizza hut-sample-ori.xlsx');
   echo '<pre>';print_r( $xlsx->rows() );
// Example 2:
//   $xlsx = new SimpleXLSX('book.xlsx');
//   print_r( $xlsx->rowsEx() );
// Example 3:
//   $xlsx = new SimpleXLSX('book.xlsx');
//   print_r( $xlsx->rows(2) ); // second worksheet
//
// 0.4 sheets(), sheetsCount(), unixstamp( $excelDateTime ), getWorksheetName() by SPYRO KiD - http://www.spyrozone.net
// 0.3 - fixed empty cells (Gonzo patch)

class SimpleXLSX {
// Don't remove this string! Created by Sergey Schuchkin from http://www.sibvison.ru - professional php developers team 2010-2011
private $sheets;
private $hyperlinks;
private $package;
private $sharedstrings;
// scheme
const SCHEMA_OFFICEDOCUMENT = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument';
const SCHEMA_RELATIONSHIP = 'http://schemas.openxmlformats.org/package/2006/relationships';
const SCHEMA_SHAREDSTRINGS = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings';
const SCHEMA_WORKSHEETRELATION = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet';

function __construct( $filename ) {
$this->_unzip( $filename );
$this->_parse();
}
function sheets() {
return $this->sheets;
}
function sheetsCount() {
return count($this->sheets);
}
function worksheet( $worksheet_id ) {
if ( isset( $this->sheets[ $worksheet_id ] ) ) {
$ws = $this->sheets[ $worksheet_id ];

if (isset($ws->hyperlinks)) {
$this->hyperlinks = array();
foreach( $ws->hyperlinks->hyperlink as $hyperlink ) {
$this->hyperlinks[ (string) $hyperlink['ref'] ] = (string) $hyperlink['display'];
}
}

return $ws;
} else
throw new Exception('Worksheet '.$worksheet_id.' not found.');
}
function dimension( $worksheet_id = 1 ) {
$ws = $this->worksheet($worksheet_id);
$ref = (string) $ws->dimension['ref'];
$d = explode(':', $ref);
$index = $this->_columnIndex( $d[1] );
return array( $index[0]+1, $index[1]+1);
}
// sheets numeration: 1,2,3....
function rows( $worksheet_id = 1 ) {

$ws = $this->worksheet( $worksheet_id);

$rows = array();
$curR = 0;

foreach ($ws->sheetData->row as $row) {

foreach ($row->c as $c) {
list($curC,) = $this->_columnIndex((string) $c['r']);
$rows[ $curR ][ $curC ] = $this->value($c);
}

$curR++;
}
return $rows;
}
function rowsEx( $worksheet_id = 1 ) {
$rows = array();
$curR = 0;
if (($ws = $this->worksheet( $worksheet_id)) === false)
return false;
foreach ($ws->sheetData->row as $row) {

foreach ($row->c as $c) {
list($curC,) = $this->_columnIndex((string) $c['r']);
$rows[ $curR ][ $curC ] = array(
'name' => (string) $c['r'],
'value' => $this->value($c),
'href' => $this->href( $c ),
);
}
$curR++;
}
return $rows;

}
// thx Gonzo
function _columnIndex( $cell = 'A1' ) {

if (preg_match("/([A-Z]+)(\d+)/", $cell, $matches)) {

$col = $matches[1];
$row = $matches[2];

$colLen = strlen($col);
$index = 0;

for ($i = $colLen-1; $i >= 0; $i--)
$index += (ord($col{$i}) - 64) * pow(26, $colLen-$i-1);

return array($index-1, $row-1);
} else
throw new Exception("Invalid cell index.");
}
function value( $cell ) {
// Determine data type
$dataType = (string)$cell["t"];
switch ($dataType) {
case "s":
// Value is a shared string
if ((string)$cell->v != '') {
$value = $this->sharedstrings[intval($cell->v)];
} else {
$value = '';
}

break;

case "b":
// Value is boolean
$value = (string)$cell->v;
if ($value == '0') {
$value = false;
} else if ($value == '1') {
$value = true;
} else {
$value = (bool)$cell->v;
}

break;

case "inlineStr":
// Value is rich text inline
$value = $this->_parseRichText($cell->is);

break;

case "e":
// Value is an error message
if ((string)$cell->v != '') {
$value = (string)$cell->v;
} else {
$value = '';
}

break;

default:
// Value is a string
$value = (string)$cell->v;

// Check for numeric values
if (is_numeric($value) && $dataType != 's') {
if ($value == (int)$value) $value = (int)$value;
elseif ($value == (float)$value) $value = (float)$value;
elseif ($value == (double)$value) $value = (double)$value;
}
}
return $value;
}
function href( $cell ) {
return isset( $this->hyperlinks[ (string) $cell['r'] ] ) ? $this->hyperlinks[ (string) $cell['r'] ] : '';
}
function _unzip( $filename ) {
// Clear current file
$this->datasec = array();

// Package information
$this->package = array(
'filename' => $filename,
'mtime' => filemtime( $filename ),
'size' => filesize( $filename ),
'comment' => '',
'entries' => array()
);
// Read file
$oF = fopen($filename, 'rb');
$vZ = fread($oF, $this->package['size']);
fclose($oF);
// Cut end of central directory
$aE = explode("\x50\x4b\x05\x06", $vZ);

// Normal way
$aP = unpack('x16/v1CL', $aE[1]);
$this->package['comment'] = substr($aE[1], 18, $aP['CL']);

// Translates end of line from other operating systems
$this->package['comment'] = strtr($this->package['comment'], array("\r\n" => "\n", "\r" => "\n"));

// Cut the entries from the central directory
$aE = explode("\x50\x4b\x01\x02", $vZ);
// Explode to each part
$aE = explode("\x50\x4b\x03\x04", $aE[0]);
// Shift out spanning signature or empty entry
array_shift($aE);

// Loop through the entries
foreach ($aE as $vZ) {
$aI = array();
$aI['E'] = 0;
$aI['EM'] = '';
// Retrieving local file header information
//            $aP = unpack('v1VN/v1GPF/v1CM/v1FT/v1FD/V1CRC/V1CS/V1UCS/v1FNL', $vZ);
$aP = unpack('v1VN/v1GPF/v1CM/v1FT/v1FD/V1CRC/V1CS/V1UCS/v1FNL/v1EFL', $vZ);
// Check if data is encrypted
//            $bE = ($aP['GPF'] && 0x0001) ? TRUE : FALSE;
$bE = false;
$nF = $aP['FNL'];
$mF = $aP['EFL'];

// Special case : value block after the compressed data
if ($aP['GPF'] & 0x0008) {
$aP1 = unpack('V1CRC/V1CS/V1UCS', substr($vZ, -12));

$aP['CRC'] = $aP1['CRC'];
$aP['CS'] = $aP1['CS'];
$aP['UCS'] = $aP1['UCS'];

$vZ = substr($vZ, 0, -12);
}

// Getting stored filename
$aI['N'] = substr($vZ, 26, $nF);
if (substr($aI['N'], -1) == '/') {
// is a directory entry - will be skipped
continue;
}

// Truncate full filename in path and filename
$aI['P'] = dirname($aI['N']);
$aI['P'] = $aI['P'] == '.' ? '' : $aI['P'];
$aI['N'] = basename($aI['N']);

$vZ = substr($vZ, 26 + $nF + $mF);

if (strlen($vZ) != $aP['CS']) {
$aI['E'] = 1;
$aI['EM'] = 'Compressed size is not equal with the value in header information.';
} else {
if ($bE) {
$aI['E'] = 5;
$aI['EM'] = 'File is encrypted, which is not supported from this class.';
} else {
switch($aP['CM']) {
case 0: // Stored
// Here is nothing to do, the file ist flat.
break;
case 8: // Deflated
$vZ = gzinflate($vZ);
break;
case 12: // BZIP2
if (! extension_loaded('bz2')) {
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN') {
@dl('php_bz2.dll');
} else {
@dl('bz2.so');
}
}
if (extension_loaded('bz2')) {
$vZ = bzdecompress($vZ);
} else {
$aI['E'] = 7;
$aI['EM'] = "PHP BZIP2 extension not available.";
}
break;
default:
$aI['E'] = 6;
$aI['EM'] = "De-/Compression method {$aP['CM']} is not supported.";
}
if (! $aI['E']) {
if ($vZ === FALSE) {
$aI['E'] = 2;
$aI['EM'] = 'Decompression of data failed.';
} else {
if (strlen($vZ) != $aP['UCS']) {
$aI['E'] = 3;
$aI['EM'] = 'Uncompressed size is not equal with the value in header information.';
} else {
if (crc32($vZ) != $aP['CRC']) {
$aI['E'] = 4;
$aI['EM'] = 'CRC32 checksum is not equal with the value in header information.';
}
}
}
}
}
}

$aI['D'] = $vZ;

// DOS to UNIX timestamp
$aI['T'] = mktime(($aP['FT'] & 0xf800) >> 11,
($aP['FT'] & 0x07e0) >> 5,
($aP['FT'] & 0x001f) << 1,
($aP['FD'] & 0x01e0) >> 5,
($aP['FD'] & 0x001f),
(($aP['FD'] & 0xfe00) >> 9) + 1980);

//$this->Entries[] = &new SimpleUnzipEntry($aI);
$this->package['entries'][] = array(
'data' => $aI['D'],
'error' => $aI['E'],
'error_msg' => $aI['EM'],
'name' => $aI['N'],
'path' => $aI['P'],
'time' => $aI['T']
);

} // end for each entries
}
function getPackage() {
return $this->package;
}
function getEntryData( $name ) {
$dir = dirname( $name );
$name = basename( $name );
foreach( $this->package['entries'] as $entry)
if ( $entry['path'] == $dir && $entry['name'] == $name)
return $entry['data'];
}
function unixstamp( $excelDateTime ) {
$d = floor( $excelDateTime ); // seconds since 1900
$t = $excelDateTime - $d;
return ($d > 0) ? ( $d - 25569 ) * 86400 + $t * 86400 : $t * 86400;
}
function _parse() {
// Document data holders
$this->sharedstrings = array();
$this->sheets = array();

// Read relations and search for officeDocument

$relations = simplexml_load_string( $this->getEntryData("_rels/.rels") );
foreach ($relations->Relationship as $rel) {
if ($rel["Type"] == SimpleXLSX::SCHEMA_OFFICEDOCUMENT) {
// Found office document! Read relations for workbook...
$workbookRelations = simplexml_load_string($this->getEntryData( dirname($rel["Target"]) . "/_rels/" . basename($rel["Target"]) . ".rels") );
$workbookRelations->registerXPathNamespace("rel", SimpleXLSX::SCHEMA_RELATIONSHIP);

// Read shared strings
$sharedStringsPath = $workbookRelations->xpath("rel:Relationship[@Type='" . SimpleXLSX::SCHEMA_SHAREDSTRINGS . "']");
$sharedStringsPath = (string)$sharedStringsPath[0]['Target'];
$xmlStrings = simplexml_load_string($this->getEntryData( dirname($rel["Target"]) . "/" . $sharedStringsPath) );
if (isset($xmlStrings) && isset($xmlStrings->si)) {
foreach ($xmlStrings->si as $val) {
if (isset($val->t)) {
$this->sharedstrings[] = (string)$val->t;
} elseif (isset($val->r)) {
$this->sharedstrings[] = $this->_parseRichText($val);
}
}
}

// Loop relations for workbook and extract sheets...
foreach ($workbookRelations->Relationship as $workbookRelation) {
if ($workbookRelation["Type"] == SimpleXLSX::SCHEMA_WORKSHEETRELATION) {
$this->sheets[ str_replace( 'rId', '', (string) $workbookRelation["Id"]) ] =
simplexml_load_string( $this->getEntryData( dirname($rel["Target"]) . "/" . dirname($workbookRelation["Target"]) . "/" . basename($workbookRelation["Target"])) );
}
}

break;
}
}

// Sort sheets
ksort($this->sheets);
}
private function _parseRichText($is = null) {
$value = array();

if (isset($is->t)) {
$value[] = (string)$is->t;
} else {
foreach ($is->r as $run) {
$value[] = (string)$run->t;
}
}

return implode(' ', $value);
}
function getWorksheetName($dimId = 0){
$worksheetName = array();
$xmlWorkBook = simplexml_load_string( $this->getEntryData("xl/workbook.xml") );
if($dimId==0){
foreach ($xmlWorkBook->sheets->sheet as $sheetName) {
$worksheetName[] = $sheetName['name'];
}
}else{
$worksheetName[] = $xmlWorkBook->sheets->sheet[$dimId-1]->attributes()->name;
}
return $worksheetName;
}
}
?>

Pages

Thursday, 22 November 2012

How to setup subdomains on localhost (WAMP)

How to setup local subdomains using Wampserver

Step 1: Create the folder which will hold your subdomains

Step 2: Make sure httpd-vhosts.conf file is included.

Step 3: Configuring Apache VirtualHosts

Step 3: Updating Windows Host File

Test! Check if your subdomains work.

Additionally: Custom Domain Definitions

Friday, 2 November 2012

Read Excle file ( .xlsx ) Using PHP

Read Excle file ( .xlsx ) Using PHP