If you have a table of GPS data ,that keeps getting written to, and starts to run to millions of records. It is a sensible idea to create a trigger under mysql to update a scratchpad summary table on an … Continued
Using Sum and ABS statements in MySQL
MySQL / PHP Problem I need to sum the number of entries in a table where an id > 0 or an id = 23 Resolution Use a GROUP BY clause in conjunction with a SUM and an ABS SUM( … Continued
Setup PHP SSH2 Connection from php to remote box on pair networks
1. Download modules http://www.php.net/downloads.php Download Win32 binaries and extract php_ssh2.dll to the extensions directory Edit the php.ini file that is being used to include this extension extension=php_ssh2.dll Generate a pub / private key pair on the server you wish to … Continued
Serialised Array Walk
This is an array_walk style serialize that works with multi dimensional arrays, it also base64 encodes and decodes to allow ‘;’ to exist in the array.
PHP addslashes to an Array
This is for a solution for adding slashes to a $_POST array when you don’t know if magic quotes is turned on.