Setting the CPU speed frequency on dedicated server
Fixing a dedicated server CPU not running at full max speed by setting an upper and lower limit with cpufrequtils. A processor will scale for certain reasons like power consumption,…
Tag: How to
Wget cut directory and no host command
When doing a recursive download with Wget the whole directory structure is saved, starting with the domain/hostname and then working down the directory tree inside it. Preventing this action and…
Creating folders, renaming and deleting with BunnyCDN PHP API class
Following on from this post, I use the BunnyCDN PHP API class to create folders, delete and rename files in a Storage zone. Setting my imageBackups Storage zone user and…
Uploading files to BunnyCDN Storage Zone with PHP API Class
The BunnyCDN PHP API class can do many tasks without having to log into BunnyCDN and use the browser GUI. In this post I go through creating a Storage Zone,…
How to run a PHP script every 10 seconds
Whilst using cron to call PHP scripts allows for intervals as low as 1 minute sometimes you may need a lower rate, here is how to call a PHP file…
Save Linux command output to file
When running a command in SSH the outcomes and/or actions get displayed in the terminal. Certain commands spill over too many lines and get cut off, the solution to this…
Forecast and current weather data with OpenWeatherMap API PHP
OpenWeatherMap provides a free tier weather API that is detail-packed and easy to use. The API outline can be seen here, In this post I will cover the current weather…
PHP PDO INSERT on duplicate UPDATE
A MySQL INSERT on duplicate key UPDATE is an all-round excellent query because if a key already exists it will update set values instead of inserting or returning an error….
Show MySQL tables, column names, types and more with PHP
Showing a MySQL database tables with their columns, type, keys and more is done using the MySQL SHOW syntax. For the tables SHOW TABLES is used whilst to get the…
PHP PDO MySQL cheat sheet
PHP PDO is a MySQL handler which uses object orientation. As PDO executes queries with prepared statements it is (with correct usage) safer than MySQLi. Below is the PHP PDO…