Black Friday sale is now on! 50% off Laravel: The Modular Way. Learn more

A Laravel and PHP Blog

PHP & MySQL | Tutorials

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,...

David Carr

Tools | Reviews | Development

My TOP Sublime Text plugins

My favourite editor is Sublime Text I've tried other editors, no other editor can complete with...

David Carr

PHP & MySQL | Tutorials | Social Media

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...

David Carr

PHP & MySQL | Tutorials

Running mysqldump with PHP

Every project should have regular backups. Writing database tables to a file using PHP while possibl...

David Carr

PHP & MySQL | Tutorials

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...

David Carr

PHP & MySQL | Tutorials

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...

David Carr

PHP & MySQL | Tutorials

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...

David Carr

HTML | Tutorials

HTML5 support for older browsers

Sitepoint released a great post today HTML5 Forms: The Markup it explains the various inpu...

David Carr

Reviews | Development | Design

HSAD Degree Show 2014 - Mini Review

I attended the Hull School of Art and Design Degree Show last night. Very please to say it was a gre...

David Carr

Demos | PHP & MySQL | Tutorials

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...

David Carr

Demos | PHP & MySQL | Tutorials

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...

David Carr

PHP & MySQL | Tutorials

Macaw: Route closures and controllers

Build the foundations of an application with the Macaw routing class to route requests to closures o...

David Carr

PHP & MySQL | Tutorials

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...

David Carr

PHP & MySQL | Tutorials

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...

David Carr

Demos | Blog | PHP & MySQL | Tutorials

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...

David Carr

Help support the blog so that I can continue creating new content!

Subscribe to my newsletter

Subscribe and get my books and product announcements.

Facebook Twitter GitHub YouTube

© 2009 - 2022 DC Blog. All code MIT license. All rights reserved.