Links roll
Archétype Informatique SARL web design, 8 bd Châteaudun, 11200 Lezignan-Corbières, Aude, France. Tél. (France) 04 68 70 47 52
Author Archives: Veronica Yuill
PHP: is it a leap year?
I’ve written about date manipulation in PHP before. There are some truly horrible hacks out there. Today I needed to detect whether a given year was a leap year, in order to write future-proof code for a calendar. PHP has … Continue reading
Amarok and network shares on the eee PC
The eee now spends most of its time being used as a convenient way to play music through the stereo. This means it needs to mount the shared directory on the server downstairs that contains all the music. This caused … Continue reading
SQL query to find duplicate rows
This is one of those things I can never remember how to do when I need to do it. I don’t know why, it’s really quite simple: SELECT emailaddress, firstname, lastname, COUNT(emailaddress) FROM customers GROUP BY emailaddress HAVING COUNT(emailaddress) > … Continue reading
Chocs To Go is here!
The goal for students on the intermediate PHP and MySQL course that I’m running for IWA/HWG is to create a working shopping cart. The course starts in only three days, and I decided I’d better walk the walk and prove … Continue reading
Another handy SQL Server utility
Why doesn’t SQL Server come with a built-in method for generating SQL dump files so you can easily port your data to another database? Microsoft in its own little walled garden I suppose; while the facilities in Enterprise Manager for … Continue reading
Intermediate PHP and MySQL course
Since 1999 I’ve been teaching online for the Open University. It may not pay brilliantly, but it’s regular income and I really enjoy doing it; OU students often overcome major barriers to achieve a qualification they missed out on earlier … Continue reading
Date handling in PHP and MySQL
It’s always a real headache manipulating dates between PHP and MySQL, because PHP’s date functions assume Unix timestamps, while MySQL has its own internal date format. They both have excellent built-in functions for handling dates, but they are fundamentally incompatible. … Continue reading
SQSH!
About the only reason I ever boot into Windows on the spare PC nowadays is because I need to use Enterprise Manager or Query Analyser to manage a SQL Server database. Today it was inconvenient to reboot, because I was … Continue reading
Downright Slippery Time
Want to add one (or more) days to a date in PHP? Timestamps are simply numbers of seconds, so it seems so easy and obvious to do this: $mydate = (60*60*24)+$mydate; or even just $mydate = 86400+$mydate; Don’t be tempted! … Continue reading
Posted in PHP, Web development
1 Comment
Networked file sharing between Windows and Linux
The scenario: a mixed network of Windows and Linux PCs (2 Windows XP, one Xandros, one SimplyMEPIS) which need access to edit files in a directory on one of the Linux servers. Here’s what I did: I’m not sure all … Continue reading