Today’s web applications are becoming more and more advanced, and most of them are relying on data stored in databases. In most cases several queries have to be executed to get the initial data in the application, so a quick way to get this job done would be usefull. Thats why I’ve made this advanced PHP query function to use in my own projects, but I’m sure many of you will find it usefull too.

Some of its features are custom SQL parameters like LAST_INSERTED_ID or INSERT_ID_FROM(n), executing different queries in one line of code, quickly returning SELECT queries as arrays, returning the new ID as the query result for INSERT-statements and so on.


read more »

I’m currently working on a free visitor tracking system for a school assignment.
Which functions would you like to see in a tracking system ?

The system should be finished by march and will be posted on the website :)

This article has been posted on the official WordPress Codex

WordPress has introduced Custom Fields for some time now, but not many people seem to know how to use them. Today I’ll try to give you some enlightenment about this, and explain how they work or what they can be used for.

I’ve been using Custom Fields in my themes too, and have created a function which enables an unlimited amount of images, files, links, flying cows or *whatever* to be attached to your posts and pages.  There are probably alot more people that can benefit from this method, so feel free to use it. I’ll explain how to do this in this post.


read more »

Hola,

today I put the new website online, after a week of work.
I wanted a new website where the blog and personal items are seperated, and where there’s a spot for a diary ( this thing here ).

The idea behind this was that people who were just looking for information of whatever I blog about don’t get bothered by my personal things, but could find it easily if they wanted to know more about me. I’m pretty happy with the result :)

In the diary section I’ll write about my daily life (obviously), its mostly meant for the time I’m spending in South Africa. This way the people at home know whats keeping me busy and what I’m doing, and we’ll have a place to chat.

I’ve made a promise to myself to blog more often, mostly about code & development.  Hopefully the things I’ll blog about will come to use for some people, and I’m sure I’ll learn from it too.

In other news, I’ve created a Twitter feed for the website so you can follow my updates easily. You’ll find my updates on twitter.com/bydustdotcom or in the recent activity bar at the bottom. For those of you who don’t use Twitter, there’s an old-skool RSS-feed at bydust.com/feed/.

In my last paragraph here I’d like to ask you for feedback on this new design. If you have any remarks or changes you’d like to see, please share :)

Goodbye,

Nick