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

Posts in category: PHP & MySQL

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

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

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

Demos | Blog | PHP & MySQL | Tutorials

Creating a blog from scratch with PHP - Part 5 Sidebar, Categories and Archives

This part will add a sidebar to the blog and list latest posts, categories and archives.

David Carr

PHP & MySQL | Tutorials

Login and Registration system with PHP

This tutorial will cover creating a login system with registration upon registering an activation li...

David Carr

PHP & MySQL | Tutorials

Writing to an existing PDF with PHP

On a recent project I had the needed to modify an existing PDF, the modification would be done dynam...

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.