Daipratt - daipratt.co.uk - David Pratt
General Information:
Latest News:
Exporting data from SQL Server Express 2005 to CSV using PHP 10 Jun 2011 | 08:55 pm
Annoyingly, one of the limitations of SQL Server Express 2005 is that it doesn’t allow you to export data as CSV, or any other format (bar SQL) for that matter. This is fine is you have a small datase...
Wget examples for a Linux newbie 6 May 2011 | 07:42 pm
Having ditched Windows entirety at the start of the year and made the switch to Linux (Ubuntu flavour), I’ve discovered a range of tools that would have come in very handy in my days as a Windows user...
Using FB.api to make a full post to a users wall 26 Sep 2010 | 10:43 am
I just thought I’d make another quick post about the Facebook Graph API seen as there seems to be so little documentation and examples for it. The below example shows you how to make a full wall post ...
Create a Facebook page that shows a different version to those that “like” it 17 Sep 2010 | 07:58 pm
Continuing on the Facebook theme from by previous post about how to create a Facebook photo album and insert photos into it using PHP, I thought I’d share another Facebook technique that I’ve used a f...
Create photo albums and upload photos using the Facebook Graph API 12 Sep 2010 | 04:08 am
UPDATE: Thanks to some of the comments below I have been able to revise the code – thanks Luke & Guilherme I thought I’d share some recent learning’s with using the Facebook Graph API as there seems ...
Best way to store IP addresses in MySQL 10 Aug 2010 | 08:53 pm
It’s tempting to store IP addresses in a database as a VARCHAR(15) in the absence of a dedicated IP address field type in mysql, but that isn’t the most efficient way of doing so. The best way that I’...
Non-standard page size’s in TCPDF 24 Jun 2010 | 06:11 am
If you need to create a PDF using TCPDF that isn’t a standard size (A4, A5, B1, LETTER etc.) then it is possible to specify a custom size even though it isn’t that well documented. To do this you need...
Using Crontab with Plesk to call PHP files 7 May 2010 | 06:39 am
Having battled with getting a php file to be called from a scheduled task (a.k.a. a crontab task) using the Plesk interface panel on a Linux box, I thought I’d share a bit of a how-to on it because I ...
Calculate text width and height with JavaScript 22 Apr 2010 | 08:43 pm
Occasionally when putting together an advanced layout it’s necessary to have a level of control over the UI that can’t be achieved with CSS alone. One situation might be in displaying a place name. S...
A few things to consider when developing on a public domain 15 Mar 2010 | 04:07 am
If you ever find yourself developing a site on a public facing domain, it is always a good idea to have measures in place to prevent search engines indexing it in the event that a stray link enables a...
