Archétype Informatique SARL web design, 12 place Balmigère, 11200 Camplong d'Aude, Aude, France. Tél. (France) 04 68 43 52 38
Category Archives: Web development
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
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
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
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
Saying no to spammers
These days practically every website has a “contact us” form allowing visitors to send email to the site owner without exposing the recipient’s email address to the world. Lately I’ve been investigating ways that spammers can hijack these forms to … Continue reading
Website planning: a blueprint for success
Once you’ve established the purpose of your website, and who will be using it, you can start to plan the basic structure of the site, which will determine the all-important site navigation system. Too many sites reflect the internal politics … Continue reading
Three questions to ask before you call your web designer
So you’ve decided to create a new Web site, or renovate your existing one. We all know that in Internet time, the best time to launch a new project is always last week, so it’s very tempting to plunge straight … Continue reading