The Blog of Hull based

Web Developer David Carr.

I blog about Web Development and Design.

Get Stated

Select previous and next rows in MySQL

Selecting previous and next rows based on the current row is a common task in most web applications, Take this blog when viewing a post, their are the previous and next posts available at the bottom of each post.

Read more

My TOP Sublime Text plugins

My favourite editor is Sublime Text I've tried other editors, no other editor can complete with both customisation and pure speed in my opinion. These are my most used plugins for day to day programming. (Some of these are ST2 only)

Read more

Backup to Dropbox with PHP

Recently I've been looking into Dropbox's API so I decided to have a go at building an application that can upload a file or an entire folder directly to Dropbox.

Read more

Running mysqldump with PHP

Every project should have regular backups. Writing database tables to a file using PHP while possible is not recommended, it's much better to use MySQL for that. 

MySQL has a function called mysqldump that exports a database to a file, this is ran using SSH. For those times when you don't have access to SSH here is a simple way to create a backup using mysqldump by running exec and passing in the command and the login credentials and lastly defining the name of the file to be created.

Read more

HTML5 support for older browsers

Sitepoint released a great post today HTML5 Forms: The Markup it explains the various input tags that can be used in HTML 5. Some of these are very useful such as range, date, datetime, datetime-local, week, color. Unfortunately most of these have mixed support across browsers IE is lacking the most.

Read more