Author Archives: Craig Lotter

About Craig Lotter

Craig Lotter is an established web developer and application programmer, with strong creative urges (which keep bursting out at the most inopportune moments) and a seemingly insatiable need to love all things animated. Living in the beautiful coastal town of Gordon's Bay in South Africa, he games, develops, takes in animated fare, trains under the Funakoshi karate style and for the most part, simply enjoys life with his amazing wife and daughter. Oh, and he draws ever now and then too.

Display Embedded Photo EXIF data with PHP

Most digital cameras add EXIF (Exchangeable image file format) data to photos captured nowadays, embedding information like camera type, settings, timestamps, etc. into the captured file itself, and in the process creating a host of quite important (to enthusiasts anyway) bits of meta information in the process. Continue reading

Posted in PHP, Tutorials | Tagged camera, exif, exif_read_data, , | View Comments

Ubuntu: How to Show MySQL User Accounts via the Terminal

To get a list of user accounts on a MySQL server instance, we need to make a SELECT call to the mysql.user table. Continue reading

Posted in MySQL, Tutorials, Ubuntu | Tagged , show users, , , user accounts | View Comments

SQL: Toggle 1 and 0 Value in an Update SQL Statement

I tend to use a lot of tinyint columns as controllers for my database-held objects, usually sticking to the convention of 1 means on and 0 means off. In other words, the perfect target for a SQL toggle statement! Continue reading

Posted in MySQL, Tutorials | Tagged 1 or 0, , , | View Comments

Internet Explorer (IE) and the Cached .js File

Internet Explorer and pretty much all other modern web browsers make use of silent caching in order to streamline user experience. Of course, caching is a marvellous tool when needed, but also a frustrating one when you don’t want it turned on. Enter the humble .js javascript include file. Now IE likes to cache javascript .js file includes, but unfortunately unlike normal web pages, getting it to refresh its cached copy can sometime prove to be quite difficult to achieve.
Continue reading

Posted in Tutorials | Tagged .js, cache, force refresh, ie, , | View Comments
« Navigation »