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…
Tag: Web Dev
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…
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….
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…
Downloading Reddit video with FFmpeg
v.redd.it is Reddits native video uploader and player, with the free Reddit API endpoint and FFmpeg you can download v.redd.it videos easily. If you prefer a more automated web system…
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…
Variable naming helpers
Browsing Hacker News i saw a link to variable naming helpers. Variable naming doesnt have a defined correct method. Its up to the creator to choose one (that should be…
PHP jpg compression Imagick vs Vanilla
Compressing a jpg file in PHP can be done without installing a third-party library, we call this method Vanilla as it is done stock standard, no extras needed. Imagick is…