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,…
Tag: How to
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…
Changing video framerate with FFmpeg
Changing a videos frame rate can be easily done with FFmpeg. From the official FFmpeg documentation to change frame rate -filter:v fps=fps=25 is required. If inputvideo.mp4 was 60fps and I…
MySQL Inner join with a COUNT and GROUP BY
How to do a MySQL Inner join combined with a COUNT and GROUP BY. Assuming there are two tables with one having details about “posts” and the other “categories” each…
A method to check host name network status with PHP
This is a method to check if a host name is accessible i.e it is online, by using PHP. With fsocketopen() a connection will be created, if it fails false…