Posts in category: PHP & MySQL

PHP & MySQL

PHP Generate a UL menu from an array

Take an array and build a menu UL list from it. The array should support top-level as well as child...

David Carr

PHP & MySQL

Use PHP to generate table of contents from heading tags

I wanted to create a table of contents from the post's heading tags automatically without having...

David Carr

Tutorials | PHP & MySQL | Laravel Framework | Laravel Livewire

Laravel Livewire update dependent select menu's on change

Since Livewire is reactive, it's easy to hide or show select menu's based on whether another...

David Carr

API | PHP & MySQL | Tutorials

Create Bitly short links with PHP

Bitly is a great tool for creating short links, in this post we will use their API to generate links...

David Carr

PHP & MySQL | Tutorials

How to rebuild search indexes on a table.

If you make server changes that could affect your indexes then you will need to rebuild your in...

Dan Sherwood

PHP & MySQL | Tutorials

Robust CSV export

This article will show you how to export data to a CSV format inside a PHP based project. 

Dan Sherwood

PHP & MySQL | Tutorials

Format Xero dates from the API

Dates in Xero that are not already set to a datestring are in a format like Date(1518685950940+0000)

David Carr

Tutorials | PHP & MySQL | Laravel Framework

Get the last day of the month from a date

To get the last day of the month use date('t')

David Carr

Tutorials | PHP & MySQL

ASCII to Binary in PHP

Recently I inherited a project where all file attachments were stored in a database table in the for...

David Carr

Development | Tools | PHP & MySQL

Converting MSSQL to MySQL

Need to convert MSSQL to MySQL, this post will point you in the right direction.

David Carr

Tutorials | PHP & MySQL

MySQL 8 The server requested authentication method unknown to the client

Solution for MySQL 8 using unknown authentication method.

David Carr

PHP & MySQL | Tutorials

Writing to an existing PDF with FPDI

FPDI allows existing PDF's to be used as a template for a new PDF.

David Carr

PHP & MySQL | Tutorials

Easily assign variable when using explode in PHP

I use explode all the time, for splitting strings into parts, there is a cleaner way......

David Carr

PHP & MySQL | Javascript | HTML | Tutorials

Latitude and Longitude with Google Maps

Google Maps allows using its service to get map coordinates....

David Carr

Laravel Framework | PHP & MySQL | Tutorials

Laravel Merge PDFs

Ever needed to merge multiple PDF's together? It's a common need. In this tutorial, I'll...

David Carr

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

Fathom Analytics $10 discount on your first invoice using this link

Subscribe to my newsletter

Subscribe and get my books and product announcements.

© 2006 - 2023 DC Blog. All code MIT license. All rights reserved.