The Relational database model
The Relational database model or schema is one that uses many tables that are all related to each other, hence the relational name tag. With the data all being related…
Category: Development
Load and execute SQL files with PHP
How to load a SQL query from a file instead of having an inline query. This is done to help with formatting and easier understanding of the code. All that…
Doing MySQL insert from a PHP loop the right way
Effectively manage PHP MySQL inserts from a large loop using the PDO connection. The key is to avoid committing data on each loop, this is done using a transaction. Use…
How to enable GD Library with XAMPP PHP 8 on Windows
How to enable the GD image library for PHP 8 with XAMPP on Windows. All that’s needed is a simple php.ini file edit. Enable GD PHP 8 XAMPP To enable…
PHP PDO MySQL backup script with compression option
Modern PHP PDO MySQL database backup script which includes a gzip compression option. Modified from this Stack Overflow post, the script is easy to use with configurable options for the…
PHP isset() vs empty() vs is_null() comparison
A PHP isset, empty, and is null helper function comparison with a table for variables and common types. Quick rundown isset() returns true when the variable has a value, is…
Easy Chart.js Bar charts with PHP and MySQL
A shortcut method to quickly creating dynamic Chart.js bar charts using PHP and data from a MySQL database. This blog post is for a single Y-axis bar chart. Gist link….
Reading large files in PHP with SplFileObject
Efficiently load and read from large files in PHP with the built-in SplFileObject class. fopen() becomes very slow and bogged down once the file size starts getting above a couple…
The SQLite3 data types
The handful of SQLite database column data types for storing, Unlike the vast amount of data types MySQL accommodates, SQLite only has 5 types. A simpler and more refined approach…
SQLite3 with PHP; Creating a database and connecting to it.
SQLite is a serverless, self-contained database that in practice works straight out of the box. With no need to install or run to access and use. The SQLite library is…