Tag: PHP


(Great, now I’ve got that Sum 41 track in my head… hmm quite catchy…)

Tuesday night is Louise’s ‘night out’ with our friend Susan. They go shopping, go to the cinema, or just veg out with facepacks and wine. I’m left at home (thankfully).

I usually have a few items that I want to get done, and spend a few minutes tidying up or doing the dishes before the night is really mine. I really should push on with the PHP thing, I’ve got a re-design to start (for another site: I said I’d have a BETA with them by Christmas last year.. oops), I’ve got episodes of the new Smallville season to watch, about five episodes of the new 24 season to get through, and all of Sopranos season 4 to watch.

I’ve also got a few things needing done to the home PC (finding the device driver that keeps crashing the system), the ‘collectorz’ cataloguing software glares up at me from it’s shortcut on my desktop demanding that I fill it with all my books, CDs, and DVDs. There is a stack of books waiting to be read, not to mention a few ‘kept’ bits from the Sunday papers, and several bookmarked ‘longer’ articles that I’ve been meaning to read for months.

I keep telling myself that I’ll do a little exercising as well, the free weights laugh at me as I stub my toe on them, and the Yoga and Pilates books chuckle quietly to themselves as I moan and groan whilst struggling to bend over far enough to untie my shoelaces.

And what will I do? I’ll plonk myself down in front of the telly, channel surf for a couple of hours, play a little Pro Evolution Soccer on the Playstation before heading up to the PC and surfing randomly for another hour or so.

Before I know it, Louise will be home asking me what I’ve done.

“This and that, nothing much really.”

Such is life.


[geek speak ahoy!]

Slowly ploughing my way through PHP tutorials, although I’d be a lot quicker if I actually followed them instead of scanning the page, and leaping off to edit the scripts I’ve created.

So far I’ve got a database created, populated, and can read records from it, displaying them on the page. Next step is to write to the database, and see if I can also send the form output to another form process. Then it’s just grabbing x of y records, and grabbing 5 random records… then a few criteria driven searches… and then… hmmm still quite a bit to do then…

Real life continues later.

Techie advice

MySQL. How do you setup a new database?

I know my host supports it, but that’s the limit of my knowledge. Rather than spend an evening aimlessly surfing I was kinda hoping someone out there would have some pointers/suggestions/offers of free help…

Answers in the usual place please.

[UPDATE: Found my hosts info on setting up PHP on MySQL, all is right with the world again. To those who have already commented, many thanks, I WILL be consulting you later on!]


Articles or news that is currently on my radar:
1. Wireless Network Security for the Home (in 6 Easy Steps!)
2. PHP/mySQL – I’m looking to setup a ‘membership’ site – see Chicago Bloggers for example – anyone got any suggestions?
3. Photography – at lunchtime I’ll be scouring the web for tutorials and the like. I did this a while back but my enthusiasm waned, my camera is capable of much more than I know.
4. ScorpioGirl – who makes it easier for us to find new websites by compiling a quick list. Ain’t she generous.
5. Wee David is back, and looking very nice too.
6. 3 columns… maybe…


I’ve recently rebuilt my PC, whilst doing so I took some extra time to clear out duplicate and old files and I came across the archives for this site, well what passes for archives at any rate as I’m not the most forward thinking or organised person.

Looking at those early attempts at HTML (via an angelfire home page.. then Xoom.. before my first ‘own’ page via LineOne) and how much I’ve learned since, made me realise that my ‘web tinkerings’ are actually a very good indication of my growth as a person.

I created my first website in late 1995 (I still have the certificate from the course I went on) for the company I was working for, it was cutting edge. It had frames, javascript mouseovers and coloured text; it was designed on a PC running Windows 95 BETA. It was a hodge-podge of borrowed ideas and hacked code but it did the job. At the same time I started creating my own pages, mainly just links of sites I admired, with a little blurb about me included. The design changed frequently as I used the site both as a resource for myself, and as an area to discover and tinker with the ever expanding HTML specification.

This version of my ‘site’ kept that format until 1998, then everything changed. Whilst surfing I started to notice more than just the design of a site, the clever use of tables and images or a nice colour scheme, I started to notice the content far more than I had previously. I had long since passed the point that I needed to think about how a nice design was done (ohhh 7 levels of nested tables with colspan=2, that’s clever) and found it cleared my mind to focus on the content. Move on another year or so and I started to notice how the design and the content were inseparable, Ask Tog, Use It and A List Apart became regular haunts, and CSS crept into view.

Zoom up to 2004 and look back. So much has changed, and in such a short space of time.

I can still remember my first day of my first job, meeting all those new people, being given a seat by the door in a small room at the back of a cottage outhouse. I can remember learning about my job, what a technical author does, what he needs to know, who he needs to know and how vital documentation is to a product. I can dream back to the good days at Dr.Solomon’s and Sage Tetra, and then amaze myself when I figure out I’ve been with my current company for almost 4 and a half years (and 4 changes of company name).

I can remember that first day, nervous, unsure and eager, then becoming comfortable and settled, learning but coping with each new challenge. The shock of being made redundant and job hunting, talking about moving down to the South of England, journeys on the sleeper to attend interviews, and finally starting a new job, a new home, a new chapter in my/our life. I remember the next chapter all too well, redundant again, sliding down into depression, then onto the new job, restarting everything in my life. Then the decision to move back to Scotland, for better or worse? Still to find that one out.

I grown and aged, matured slightly. Superficially nothing much has changed, when I started my first job I had a mortgage and was planning to get married. Almost 10 years later and I still have mortgage and I’m very happily married. But that’s a mis-representation of how I’ve grown. I’ve been through a lot of good and bad, learnt a lot (still learning!) and changed myself. I don’t think that process will ever stop, in fact I know it won’t ever stop as it’s my nature to challenge things, to question ideas, even if I don’t have the knowledge with which to challenge them properly.

Today things are much more confusing. We have CSS layouts, XML feeds, PHP, SQL databases and more to deal with, to learn about. We have their inadequacies and faults, quirks and mistakes to become accustomed to and I’m loving every second of it.

Today things are much more confusing. We have changing principles, challenges to our ethics, work and money worries and more to deal with, to learn about. We have our own inadequacies and faults, quirks and mistakes to become accustomed to and I’m loving every second of it.

I’m re-designing myself.

Me bad

Well it seems my ‘delving’ with PHP broke Blogger. Or something.

I’d like to apologise to everyone for screwing up their publishing system. Except you lot on MT, and all the other systems that I can’t be bothered naming.

Miniblog entries will be added throughout the afternoon, but other than that, I’m kinda busy.

(And of course, now that I’ve said that I’ll probably go on and post 3 or 4 times this afternoon.. it’s a curse…)


I’ll be mucking about with PHP tonight (my first ‘delve’… ohh what a great word, delvvveee, delve, DELVE!!, ddeeeeeeelve.. ahem where was I?) so the site may appear a bit wonky, hopefully not majorly so but I thought I’d best forewarn you, just in case you think it’s you that’s broken something.

… delve …