PHP and MS Excel

There are several libraries out there for reading and writing MS Excel files. Here I note down my experiences with some of them. Here is a list of libraries for working with Excel: https://packagist.org/packages/maatwebsite/excel https://packagist.org/packages/php-excel-reader/spreadsheet-reader http://phpexcel.codeplex.com   maatwebsite/excel Link: https://packagist.org/packages/maatwebsite/excel Read more…

My Apache cheat sheet

The VirtualHost configuration is located here /etc/apache2/sites-available Defining a VirtualHost <VirtualHost *:80> ServerName app.dev DocumentRoot /var/www/html/my-app/ </Virtualhost> I am using Vagrant on Windows, so I have to add this domain to my Windows hosts file: 192.168.10.10 app.dev The Apache Service and its Read more…

XML Sitemap

A sitemap is a file where you can list the web pages of your site to tell Google and other search engines about the organization of your site content

This is how Google describes a sitemap and it tells you all about its purpose.

When I write custom software, I usually want to create a sitemap with PHP automatically.

(more…)

Vagrant LAMP Stack setup

I liked WAMP very much, but after discovering Vagrant I never will go back to WAMP.

What is Vagrant used for?

Create and configure lightweight, reproducible, and portable development environments.

In my words: Vagrant is used to simulate a real server environment to interact with.

In this article I want to share my basic setup.

(more…)

wordpress, style.css

Some boilerplates for wordpress theming: /* Theme Name: Twenty Twelve Child Theme URI: http://example.com/ Description: Child theme for the Twenty Twelve theme Author: Your name here Author URI: http://example.com/about/ Version: 0.1.0 */ And for child themes: /* Theme Name: Twenty Read more…