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….
Category: Development
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…
Understanding CPU server load
Server CPU load is the amount of CPU tasks waiting to be processed and running, The outcome is relative to the amount of CPU available. A load of 1 when…
The main HTTP status codes
HTTP status codes are issued by a web server in response to a clients action. Simply going to a URL and fetching resources like images, styling and scripts will return…
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…
PHP PDO check if row exists or found
Counting or checking if your PDO MySQL query found a row relies on one key object called rowCount. rowCount returns the number of rows affected by the last executed query….
Creating PHP cron jobs on Ubuntu
Running cron jobs on your Ubuntu server to call PHP scripts in a timely manner. The first step would be creating a PHP file that when called will leave proof…