Linux, Apache, Nginx, MySQL, Javascript and PHP
Using strtotime with PHP
The strtotime() function in PHP allows you to convert English text date time strings into UNIX timestamps. It is
Formatting Dates with PHP
PHP has a really useful date() function for formatting dates from timestamps. When used in conjunction with strtotime() you
Restore data from a tab delimited file to MySQL
Yesterday I looked at using mysqldump to save data to CSV files, which by default
Using mysqldump to save data to CSV files
Yesterday I looked at basic use of mysqldump for backing up MySQL databases. Today I
Backing up MySQL with mysqldump
A simple way to back up MySQL databases is with the mysqldump
command line tool. Mysqldump can
Triggering errors with PHP
It is possible to trigger an error in PHP. This can be useful for debugging purposes, or if there
MySQL Query Cache
MySQL has a query cache which caches the results of SELECT queries, if enabled. This means that frequently used
SQL query to work out top selling categories
I sell Linux on CD on my Linux CD Mall website, and
MySQL Backups with a Command Line PHP Script
I run a number of web servers with PHP and MySQL and have a PHP command line script that
PHP Magic Constants
There are several PHP "magic constants" (or "magical contants") which can be useful for a
Shell scripting using the date command
A useful command line tool is date
, which is typically used for displaying the current system date,
Replacing relative URLs with absolute URLs in PHP
I’ve finally set up an RSS feed for this site and one of the things I needed to sort
Yum error Metadata file does not match checksum
When trying to install something on a CentOS 5 machine using Yum today, I got the error message "Metadata
Keyboard shortcuts to switch between running VMWare Virtual Machines
I run VMWare Workstation on a Linux host machine with multiple virtual machines as my day to day desktop
Install Yum on openSUSE with Yast
openSUSE has an excellent system management tool called Yast, but the software package management tool in Yast is really
Updating Postfix’s virtual alias maps
Postfix allows you to store virtual alias maps in a text file, which tells postfix how to route virtual
Changing the hostname on CentOS
If the hostname setting is incorrect on your CentOS/RedHat/Fedora machine, it’s really easy to change the hostname
Apache – Permission denied: Failed to acquire SSL session cache lock
I’ve set up a CentOS 5 Apache web server for a customer where we run the web server as user