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…
Tag: PHP
PHP backend web language
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…
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…
How to easily find the php.ini file in use
A method to easily and quickly find what php.ini configuration file is loaded and in use. The php.ini file holds all of the configuration values for your PHP installation. It…
Using the Yahoo finance stock API with PHP
Using the Yahoo finance stock API to firstly get stock ticker symbols and then the stock price with PHP. The Yahoo finance API is a fast and free method to…
Stringgy a free use string and int generator API
Stringgy is a free to use string and int generator API with customizable lengths, types, characters and amounts. With Stringgy you have the option for character length of string or…
Catching PHP PDO exceptions
How to handle PHP PDO exceptions with the try and catch method to control the flow of any potential errors with PDO connections and queries. The try and catch exceptions…
PHP PDO MySQL Cheat sheet guide
PDO is a PHP extension for accessing and interacting with databases using object-orientation. As PDO is targetted for executing queries with prepared statements it is (with correct usage) safer than…