Linux, Apache, Nginx, MySQL, Javascript and PHP

Count rows and columns with Excel
Applications

Count rows and columns with Excel

Want to count rows and/or columns in a range with Excel no matter what content they contain? This

Locale issues with Zend Lucene search
PHP

Locale issues with Zend Lucene search

We use Zend Lucene Search on a PHP ecommerce website and ran into some issues where records added to

Enable & disable WordPress plugins from the command line
WordPress

Enable & disable WordPress plugins from the command line

Sometimes installing or upgrading a WordPress plugin breaks both the frontend of your website and the WordPress admin too,

Starting and Stopping Sendmail with FreeBSD
Email Servers Linux/Unix/BSD

Starting and Stopping Sendmail with FreeBSD

Management of sendmail is done on FreeBSD by changing to sendmail’s directory (/etc/mail) and running "make"

Promo Codes, Discount Vouchers, Etc.
Miscellaneous Postings

Promo Codes, Discount Vouchers, Etc.

This post has promo codes and discount voucher codes that I come across that I find useful and may

Screen: cannot open your terminal ‘/dev/pts/0’
Linux/Unix/BSD

Screen: cannot open your terminal ‘/dev/pts/0’

If you are logged in as a user using “su” or “sudo su” and attempt to use screen, you’ll

How to default a column as a UUID/GUID in MySQL
MySql

How to default a column as a UUID/GUID in MySQL

MySQL does not yet support setting a column’s default value using a function (at least not yet as of

Join video files together on Mac with cat and mencoder
OSX

Join video files together on Mac with cat and mencoder

I have a whole bunch of short avi files (not sure what format they actually are, but the extension

OSX Quick Tip: Show all files in the Finder including dot files
OSX Quick Tips

OSX Quick Tip: Show all files in the Finder including dot files

The default behavior of the Finder on OSX is to hide UNIX files such as /usr /var etc and

MySQL “Incorrect key file for table /tmp/#sql_xxx_x.MYI” error
MySql

MySQL “Incorrect key file for table /tmp/#sql_xxx_x.MYI” error

I’ve written a post in the past about dealing with the “Incorrect key file for table” in MySQL
Cookies and domains
Javascript PHP

Cookies and domains

A little while back I posted how to set cookies with jQuery and was asked

Remove input shadows on iOS devices
OSX

Remove input shadows on iOS devices

One thing I’ve found annoying with the mobile Safari browser on iOS is the shadows that appear at the

How to restore the debian-sys-maint MySQL user
MySql

How to restore the debian-sys-maint MySQL user

My last post looked at how to fix ERROR 1045 (28000): Access denied for

Use jQuery to make all offsite links open in a new window
Javascript

Use jQuery to make all offsite links open in a new window

XHTML Strict does not allow opening links in a new window using target=””_blank”” so instead you can use

Opacity for Internet Explorer using CSS3 PIE and Alpha Transparency
HTML And CSS

Opacity for Internet Explorer using CSS3 PIE and Alpha Transparency

Alpha transparency is a much easier way to make a background transparent than having to specify a whole bunch

Solving a couple of gotchas with CSS3 PIE
HTML And CSS

Solving a couple of gotchas with CSS3 PIE

CSS3 PIE is a utility for Internet Explorer which adds support for some of the most useful CSS3 properties missing
Inject HTML content into Disqus and jQuery
Javascript

Inject HTML content into Disqus and jQuery

My last post looked at how to run Javascript functions after Disqus has loaded using their undocumented callback functions. The
CSS Sprites – making one of the buttons active
HTML And CSS

CSS Sprites – making one of the buttons active

A few months ago I posted using CSS sprites for image navigation which looks at

1 2 3 4 5 6 49