24th Feb 2015 • David Carr How to backup and restore a MySQL Database I was recently asked how do backup and restore a database. As with most things in programming there... Read more
24th Feb 2015 • David Carr Beginner Guides The following is a collection of useful starter guides and tutorials. Read more
6th Nov 2014 • David Carr Upload multiple files with a single input with HTML 5 and PHP HTML 5 makes it possible to upload multiple files using a single input thanks for a new multiple att... Read more
5th Oct 2014 • David Carr 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,... Read more
20th Sep 2014 • David Carr Backup to Dropbox with PHP Recently I've been looking into Dropbox's API so I decided to have a go at building an appli... Read more
20th Sep 2014 • David Carr Running mysqldump with PHP Every project should have regular backups. Writing database tables to a file using PHP while possibl... Read more
12th Sep 2014 • David Carr Using closures and $this within a class with PHP Closures are really useful, especially for creating plugins when a full blown controller is not need... Read more
5th Aug 2014 • David Carr Get initials from a name Here is a simple way to collect the first letter of each word, This can be useful to get say a perso... Read more
23rd Jul 2014 • David Carr Quick way to add hours and minutes with PHP This post describes a very simple way to add or sub-tract time to a given time using the date and st... Read more
7th May 2014 • David Carr Form to CSV with PHP Outputting a forms contents to a CSV file is incredibly handy and easy to do, this post will cover t... Read more
5th May 2014 • David Carr Premium Display Xbox live data with xboxapi and cache it Xbox does not provide an official API for anyone to use. Their are a few sites that provide an API o... Read more
8th Apr 2014 • David Carr Macaw: Route closures and controllers Build the foundations of an application with the Macaw routing class to route requests to closures o... Read more
8th Apr 2014 • David Carr Collect remote CSV file and save to a local CSV file using PHP Here is a quick way to read a csv file hosted remotely, download its contents and store it to a loca... Read more
25th Mar 2014 • David Carr Retain rows when using a GROUP BY with GROUP_CONCAT Keep rows that would normally be lost when selecting rows using a COUNT and GROUP By. To keep say an... Read more
9th Mar 2014 • David Carr Creating a blog from scratch with PHP - Part 6 Pagination In this part pagination will be added to create the posts into pages, to limit how many posts are di... Read more