Archive for the ‘Quick Tips’ Category

Using $_GET with php Include() function

Using $_GET with php Include() function

Posted on: January 27th, 2012 by deanpugh No Comments

Admittedly, this probably doesn’t come up alot for people, but recently I have been creating a project management system for someone and am trying to make it as user friendly as possible using all my known tricks. I want to use an Include function for php when a page loads, but this page doesn’t include [...]

Auto Email Web Page Errors

Auto Email Web Page Errors

Posted on: January 23rd, 2012 by deanpugh No Comments

I nice feature that I found recently on NetTuts was a way to keep informed of error messages. We all know customers never write down error message in detail, or can remember exactly what they were doing so that you can reproduce the error message. This function allows you to display an nice alternative for [...]

Online Testing With jsfiddle.net

Online Testing With jsfiddle.net

Posted on: December 16th, 2011 by deanpugh No Comments

A website that I recently found very useful was the JS Fiddle website. It basically sets up a test area for you to try out simple bits of code, saving you the time or creating a test area. It also has the nice feature of being able to set up as different versions of HTML, [...]

Calculations To Scale An Image

Calculations To Scale An Image

Posted on: November 9th, 2011 by deanpugh No Comments

A couple of times I have had to deal with images in my code. Recently I had a project that needed the user to upload an image, which then needed to be scaled down to fit an area. Below I detail the calculations that I used. For this demonstration we will be using an image [...]

Pre Check Form Before Submit

Pre Check Form Before Submit

Posted on: November 8th, 2011 by deanpugh No Comments

Below is a script to allow you to run a precheck function in Javascript, preventing the form from submitting if you detect a problem. First, in a separate, external Javascript file, copy the below script: The above code is checking a checkbox value in the sent form to see if it has been selected. If it has, then [...]

Domain Name Wars

Domain Name Wars

Posted on: November 7th, 2011 by deanpugh No Comments

A interesting article recently appeared on the BBC Website recently which I thought was rather interesting. It details a few occasions when the ownership of domain names are disputed in the UK by Nominet. I must point out that this article isn’t about when someone has been accused of stealing a domain name. It’s when [...]

Select a Range in MS SQL

Select a Range in MS SQL

Posted on: November 4th, 2011 by deanpugh No Comments

Selecting a range from a table is easy in MYSQL. Say you want to bring back results that you are paginating. Bringing back thousands of results is inefficient and needless. MS SQL there isn’t a simple way of doing this. The best way I have found, or my colleague Daniel has found, is to wrap [...]

Quick SQL Copy Table

Quick SQL Copy Table

Posted on: November 3rd, 2011 by deanpugh No Comments

Just a quick SQL tip that I have been using recently, and is aimed mainly at MS SQL, but I cant see any reason why this wouldn’t work on MY SQL, except for the fact the MY SQL has easier Backup facilities. The background for this is that I was making changes to a table, [...]

SQL Entry Shortcuts

SQL Entry Shortcuts

Posted on: October 9th, 2008 by deanpugh

If you manually edit SQL tables, then shortcuts can become handy. I knew of a few, but had to do a quick search today when I wanted to use them to refresh my memory. If you want to enter in a Null into the table, then ctrl + 0, then if you want to remove [...]

Trace IP Route

Trace IP Route

Posted on: July 29th, 2008 by deanpugh

A windows command that I recently discovered that has been around for ages is Trace Route. I was trying to connect to a server recently, but was having problems, and the tech guy I was talking to showed me what to do. Open up a dos window, and type: tracert -d 192.00.00.00 Replace the above [...]