// archives

Apache / PHP / MySQL

This category contains 5 posts

The valuable value of MySQL NULL

In many programming languages, coders often use NULL or null as an equivalent to the numeric ‘0’ (zero) in comparison tests. This normally works out, but it’s worth mentioning that in the database world, ‘NULL’ means something else. To illustrate this, in MySQL we can see that querying NULL returns a string representing the keyword/value […]

Mac OS X Mavericks upgrade pre-steps for developers

If you’re like me, you use your Macbook Pro computer for software development; more specifically PHP. This development requires a lot of configuration in an online environment. Major and security upgrades from Apple seem to always replace the current configuration files with their own default versions. This is a serious pain. Specific Generic Files: httpd.conf […]

OSX ImageMagick PHP Apache after an upgrade

One annoying thing about Mac software upgrades is they occasionally blow away installs of various software. Differing compiler version can make shared libraries incompatible after these updates. Here’s my solution to solving a problem where my ImageMagick shared object became incompatible as a PHP extenstion. sudo port install imagemagick php53-imagick php53-magickwand cd /usr/lib/php/extensions/no-debug-non-zts-20090626/ sudo cp […]

PHP Quicksort Demonstration

Here’s a working example of a Quicksort function.

PHP Linked List Example

Continuing my data structures thoughts from previous posts, I’ve created a linked list example. /* * Node – a basic link node. */ class Node { var $id; var $next; /* * */ function __construct($id) { $this->id = $id; } } $a = new Node(“mark”); var_dump($a); $b = $a->next = new Node(“wes”); var_dump($b); $c = […]