Archive for the ‘PHP’ Category

MySQL replication in PHP – on the same machine

Wednesday, September 14th, 2011

I just realized I needed to replicate some data from one database to another, but only certain tables.... Read More

PHP color scheme

Saturday, July 9th, 2011

Color theming in Geany is quite a no-brainer if you know how to go about it.... Read More

Unzip on Ubuntu, the mess it makes with UTF-8 and the PHP fix

Wednesday, June 22nd, 2011

Create a file called “2 clés.html”, zip it up and, name the file html.zip then unzip it with the following command: unzip html.zip -d /tmp, check the /tmp folder, what do you see?... Read More

PHP email admin script

Friday, June 17th, 2011

If you’ve read the article about my email server setup you quickly realize that adding a new email account is quite onerous, a combination of adding records to tables in a MySQL database and creating folders on the harddrive. This can easily be automated with for instance PHP and I’ll show you how below.... Read More

PHP and setlocale – getting more locales than English to work

Monday, February 21st, 2011

Update I’ve had to revise this one, the original post might work (or not) if you have an older install of Ubuntu, atm (2013-02) I use Lucid, and now the following process works:... Read More

Parsing cookies with Zend Http Client and CookieJar

Tuesday, January 18th, 2011

I’ve just run into the need to be able to get the http cookies of a response to a request sent from PHP and accepted in PHP. Normally cookies can be accessed through the $_COOKIE super global but since no client/browser is involved that won’t be possible in this case. The below is an example of machine to machine communication.... Read More

MongoDB, Clojure, JSON and PHP – CongoMongo issues and solutions

Friday, December 31st, 2010

I’m currently working on a project where I use MongoDB and Clojure to create an API only type of service. Other sites of ours are connecting to this service, these sites are all made with PHP at the moment.... Read More

Random password generator in PHP

Monday, December 27th, 2010

When you want a random password you might think that for instance uniquid() is a good fit. It’s not though as it will only return hex characters.... Read More

Getting start and end date of week in PHP

Friday, November 19th, 2010

I just searched for ways of getting the start and end dates of a week. Sadly there is some less than simple solutions in the top results, this is a small effort at remedying that situation.... Read More

Generating extended MySQL inserts in PHP

Thursday, November 4th, 2010

Today I just realized I didn’t have any PHP code to generate extended MySQL inserts at my disposal. For heavy inserts I’ve been using BEGIN and COMMIT with lines terminated with ;. ... Read More