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…
Tag: PHP
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…
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…
Compress image if certain size in PHP
If you are downloading and archiving images majority of the time you can compress them heavily to be able to store more. For reasons such as: never viewing the image…
PHP OOP Setters and Getters
Setters and Getters in PHP are object methods used in OOP programming. The basis being you set a property to your value and then you can get it. Using setters…
One hundred and two million unique strings
Using mixed character strings to identify objects makes more sense due to the greater amount you can assign and their complete unpredictability. Why strings? Using numerals 1 through to 234,567,890…