Author Archives: Veronica Yuill

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

Posted in Databases, Web development | Tagged , | Leave a comment

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

Posted in Databases, PHP, Web development | Tagged , | Leave a comment

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

Posted in Databases, PHP, Web development | Tagged | Leave a comment

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

Posted in Databases | Tagged , | Leave a comment

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 | Leave a 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

Posted in Linux | Tagged , , | Leave a comment

How to install ODBC on Linux

I have been looking for a while for a tool to create Entity Relationship Diagrams (ERDs) on Linux. On Windows I used Dezign for Databases, an excellent tool which I would still be using if it was available for Linux. … Continue reading

Posted in Databases, Linux | Tagged | Leave a comment

Scriptaculous without Javascript

Scriptaculous is one of the better-known Javascript/AJAX libraries, with useful built-in objects for adding Web 2.0 functionality to your pages. I’ve tinkered with it but hadn’t found a real-life application for it until I needed to allow a client to … Continue reading

Posted in Javascript, PHP | Tagged | Leave a comment

Neat tricks with Oracle

The task: provide a neat hierarchical tree as a web interface to a project management system where any project might have a variable number of sub-projects. A tree structure in other words. So I ended up with this: ID Project … Continue reading

Posted in Databases, Javascript, PHP, Web development | Tagged , | Leave a comment

Bound to succeed

I’ve been developing websites with PHP for about 5 years now and I blush to confess that I have only just discovered I can use bind parameters with SQL, instead of painstakingly building up my SQL statements by concatenating strings, … Continue reading

Posted in Databases, PHP, Web development | Tagged | Leave a comment